Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Return Max or Min Value of a Group of Columns as a Single Column

Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never used again (turns out, there’s quite a lot of them in this database). They are characterized by having _bak or _ appended to the end of them. I wanted to…

Read more

Return Max or Min Value of a Group of Columns as a Single Column

Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never used again (turns out, there’s quite a lot of them in this database). They are characterized by having _bak or _ appended to the end of them. I wanted to…

Read more

AG Worker Thread Blocked by Log Backup

We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email stating that system thread with session ID 44 had been blocked for at least 599 seconds (10 minutes, basically). This was in the middle of the night, and I looked…

Read more

Attendee Questions from My #24HoP Presentation

I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate the questions that were asked. We did not have time for all questions, so I want to answer all of the questions here. Some of these were answered in the…

Read more

What has 2 Thumbs and Deleted a LUN with the Log File of a Production DB on it?

That’s right, I did it. I was deleting unused LUNs and the focus somehow jumped from the LUNs for the one database onto a LUN for another database. I blame an errant mouse-click. As soon as I deleted the LUN, I realized the name was wrong. The LUN held the…

Read more

What is the max/min size of a decimal data type?

Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and email a report of identity columns that are approaching the limits of their data type. The minimum and maximum values for most numerical data types are documented in Books online,…

Read more

My 24 Hours of PASS Session Files

I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of PASS: Evolution of the Data Platform event. My presentation was called New Paradigm for Performance Tuning in SQL Server 2016 and covers two new tools for performance tuning: Query Store…

Read more

Why I'm not attending PASS Summit 2016

I know there has been a lot of drama in the community recently, much of it centered around what people are or are not going to do in conjunction to this year’s SQL PASS Summit. Well this isn’t one of those posts. I promise you that this post is drama…

Read more

T-SQL Tuesday #74: Be the Change Round-up

Thanks to everybody that participated in this month’s T-SQL Tuesday. A big thanks to everyone who wrote a participating blog post, and a really huge thanks to everyone who read the posts shared by this month’s participants. If you follow one of the links on this round-up page, I will…

Read more

T-SQL Tuesday #74: Ch-ch-changes

Welcome to my contribution for T-SQL Tuesday 74 being hosted by me. So special thanks to me for hosting it. Good job me, I’ll buy me a beer next time I see me to thank me properly. But enough about me, my post is about using Query Store in SQL…

Read more

T-SQL Tuesday #74 Invitation: Be the Change

Happy New Year and welcome to another T-SQL Tuesday (number 74 to be exact). This time of the year, everyone thinks about making resolutions. Stop doing something or start doing something, etc. You know the drill. Well, I’m not doing that, but this month’s topic is inspired by resolutions. The…

Read more

Corrupt Temporary Statistics in SQL Server 2014 Readable Replica

Earlier this week, the Database Strategy Team at my company was contacted about queries that were failing on one specific table. The same query on TableX and TableZ were successful, but it failed on TableY (not the real table names, but it is data partitioned into separate tables where the…

Read more

T-SQL Tuesday #73: Never Made That Mistake Again

T-SQL Tuesday is a monthly community-wide blogging event created by Adam Machanic (blog|@AdamMachanic), and everyone is invited to particpate. This month’s blog post party — I like that phrase, it has a nice ring to it — is being hosted by Bradley Ball (blog|@SQLBalls), and the holiday-themed topic this month…

Read more

You Have One Job

I’m sure most if not all of you are familiar with the meme “You had one job”. I was reminded of this meme this past Friday when I headed out to run an errand at lunch time. There were 3 guys standing in the middle lane of a busy intersection,…

Read more

SQLSaturday 461: Join Me For a Full Day of Performance Training in Austin

Join me Friday, January 29, 2016 for a full day of performance tuning training as part of SQLSaturday 461 in Austin, TX. Then stick around for the main event on Saturday where I will be among the many great presenters at the SQLSaturday event. My regular session on Saturday in…

Read more

PASS Summit 2015 and SQLSaturday Oregon Sessions

PASS Summit 2015 is over and of course, no PASS Summit is complete without also attending SQLSaturday Oregon. Below are my session files from my half-day session on DBA’s Guide to Administering BI Systems at PASS Summit and Who has What to Which (The Permissions Superset) at SQLSaturday Oregon. PASS…

Read more

So Long Seattle and Thanks for all the Fish!

I’ve had some good times in the Seattle area. I’ve lived in the Seattle are since 1987 and graduated high school here in 1988 (South Kitsap High in Port Orchard, WA). That’s 28 years I’ve been here. That’s a long time, but now it’s time to part ways. Likewise, my…

Read more

New Whitepaper: Deciding Between Merge and Peer-to-Peer Replication

Replication is still a major component of SQL Server today even with Availability Groups as an alternative to certain scenarios. Availability Groups does not allow you to have more than one writeable version of the data at any given time. Replication is the only native component or feature in SQL…

Read more

How Many Objects Can Own Pages in a Mixed Extent

I saw an exchange on Twitter this past weekend on the #sqlhelp hash tag about how pages are allocated for a temp table. The replier (blog|@sqL_handLe) — whom you should be following if you’re not already, very smart guy — gave the classic response about mixed extents and how they…

Read more

Oklahoma City User Group Presentation Files

Earlier this week, I got the opportunity to present online for the Oklahoma City SQL Server User Group on SQL Server Mythconceptions and Mythteries. The files from my presentation are attached below for download. The zip file contains my slide deck and demo code from the session. SQLServerMythconceptionsAndMythteries.zip (653 KB)

Read more

Older posts