Viewing 15 posts - 9,661 through 9,675 (of 49,571 total)
kshaileshbca (3/15/2014)
Fist you have to check fragmentation level
What's that got to do with memory?
add lock pages in memory
Um, no. That's not going to reduce memory usage, do you know what...
March 15, 2014 at 8:17 am
A rollback takes as long or longer than the operation had until the point it was cancelled. You wait, because there's nothing else you can do.
March 15, 2014 at 8:14 am
wolfkillj (3/14/2014)
GilaMonster (3/14/2014)
So what does it mean when I have things that I've said in people's signatures or on people's walls? :blush:
It means that I'll gladly endorse you for Pithy...
March 14, 2014 at 2:54 pm
The one database file per core recommendation is an outdated one for TempDB only. It's never been a recommendation for user databases and even for TempDB now it's 1/4-1/2 the...
March 14, 2014 at 2:43 pm
Jeff Moden (3/13/2014)
GilaMonster (3/13/2014)
Jeff Moden (3/12/2014)
Using "Statistics TIME, IO" will also be way off if there are any non iTVF functions in the mix.
IO will be. Time, if you look...
March 14, 2014 at 2:34 pm
wolfkillj (3/14/2014)
wolfkillj (3/13/2014)
GilaMonster (3/11/2014)
Koen Verbeeck (3/11/2014)
Grant Fritchey (3/11/2014)
March 14, 2014 at 2:29 pm
rodjkidd (3/14/2014)
March 14, 2014 at 2:28 pm
New Born DBA (3/14/2014)
In this case let's say the DB goes down at 1:55, how do we restore it to the point in time recovery? What's the procedure?
Depends on the...
March 14, 2014 at 1:10 pm
hada79 (3/14/2014)
I am guessing it is a matter of time before the application (Citrix provisioning server) accesses the bad page and freaks out, but will the problem get worse?
Corruption won't...
March 14, 2014 at 12:58 pm
Bijoy.Kaiprath (3/14/2014)
try executing dbcc with allow data loss
NO! NO! NO! (not that it will do a damned thing in this case)
March 14, 2014 at 12:53 pm
Corrupt page in a system table. This is not good news. There may well be more corruption, we just don't know.
Can you restore your latest backup somewhere else and run...
March 14, 2014 at 7:52 am
Eric M Russell (3/14/2014)
Well, if it took only 1/2 second to delete 20 million rows, then he's lucky. That's not typical; almost to the point of disbelief.
TRUNCATE TABLE
It doesn't process...
March 14, 2014 at 7:48 am
Cannot be done.
Filegroups cannot move from one database to another.
March 14, 2014 at 5:39 am
Trigger/CDC is indeed a good idea. Write a script to auto-create the triggers on all the necessary tables, not that hard to do.
March 14, 2014 at 5:38 am
Siberian Khatru (3/14/2014)
For me, the keys were not needing to worry about getting all of the rows back, plus the minimal logging aspect.
Well....
Both delete and truncate can be rolled...
March 14, 2014 at 5:18 am
Viewing 15 posts - 9,661 through 9,675 (of 49,571 total)