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...

To add another 2 cents, I totally agree with David Wiseman.  Storing the full path instead of just a file name can be a horrible idea for the very reasons...

The only time that I've used ONLINE Index Rebuild was during testing on some test tables.  I've never tested for a "cancel" of an ONLINE Rebuild like you folks accidentally...

Imagine a view is created - that references a computed column which only exists to give the column a different name - and aliases the computed column...