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 STATS_DATE() and they are really … Continue reading STATS_DATE() Doesn’t Indicate The Validity of Statistics
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 the person isn't in IT or doesn't … Continue reading Six Degrees of SQL Saturday Fargo
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 blog, I figured I'd share the … Continue reading Determining Default Trace Location
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 sponsors – Confio (Silver), PASS (Bronze) and Steve Stedman (Blog). Every little bit helps and we appreciate all of our sponsors. Are you interested in helping to … Continue reading SQL Saturday Fargo Update
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 DBA, you should have a … Continue reading January 2013 – Monthly SQL Server Checklist
Over the last few days, you may have noticed that there’s been a bit of talk about a SQL Server MCM Study Group. In fact, Robert Davis (Blog | @SQLSoldier) tweeted about it the other day when he provided some sample corrupt databases. You may be wondering, what is this study group on yammer? Let’s … Continue reading SQL MCM Study Group
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may not have had a chance to see. Also a chance to bring back to the forefront posts that some may have seen but forgot about. If you have some free time or interest, check out … Continue reading Re-blog – December 16 – December 22
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may not have had a chance to see. Also a chance to bring back to the forefront posts that some may have seen but forgot about. If you have some free time or interest, check out … Continue reading Re-blog – December 9 – December 15
Another month and it’s another T-SQL Tuesday. This month we are being hosted by Allen White (Blog | @SQLRunr) and the topic is to Share Your Tricks. One of my favorite things to do in SQL Server is to run queries against the plan cache. Within there, you have the ability to see what SQL … Continue reading T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may not have had a chance to see. Also a chance to bring back to the forefront posts that some may have seen but forgot about. If you have some free time or interest, check out … Continue reading Re-blog – December 2 – December 8
Strate SQL 