Monthly Archives: October 2010

3 Problem Solving Resources That Make You Look Like A Genius 3 Problem Solving Resources That Make You Look Like A Genius … http://sqlmashup.posterous.com/mjswart-posts-3-problem-solving-resources-tha

Common SQL Server Mistakes – Functions in the WHERE Clause Common SQL Server Mistakes – Functions in the WHERE Clause … http://sqlmashup.posterous.com/way0utwest-posts-common-sql-server-mistakes-f

Statistics VS Index Rebuild Statistics VS Index Rebuild … http://sqlmashup.posterous.com/mcflyamorim-posts-statistics-vs-index-rebuild

Useful, free resources for SQL Server Useful, free resources for SQL Server … http://sqlmashup.posterous.com/aaronbertrand-posts-aaron-bertrand-useful-fre

How to tell which version of SQL Server data access driver is used by an application client How to tell which version of SQL Server data access driver is used by an application client … http://sqlmashup.posterous.com/kun-cheng-posts-how-to-tell-which-version-of

SQL SERVER – ORDER BY Does Not Work – Limitation of the View 1 SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the View 2 SQL SERVER – Index Created on View not Used Often – Limitation of the View 3 SQL … Continue reading →

Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 – Index Usage Index Black Ops Part 4 – Index Overhead and Maintenance Index Black … Continue reading →

Performance Data Collection (Part 1 of 2) Performance Data Collection (Part 2 of 2) Performance Data Collection (Part 1 of 2) Performance Data Collection (Part 2 of 2) … http://sqlmashup.posterous.com/billramo-series-performance-data-collection-s

Fun with software : uninstalling SQL Server 2008 R2 Evaluation Edition Fun with software : uninstalling SQL Server 2008 R2 Evaluation Edition … http://sqlmashup.posterous.com/aaronbertrand-posts-aaron-bertrand-fun-with-s

What are all these reports anyways? What are all these reports anyways? … http://sqlmashup.posterous.com/billramo-posts-what-are-all-these-reports-any