Category Archives: Performance Tuning

SQL Saturday May 2016, Jacksonville, FL

Hey, Everyone… our annual get-together of SQL professionals is happening on May 7th, at UNF, here in Jacksonville.  I will be speaking at 9 AM on breaking into the world of Azure & PowerBI, using (mostly) the skills you likely … Continue reading

Posted in Azure, Career, Performance Tuning, PowerBI, SQL Administration, SSAS, SSIS, SSRS | Leave a comment

SQL Saturday Jacksonville, May 10, 2014

Hey, everyone! There’s a great event here in Jacksonville, Florida. It’s coming in May. It is like a mini Tech-ed. Free Food. Great Technical presentations.  Click the picture to the right to register! Lots of networking. Fellowship. Swag. After hours … Continue reading

Posted in Azure, Career, Performance Tuning, PowerBI, SQL Administration | Leave a comment

When were your statistics last updated?

Introduced in sql 2005 the following query will tell you the date your statistics were last update for each of indexes of a table…

Posted in Performance Tuning, SQL 2005, SQL 2008 | Leave a comment

MSDB db too big?

Microsoft provides “sp_delete_backuphistory ‘6/1/2011’“.   However, this can take a very long time unless you also add indexes to the backup table.  This is what did the trick for me: Create Nonclustered index idx_backupset_finishdate ON backupset (backup_finish_date) INCLUDE (backup_set_id, media_set_id) What … Continue reading

Posted in Performance Tuning, SQL 2005, SQL 2008, SQL Administration | Leave a comment

See your servers’ performance real-time

I have posted an article to enable you to compare your servers’ performance in real time.  It’s one of my favorites.  It won’t run on systems older than 2005.  You’ll find it here.

Posted in Performance Tuning, SQL 2005, SQL 2008, SQL Administration | Tagged , | Leave a comment

Performance counter types

Learning about Performance Counters How do you interpret the value you get back for any particular performance counter?

Posted in Performance Tuning, SQL 2005, SQL 2008 | Tagged | Leave a comment

SQL PASS Rally

May 11, 12, 13. Steve is presenting on performance tuning in Orlando.

Posted in Performance Tuning | Tagged , , , , | 2 Comments