Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2013

Determining Filegroup for a Table

Have you ever needed to figure out which filegroup your tables are located within?  If you had to do this, you might think it’s as easy joining sys.tables to sys.filegroups.  But its a little more complicated than that because tables aren’t stored in filegroups.

It’s The Indexes

It’s the… Read more

6 comments, 1,258 reads

Posted in StrateSQL on 29 January 2013

Last Weeks Top 10 “Reading” Links #17

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

  1. The Other Person is Never…

Read more

0 comments, 322 reads

Posted in StrateSQL on 28 January 2013

Reblog: January 18 to January 24

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 402 reads

Posted in StrateSQL on 25 January 2013

5 MCM Readiness Indexing Videos You Should Watch

Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification.  In the process of preparing for the MCM lab portion, I did a lot of studying.  One of the my key resources, were the MCM Readiness Videos that SQLSkills put together a couple… Read more

3 comments, 595 reads

Posted in StrateSQL on 23 January 2013

Last Weeks Top 10 “Reading” Links #16

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

  1. Acing the only three true…

Read more

0 comments, 260 reads

Posted in StrateSQL on 21 January 2013

Reblog: January 11 to January 17

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 308 reads

Posted in StrateSQL on 18 January 2013

2013 Polar Plunge #SQLPlunge

Next month… on March 2… I’m going to jump into a lake in Minnesota.  Now it’s cold in Minnesota.  In fact, they’re going to have cut a hole in the ice so that we can do this.

Why are me and a few friends doing this?  Well, partly because we… Read more

2 comments, 318 reads

Posted in StrateSQL on 18 January 2013

STATS_DATE() Doesn’t Indicate The Validity of Statistics

From time to time, you might have caught yourself in a conversation similar to the following:

Fred: Hey folks, we have a query that isn’t working right anymore?

Wilma: I wonder if there’s a problem with the statistics.  Maybe they are out of date.

Barney: I checked the statistics with…

Read more

2 comments, 649 reads

Posted in StrateSQL on 17 January 2013

Last Weeks Top 10 “Reading” Links #15

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

  1. MCM – I passed! [26…

Read more

0 comments, 300 reads

Posted in StrateSQL on 14 January 2013

Six Degrees of SQL Saturday Fargo

Do you know anyone that lives in or around the great white north that is Fargo, North Dakota?  If so, then I’d like your help in with an introduction on LinkedIn.  Let’s see how many people in the area are 6 or less degrees from me.

Even if… Read more

8 comments, 337 reads

Posted in StrateSQL on 11 January 2013

Reblog: January 5 to January 11

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 4,613 reads

Posted in StrateSQL on 11 January 2013

Determining Default Trace Location

While working on some scripts against SQL Server’s default trace, I wanted to develop a sure fire way to find the location of the default trace regardless of the version of SQL Server and without having to tinker with file names.

Since there are a few people that read this… Read more

2 comments, 621 reads

Posted in StrateSQL on 9 January 2013

SQL Saturday Fargo Update

It’s been a while since I mentioned anything about the SQL Saturday in Fargo.  So I thought I would let people know that we’ve now got ourselves three sponsorsConfio (Silver), PASS (Bronze) and Steve Stedman (Blog).  Every little bit helps and we appreciate all of our sponsors.  Are… Read more

1 comments, 279 reads

Posted in StrateSQL on 8 January 2013

Index Analysis Update – January 2012

In the past couple weeks, I’ve gotten a couple reports of issues with sp_indexanalysis.  The update today fixes those issues.  It’s fun to finally be playing with these scripts again.  I’m hoping to start writing blog posts showing the scripts in action in the next couple weeks.

INDEX ANALYSIS UPDATES

Read more

2 comments, 371 reads

Posted in StrateSQL on 8 January 2013

January 2013 – Monthly SQL Server Checklist

Today is the first Monday of 2013. Do you know if your servers are ready to take on the first month of the new year? Have you figured out if you have the hardware and capacity to make it through the next year? You should know this and, as a… Read more

0 comments, 387 reads

Posted in StrateSQL on 7 January 2013

Last Weeks Top 10 “Reading” Links #14

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

  1. On Being A Senior Engineer…

Read more

0 comments, 356 reads

Posted in StrateSQL on 7 January 2013

Reblog: December 28 to January 3

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 433 reads

Posted in StrateSQL on 4 January 2013