March 2013 - Posts

• Filegroups and Non-Clustered Indexes

  Let’s start with some basics and then jump in a bit deeper, for this post to go with the 40th T-SQL Tuesday , hosted this month by Jen McCown . SQL Server holds data, and that data is stored physically in files. Of course, in the database world we think Read More... Posted Tuesday, March 12, 2013 12:20 PM by Rob Farley | 7 Comments Filed under: sql, t-sql tuesday

• A TOP Query

  For the blog post that I’ll publish tomorrow, I wrote a query that I thought needed a blog post all of its own. This is that post. The query was this one. Its results aren’t that interesting, it’s just a list of dates with a random number between 0 and Read More... Posted Monday, March 11, 2013 7:02 PM by Rob Farley | 3 Comments Filed under: sql