Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • Performance Tuning

Category: Performance Tuning

SQL Saturday May 2016, Jacksonville, FL

April 1, 2016 Steve Schneider

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…

Read more

Azure, Career, Performance Tuning, PowerBI, SQL Administration, SSAS, SSIS, SSRSLeave a Comment on SQL Saturday May 2016, Jacksonville, FL

SQL Saturday Jacksonville, May 10, 2014

April 28, 2014 Steve Schneider

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…

Read more

Azure, Career, Performance Tuning, PowerBI, SQL AdministrationLeave a Comment on SQL Saturday Jacksonville, May 10, 2014

When were your statistics last updated?

March 30, 2012 Steve Schneider

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

Performance Tuning, SQL 2005, SQL 2008Leave a Comment on When were your statistics last updated?

MSDB db too big?

January 10, 2012 Steve Schneider

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…

Read more

Performance Tuning, SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on MSDB db too big?

See your servers’ performance real-time

July 20, 2011 Steve Schneider

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.

Performance Tuning, SQL 2005, SQL 2008, SQL AdministrationPerformance, SSMSLeave a Comment on See your servers’ performance real-time

Performance counter types

April 22, 2011 Steve Schneider

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

Performance Tuning, SQL 2005, SQL 2008PerformanceLeave a Comment on Performance counter types

SQL PASS Rally

April 21, 2011 Steve Schneider

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

Performance TuningPerfmon, Performance Counters, Performance Tuning, SQL 2005, SQL 2008Leave a Comment on SQL PASS Rally
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes