Viewing 15 posts - 39,151 through 39,165 (of 49,571 total)
WayneS (5/12/2009)
Most index scans that are still going on appear to be over a range of the index, not the entire index.
Index scans always read the whole index. They...
May 12, 2009 at 10:25 pm
May I suggest that you spend some time reading Books Online, especially the sections on backup and restore?
May 12, 2009 at 10:22 pm
Alvin Ramard (5/12/2009)
And now, live from the Memphis PASS Chapter meeting, heeeeeeeeeeeere's Bob Hovious.Bob
Bob .......
Bob???
BOB!!!!!
Where are you Bob?
Computer, locate Bob Hovious.
<Computer voice>
Bob Hovious is not within sensor range.
May 12, 2009 at 1:38 pm
kwilthew (5/12/2009)
May 12, 2009 at 1:00 pm
mrlucmorin (5/12/2009)
I'm just stating to think in terms of result set instead of thinking in terms of sequential programming (cursors) for my triggers.
<applause>
May 12, 2009 at 12:52 pm
Alvin Ramard (5/12/2009)
You can sing that at our next meeting, next week.
Record it. Please?
May 12, 2009 at 12:52 pm
So single disks? No RAID array?
What is an important production database doing on single disks?
May 12, 2009 at 12:13 pm
Snapshots don't capture modifications. They show the database as it was at the time the snapshot was created. So, in your scenario, if you query snapshot 1, it will show...
May 12, 2009 at 12:09 pm
Just bear in mind that snapshots aren't free. Having lots of them could slow down inserts, updates and deletes.
May 12, 2009 at 11:39 am
Jonathan Kehayias (5/12/2009)
Out of curiousity, how many disks are in the RAID Array that this database sits on and what RAID level is the array configured for?
Also, is it direct...
May 12, 2009 at 11:01 am
What does DBCC OPENTRAN return?
May 12, 2009 at 10:59 am
mark (5/12/2009)
May 12, 2009 at 10:59 am
What's the value of log_reuse_wait_descr in sys.databases for this database?
May 12, 2009 at 8:33 am
Have you checked for hardware-related errors in the system event logs, RAID controller logs, etc?
May 12, 2009 at 8:09 am
David Benoit (5/12/2009)
May 12, 2009 at 8:09 am
Viewing 15 posts - 39,151 through 39,165 (of 49,571 total)