when-you-alter-your-partition-function-without-testing

Adding Partitions to the Lower End of a Left Based Partition Function

I recently got a table partitioning question from a reader: We now need to load some historical data into the table for 2013 so I want to alter the function and schema to add monthly partitions for this. But I can’t work out how to do this using SPLIT? Every example and tutorial I’ve looked […]

confused-by-sp-who2-widescreen

Confused by sp_who2 (Dear SQL DBA Episode 30)

This week’s ‘Dear SQL DBA’ question gets us down to the essentials Recently, when I was checking if there are any hanging transactions in my database via “sp_who2 ” procedure… A transaction is “AWAITING COMMAND” LastBatch date is more than a week ago ProgramName is “SQLAgent – Generic Refresher” Is the transaction hanging? Learn the […]

Troubleshooting-Blocking-Deadlocking-1000-1000-with-Title

New online course: Troubleshooting Blocking & Deadlocks for Beginners (Free!)

I made y’all a SQL Server style Valentine’s day present: a new FREE online training course. Here’s a quick trailer: Course info: Troubleshooting Blocking & Deadlocks for Beginners You need to prove if blocking is killing the performance on your SQL Server. Learn to set up simple, lightweight monitoring using free tools and scripts to […]

Episode-29-Thumbnail-Square-Libsyn

Should I Learn Fulltext Indexing? (Dear SQL DBA Episode 29)

This week’s question is about a longstanding feature in SQL Server that sounds really cool: full-text search. If you’re learning performance tuning, how much time should you invest in researching and learning about full-text indexes? Watch this 18 minute video, or scroll on down to read the written scoop on full-text search. Dear SQL DBA… […]

partition-diagram-left-based-datetime2

Understanding Left vs. Right Partition Functions (with Diagrams)

You’re designing table partitioning, or you want to make a change to an existing partition function. It’s critical to understand the difference between how “left” and “right” partition functions behave, but the documentation is a bit confusing on this topic. Honestly, even after years of working with partitioning, it’s easy to get confused about left and […]

Execution-Plan-SecurityPolicyApplied

What’s that Garbage in my Execution Plan? (Dear SQL DBA Episode 27)

Today I was working on some code samples for a user question, and I hit a weird roadblock. There was a bunch of garbage in my execution plan that I couldn’t explain. And by ‘garbage’, I mean a nested loop to a whole branch of code that I hadn’t asked SQL Server to run — and […]