Viewing 15 posts - 8,701 through 8,715 (of 49,571 total)
Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"
"No pressure to work overtime" they say. :ermm:
June 17, 2014 at 4:32 pm
Most queries don't use much memory, the buffer pool is shared. Only workspace memory grants are per query.
For overall CPU, reads, duration, take a look at this (aging) article:
June 17, 2014 at 3:57 pm
You should be able to use the snapshot agent as it's just a couple of tables, but test and see.
June 17, 2014 at 1:53 pm
kevinsql7 (6/17/2014)
Did the log file not shrink as much because the DBCC SHRINKDATABASE command is also writing to the log file?
No. The log can only be shrunk to the end...
June 17, 2014 at 1:45 pm
CREATE - once created add it to the articles published and run the snapshot agent. It *should* just snapshot the new table
DROP - remove the table from the articles published...
June 17, 2014 at 12:59 pm
Wrong forum 🙂
It's been reported and raised to the relevant people
June 17, 2014 at 12:58 pm
Andrew Kernodle (6/17/2014)
But technically, I've gotten leave time in both DBA jobs I've had so far; I've just not been allowed to use it.
That's the same as no...
June 17, 2014 at 12:35 pm
Grant Fritchey (6/17/2014)
But there are processes that you don't really want to have mess up in the middle because of a somewhat higher likelihood of corruption wouldn't you agree?
No,...
June 17, 2014 at 12:29 pm
Eirikur Eiriksson (6/17/2014)
GilaMonster (6/17/2014)
Welsh Corgi (6/17/2014)
If I were to kill the process could I corrupt the Database?
No.
There is no process in SQL that you can run or kill that will...
June 17, 2014 at 12:28 pm
ggoble (6/17/2014)
June 17, 2014 at 12:17 pm
Welsh Corgi (6/17/2014)
If I were to kill the process could I corrupt the Database?
No.
There is no process in SQL that you can run or kill that will cause corruption.
June 17, 2014 at 12:08 pm
Andrew Kernodle (6/17/2014)
Beatrix Kiddo (6/17/2014)
Andrew, how do you cope with no annual leave? (If that's not too personal.)
Simple! No job I've ever held so far has allowed me to...
June 17, 2014 at 12:05 pm
Yup, any single statement. Thing is, you have to stop it before it completes, and SQL won't always process a stop request immediately so you can easily stop too late...
June 17, 2014 at 5:54 am
Interesting...
CheckDB shouldn't be trying to take locks at all. I wonder if it's failing to create the DB snapshot and resorting back to table locks. Can you check the error...
June 17, 2014 at 5:45 am
Viewing 15 posts - 8,701 through 8,715 (of 49,571 total)