Frank Kalis

Subqueries in BETWEEN and CASE Statements

Jul 21st

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/craigfr/archive/2008/06/27/subqueries-in-between-and-case-statements.aspx

between, case, query

Microsoft Security Bulletin Summary for July 2008

Jul 9th

Posted by Frank Kalis in SQL Server

http://www.microsoft.com/technet/security/bulletin/ms08-Jul.mspx

SQL Server I/O Bottleneck, I don't have one, YES YOU DO!

Jul 9th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/psssql/archive/2008/07/08/sql-server-i-o-bottleneck-i-don-t-have-one-yes-you-do.aspx

troubleshooting

Performance Impact: Bookmark Lookup is Expensive - Even in Memory

Jul 7th

Posted by Frank Kalis in SQL Server

http://sqlblog.com/blogs/linchi_shea/archive/2008/07/06/performance-impact-bookmark-lookup-is-expensive-even-in-memory.aspx

SQL Injection

Jul 2nd

Posted by Frank Kalis in SQL Server

http://blogs.technet.com/andrew/archive/2008/07/01/sql-injection.aspx

Installing Clustered SQL Servers - Outline, Checklists, Document Sheets

Jun 30th

Posted by Frank Kalis in SQL Server

http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/06/29/installing-clustered-sql-servers-outline-checklists-document-sheets.aspx

Subqueries in BETWEEN and CASE Statements

Jun 30th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/craigfr/archive/2008/06/27/subqueries-in-between-and-case-statements.aspx

case, execution plan, query

Differences between ISNULL and COALESCE

Jun 27th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/sqltips/archive/2008/06/26/differences-between-isnull-and-coalesce.aspx