A place to find insight into SQL
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 already have in SSMS. From 9 to 5 PM it is one of your very best opportunities to learn a lot of new things, develop professionally, meet new people, enjoy a free lunch and…have a great time!
SQL Saturday, Jacksonville 2016
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 party. What could be better than that? I will be speaking on a “How SQL 2012 Empowers BI in Sharepoint”.
Introduced in sql 2005 the following query will tell you the date your statistics were last update for each of indexes of a table… Continue reading “When were your statistics last updated?”
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 was taking 20 minutes now takes 1 minute.
Enjoy!
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.
How do you interpret the value you get back for any particular performance counter?
May 11, 12, 13. Steve is presenting on performance tuning in Orlando.