Knowing when and how often your indexes are used can really come in handy. Indexes that are never utilized aren’t worth keeping around, and knowing their usage patterns can be a big help when making decisions regarding things such as filegroup placement and compression settings. SQL Server 2005 brought some great advancements in the form [...]
|
3 January 2012 by Bob Pusateri in Personal , SQL Server , SQLServerPedia Syndication with zero comments
Happy New Year to all! At the start of 2011, I laid out some goals for the year and did an update on them back in July. Now that it’s 2012 it’s a great time to take a look at what I accomplished (and fell short on) last year and also set some new targets. [...] 13 December 2011 by Bob Pusateri in SQL Server , SQLServerPedia Syndication , TSQL Tuesday with one comment
This month’s T-SQL Tuesday is hosted by Allen White (blog | @SQLRunr) and is an invitation to show off a nifty T-SQL trick you use to make your job easier. Here’s one of my favorites as of late: Some of the source systems we copy from shard their data across multiple similar tables. For [...] The third time’s a charm! SQL Saturday #119 (Chicago 2012) has been posted on the SQL Saturday website! It will once again be held at the DeVry University campus in Addison, IL and will be on May 19, 2012. SQL Saturday in Chicago has a special place in my heart for a few reasons. [...] Well, we’re back at the top of the month again, and this time around for Meme Monday we’re to talk about what we’d love to see under the tree from Microsoft. This got my creative juices flowing, and I came up three wishes: First and foremost, if I had one wish that I could wish [...] |
 Recent ArticlesCategories
Archives
|
|
Copyright © 2012 Bob Pusateri – The Outer Join - All Rights Reserved |
|