Blogs

Browse by Tags

• DBA
• Performance Tuning
• SQL 2000
• SQL 2005
• SQL 2008
• SQL Tips

• Checking EXISTS – What’s Your Practice?

  Michael Swart ( Database Whisperer ) posted a great write up and interview with Brad Schulz that is worth checking out.  Michael’s post links to a post from Brad on the use of EXIST and what is required for the SELECT portion of the statement .  Read More... Posted Tuesday, October 06, 2009 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQL 2000, Best Practice, SQLServerSyndication, SQL Tips

• 5 Common Mistakes with Tempdb

  One of the things I get to do pretty often is to visit with clients and discuss how they’ve implemented their SQL Server environment.  And if the title of this post is any indication of the contents there are a number of issues that I tend to be Read More... Posted Wednesday, July 08, 2009 12:00 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Best Practice, Performance Tuning, SQLServerSyndication, SQL Tips, DBA