BTW... this is also a really good reason to have some naming standards.  We follow the standard that PKs will always use the form of PK_tablenamehere.

When I looked the problem page, no error was included on the page.

Does XML datatype with NULL Value in SQL Server 2008 consume any storage space?

As mentioned in https://www.sqlshack.com/optimize-null-values-storage-consumption-using-sql-server-sparse-columns/ If we store a NULL value in a fixed-length column such as...

Hi Jeff, we require the success to auto clear the failure events. This clear would then auto resolve the help desk auto generated tickets as well as end the...

Thanks, Johan.  It's a shame we couldn't have a couple of beers together afterwards like we did the...

Thanks Tom.  I really appreciate the...

One thing I am disappointed not to be hearing more about is the use of resumable index rebuilds.

I've stopped using reorganize on huge tables where we can't rebuild because...

1. Rebuild your non-unique non-clustered indexes that have NOT been disabled.  Rebuild them from smallest to largest.
2. Rebuild your previously disabled non-clustered indexes from smallest to largest.
3. Rebuild...

My suggestion is to stop monitoring successes.  Job history does that well enough.

When you do a shrink-file on a data file, pages from the end of the file are moved to unused pages at the beginning of the file.  That very effectively...

I'd like to add my thanks as well, a great and thoroughly enjoyable presentation (and I actually understood it 🙂 ). Lots of good stuff. Now I just have...

So, the next question is, why do they want to know if you know this?  Is there a non-obvious performance advantage?   I wouldn't believe so but who knows?

I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found...

Here's a way, though it would be pretty stupid to do it.

SELECT x.CustomerID
  FROM (SELECT c.CustomerID, 0 Col1
       ...

I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found its logical reads...