SQL Consulting: SQL Server Is Our Only Business.
In my work as a SQL Server consultant I have viewed hundreds of SQL Server maintenance plans. I have seen a lot of good plans but I still see the same old problems in a significant number of plans. In …
Continue Reading about Avoid These Maintenance Plan Problems →
A few days ago I went to the SQL PASS group meeting to hear Vern Rabe talk about the perils of NOLOCK. Vern is a veteran SQL guru. After 20+ years he still spends a lot of his time in airplanes going …
A Correlated View For Performance Tuning Imagine that you are experiencing sporadic high CPU use by your SQL Server and you need to find the query or queries that are causing the problem. You might …
Continue Reading about Using Performance monitor for correlated output. →
The default trace has been around for a long time. SQL Server's default trace was introduced in SQL 2005 to supply data for the new performance and auditing reports available through the Management …
Continue Reading about Using fn_trace_gettable and the Default Trace to monitor SQL Server →
Forwarded records often cause query performance that is hard to understand and thus harder to fix. The indexing may be correct. There may be no problem with memory, disk or CPU. the query may be …
Every few years in this newsletter I like to bring up the subject of SQL Injection because it is so vitally important to anyone who is charged with securing a SQL database. In my consulting work, I …
