Heh... what?  You don't like using D1, D2, D3, D4, etc, for the names of cascading CTEs? 😛  Or, how about table aliases named T1, T2, T3, T4, etc?

I've seen...

Yes... there's a super easy way...

Not that the code is unreadable or anything like that but consider documenting your production code so people don't have to try to figure out what the intent of the...

hi Jeff, I think the problem was that I didn't restart the server after messing with the auto update stats and auto update stats async values. Without restarting the...

It would have been nice if you would have provided some links to the MS Documentation so people could easily find it to learn more.

So, I tried converting to "nvarchar(max)" and "varbinary(max)," but without success. Therefore, I had to resort to a more radical approach, which involved extracting data from the client's portal....

So Jeff,

this sounds like a dumb question, but how do I insert a blob (image/pdf/doc) into the table via the SSMS?  Do I need a CAST statement or an...

Using the following code (your code with some stats measurements added), I'm not seeing any updates to the stats on the 600 row run.

--SELECT 500 + (0.20...

This fixed the issue: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-15151 Thanks. I wonder would it be possible to use SQL Profiler (or XE) to find out this kind of issues? To detect the batch...

If doing what the error text you posted (checking the logs) brings no joy, I can think of no other recovery than to do restores from the backups of the...

I believe the latter that you mention is the only way.

I also want to warn than none of what has done (according to what you've described) will hold up in...

I'd need to see the execution plans to understand what's going on. Further, two different databases means, possibly, two different sets of data, two different sets of statistics, two...

Compatibility mode?

Sidebar: stop using DB..Table - specify the schema instead of expecting SQL Server to find the correct schema for the table.  That is dependent on the default schema...

Just a post to expose page 2 because of the forum fault in that area.

While I agree with Jeff in the sense that "if the system is designed in one way, why change it to work a different way", I think I would...