Browse by Tags

SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario

Published 17 January 8 2:23 AM | SSQA.net

Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices...

Filed under: sql server, performance, msdn, blocking, maintenance plan, tempdb, tablesample, best practice, monitoring, FAQ, benchmarking, table variable, temp tables

WRITELOG wait types - what your SQL Server is saying?

Published 12 October 7 7:41 AM | SSQA.net

Whenever the SQL Server is struggling to write the transactions to the disk, you would observe WRITELOG wait type within SP_WHO2 results. So when you observer such wait types then you should be worried on the disks performance, either you plan for shrinking...

Filed under: sql server, performance, transaction log, disk space, tablesample, writelog, wait type

SQL Server 2005 Query optimization issue : limit affected rows on a large volume table?

Published 10 July 7 5:40 AM | SSQA.net

If you have a huge volume of table (say millions of rows) and a requirement to limit x number or sample of rows from a query every time you execute. To limit number of rows then you would think about [ select ... from (select top 100 * from X order by...

Filed under: sql server, performance, query, cache, top, tablesample