Looking for that special gift for Valentine's day and wanting to really change things up? How about getting your loved one an e-book copy of Expert Performance Indexing for SQL Server 2012? This week you can get an e-book copy for 40% off if you use the VDAY13 code at checkout, when buying it from Apress. … Continue reading Give Your Valentine Some Discounted Indexing
This month, Wayne Sheffield (Blog | @DBAWayne) is running T-SQL Tuesday on PowerShell. T-SQL Tuesday is a monthly blogging event where a number of us in the SQL Server community gets together to blog on a central topic. The topic that was chosen for this month was PowerShell. And more specifically: "Blog about using PowerShell for doing, … Continue reading T-SQL Tuesday – Powershell and Perfmon Results – #TSQL2sDay
February is a short month... and if you are following the Monday's you know that today's the second Monday of the not the first. The first Monday is when this update is usually due out. Unfortunately, I was fairly sick last week and didn't get to working on this blog post. I should have had a … Continue reading February 2013 – Monthly SQL Server Checklist
Earlier this week, I wrote a quick blog post on a throw-away script I had written. The blog post was DETERMINING FILEGROUP FOR A TABLE. At the time, I didn't explain why I needed the information; which prompted the following from one of my readers: Read your mini-blog in "how to determine the filegroup for a … Continue reading Ask the Unicorn: Why is it Important to Know Tables in Filegroups?
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 indexes for a table that determine … Continue reading Determining Filegroup for a Table
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 years back. The thing is, even if … Continue reading 5 MCM Readiness Indexing Videos You Should Watch
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
Strate SQL 