Thanks. There are several indexes only covering one column that I could add to.

Here is the captured log error.

Unexpected system error mode before loading package

Visual Studio Task List Package windows forms designer

This time I did have job activity monitor open with a...

MM, I'll try that. Thanks

Faulting application name: Ssms.exe, version: 2011.110.3350.0, time stamp: 0x515343cd

Faulting module name: ntdll.dll, version: 6.3.9600.17278, time stamp: 0x53eeb4a3

Exception code: 0x4000001f

Fault offset: 0x000270bc

Faulting process id: 0x174c

Faulting application start time: 0x01d014f4660fd6cf

Faulting application path:...

ssms just hangs and offers a window to debug, restart or restart and search for solution. That's what I mean by restart. Do you gents use ssms...

Thanks. I'll give it a shot. Worst that can happen is a needed reboot which we could let wait until after hours.

Still using smsql but are running into an ongoing problem where the largest database comes up in suspect mode on the disaster recovery side. No evidence of any corruption...

I believe it will be LUW "pure data" but I'm not really involved in the change ( retiring in a few months 🙂 ) ...

One result of this decision is the departure of several senior c# .NET developers along with a few sql server DBAs. The only reason I've heard was pricing, but...

What I'm taking away here is that a sql server version upgrade requires updating stats, among other things, but once that has all been done ( in-place upgrade ) the...

got it, thanks

Since our main update statistics job runs for many hours on Saturday ( the primary use database has 4.4 trillion rows in all tables and about 3 TB of data...

Thanks Lynn. Yes, in at least one of the aspstate stored procedures, READTEXT is touching an IMAGE column. I don't know when or if we will migrate to...

We update stats just about every day, and for nearly 8 hours on Saturdays --- the short answer is that we determine which one's need updating the most...

Since sql re-creates those _wa_sys stats using hexidecimal for the table's object id and the column's object id, it seems to always use the same same, so I just excluded...