Frank Kalis

Ordering Guarantees in SQL Server 2005

Nov 6th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/queryoptteam/archive/2006/05/02/588731.aspx

Distinct Aggregation Considered Harmful

Nov 6th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/sqlqueryprocessing/archive/2008/09/22/distinct-aggregation-considered-harmful.aspx

New update on minimal logging for SQL Server 2008

Nov 6th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/10/24/new-update-on-minimal-logging-for-sql-server-2008.aspx

SQL Server 2008 Security Whitepapers

Nov 6th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/sqlsecurity/archive/2008/10/06/sql-server-2008-security-whitepapers.aspx

How it Works: SQL Command Mode Parsing

Nov 6th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/psssql/archive/2008/09/18/how-it-works-sql-command-mode-parsing.aspx

What is the difference between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats?

Nov 6th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/craigfr/archive/2008/10/30/what-is-the-difference-between-sys-dm-db-index-usage-stats-and-sys-dm-db-index-operational-stats.aspx

Random Prefetching

Nov 6th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/craigfr/archive/2008/10/07/random-prefetching.aspx

More Business Logic Validation

Nov 6th

Posted by Frank Kalis in SQL Server

http://blogs.msdn.com/conor_cunningham_msft/archive/2008/10/31/more-business-logic-validation.aspx