SQL Server Performance Blog

Excerpt posted by Andy Warren’s blog: Idera announced their ACE Program on Monday, a new effort to do more community outreach in a way a bit different than others have done it so far. Rather than the traditional evangelist/vendor rep model for participating in events, this program will have six members of the community that [...]

  Idera is giving away a free trip for two on the Alaska SQLcruise (including airfare)!  Here are the details on how you can win! SOLVED A BEASTLY PROBLEM THAT WAS PLAGUING YOUR SERVERS FOR DAYS, WEEKS OR MONTHS? DID ANYONE AROUND YOU REALIZE JUST HOW COOL AND AWESOME YOUR SOLUTION WAS? NOW’S YOUR CHANCE [...]

By Michael Campbell, March 14, 2011 Performance tuning tips come in many different shapes and sizes. Some represent technical ‘deep-dives’ into aspects of how SQL Server’s storage engine or query process tackles certain tasks – while others represent simple (or even complex) best practices for avoiding certain behaviors or problems. The key thing that all [...]

Donabel Santos (twitter (@sqlbelle) | blog) – February 09, 2011 When first installing SQL Server, many developers and DBAs new to SQL Server may have the temptation to click Next, Next, Next on the installation wizard. However, it is of utmost importance to pay close attention, and be conscious, of options that you choose. We [...]

Brett Hawton – 25 October 2010 The table variable was introduced way back in SQL Server 2000. However many older “legacy” applications using TSQL don’t make use of it and instead use temp tables. Indeed even a number of more recently written applications I reviewed still continued to use temp tables. This article attempts to [...]