Browse by Tags

• benchmarking
• best practice
• blocking
• cache
• disk space
• FAQ
• maintenance plan
• monitoring
• msdn
• performance
• query
• sql server
• table variable
• temp tables
• tempdb
• top
• transaction log
• wait type
• writelog

SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario
17 January 08 01:23 AM | SQL Master | 2 Comments   

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.aspx Read More...

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

WRITELOG wait types - what your SQL Server is saying?
12 October 07 05:41 AM | SQL Master | 2 Comments   

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 Read More...

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

SQL Server 2005 Query optimization issue : limit affected rows on a large volume table?
10 July 07 03:40 AM | SQL Master | 1 Comments   

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 Read More...

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