Hartford, CT – Hartford SQL Server User Group – Query Tuning without Production Data (session page & materials)
Do not use percentage based auto-growth Having autogrowth enabled on your SQL Server instance is great! Even in IT shops where you diligently right-size your database files (which is a good idea),…read more →
Non-Clustered Indexes in SQL Server In the last post of this blog series, I discussed what a clustered index is and how to choose an ideal clustered index key. In…read more →
Counting NULLs and sub-sets of data Quick Tip: Counting NULLs and sub-sets of data You have been asked to produce a chart which will visualize a few data points. Total work…read more →