NJ-DBA (5/16/2012)

---

I'm creating alerts which call a job on a bunch of servers. Alerts like this:

declare @job_id varchar(100)

select @job_id =job_id from msdb.dbo.sysjobs where name='Error Sev 17 or Higher Alert'

/******...

NJ-DBA (5/8/2012)

---

Steve Jones - SSC Editor (5/8/2012)

---

Not sure. I thought the deallocations of the blob pages might be stored in the log, but I can't find a definitive reference. How...

Steve Jones - SSC Editor (5/8/2012)

---

Not sure. I thought the deallocations of the blob pages might be stored in the log, but I can't find a definitive reference. How large...

in the interest of full disclosure heres how it all went down:

Friday: change to simple mode, then back to full. Kicked off full litespeed backups. Litespeed transaction log...

Using litespeed, but the problem which caused us to disable the tlog backups, was litespeed related, so when we picked it up, we went with a native backup of the...

Probably not, but the example does help me understand how this could happen. Possibly several smaller tables truncated repeatedly, though I would be surprised if it amounted to 100GB worth....

Well, i hopefully you can explain why the best practice doesnt make sense to your clients, because so far all i've heard in this case is "microsoft isnt always right"....

Right- yeah, I dont need it to come from Microsoft, I just need it to be backed up some supporting data or documentation to understand why.

All I meant is that...

I did see that, but "To improve query plans and query performance, we recommend that you update statistics on all databases following upgrade from SQL Server 2000" is not the...

realyl need to find something from MS saying to do this... cant say "some well respected posters on SQLServerCentral said so"... I mean, that's good enough for me, but...

REally- I did not know about that. Is it documented somewhere in BOL that it's mandatory to do an update stats wth fullscan after upgrading to 2008?

The execution plans were the same (which is what had me scratching my head)...

Looks like this was related to a difference in the Provider Options. "Allow inprocess" was...

40

This turned out to be an issue with setup running on systems with > 32 processors. Described here: http://support.microsoft.com/kb/2251397

Resolutino was to kill setup, remove nodes, and...

Well, have you identified what is using up so many locks? start with:

SELECT request_session_id, COUNT (*) num_locks

FROM sys.dm_tran_locks

GROUP BY request_session_id

ORDER BY count (*) DESC