Now, why in the world would I be asking a question like this? Well, in BOL (BACKUP) is this little blurb: CHECKSUM Specifies that the backup operation will verify each page for checksum and torn page, if enabled and available, and generate a checksum for the entire backup. This is the default behavior for a […]
(2017-2022)
Browsing Posts in SQL
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the history of the job, to see why it failed: Okay, this is interesting. The job did fail, but the only step to run succeeded. Hmm, let me look at what the job is doing: The […]
For those of you that know me, you know that I enjoy learning, and passing on what I have learned to others. As it turns out, this whole presenting thing has been an interesting path for me. (You can read more about the early disastrous presentations in my life here.) As I have started to […]
Sometimes it’s the small things that count. I just noticed two small enhancements to SQL Server 2014’s BOL, and I can tell they are going to make my life easier. How many times have you been developing a script, and you’re trying to make it work with multiple versions of SQL Server? Since I handle […]
If you can establish a connection to a SQL Server, but are having problems logging in to it, you will get an 18456 error. This error is deliberately obfuscated in SQL Server so that the user can’t tell why the error failed (and thus try to crack into the server). All the user will get […]
We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the bucket. Perhaps you want to ski the Swiss Alps. Learn a foreign language. Learn to play a musical instrument. Surf the Hawaiian swells. Visit far-away places. Get romanced by a Frenchman in Paris (which […]
I ran into an interesting problem recently. There is a 4TB database that is log shipped to a DR site, and some new data files needed to be added to the database. Mistake #1: The drive volumes on the DR server are not configured the same as the primary site. Mistake #2: This mismatch was […]
I’ve been digging deeper into the Ghost Cleanup process recently, and quite naturally my quest lead to Paul Randal’s blog. He has a post about the Ghost Cleanup process in depth, and in this post is this line: The ghost cleanup task will leave a single record on the page to avoid having to deallocate […]
Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this month’s T-SQL Tuesday blogging party, and he wants us to “write about topics like the good and the bad patterns of joining you have seen out there”. (Sebastian is also running a […]
The Myth One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is the data in a clustered index stored on the page in physical order? Most people will say “Yes”, and they get this from the definition (see BOL: Clustered and Nonclustered Indexes Described), which […]
