Blogs

Browse by Tags

• Best Practice
• DM Views
• Performance Tuning
• SQL 2005
• SQL 2008
• SQL Tips

• Grouping and Rounding Dates

  Ever need to group dates and round them to intervals?  I had this exact need for a report on wait stats I was working on for an upcoming post.  I wanted the flexibility to be able to group a list of dates by either minute, hour, date, etc.  Read More... Posted Wednesday, March 10, 2010 8:00 AM by Jason | 1 Comments Filed under: SQL 2005, SQL 2008, SQL 2000, SQLServerSyndication, 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

• Analyze This – Analyze Your Indexes – Part 3

  This is the third post in which I am walking through a query that I use to analyze indexes.  Thus far I have added to the following to the query that I use: Combine existing index statistics and missing indexes into a single output ( blog ) Find Read More... Posted Tuesday, April 21, 2009 9:15 AM by Jason | 1 Comments Filed under: DM Views, SQL 2008, SQL 2000, Performance Tuning, SQLServerSyndication, SQL Tips

• Rounding Up to the Nearest 1,000

  A co-worker came over and asked how to round up to the nearest 1,000.  He tried to use ROUND but found that it always split between going up or going down depending on the value and the report he was working on always had to round up. Almost before Read More... Posted Tuesday, February 17, 2009 12:31 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQL 2000, SQLServerSyndication, SQL Tips