Viewing 15 posts - 43,321 through 43,335 (of 49,571 total)
DBADave (11/5/2008)
BOL provides an example on how to reduce fragmentation on a Heap, but I need to determine how to determine heap fragmentation in 2005.
use index physical stats. For an...
November 6, 2008 at 8:47 am
That's a good config you have there. You could probably bump the max to 14 if there's nothing running on the server.
I seldom bother setting the min in SQL...
November 5, 2008 at 12:00 pm
Andrew Peterson (11/5/2008)
November 5, 2008 at 11:54 am
Check the compat mode of the DB you're running that in. My guess would be that it's in mode 80. Either change the compat mode or run the query from...
November 5, 2008 at 11:49 am
cxpacket is a parallel skew. Drop the maxdop down and see if it helps
November 5, 2008 at 10:26 am
sg (11/5/2008)
My question is, how safe is the encrypted data, since we can easily decrypt it once we know the Symmetric Key and the Certificate?
Or is it not as simple...
November 5, 2008 at 10:20 am
Why are you running update usage nightly?
November 5, 2008 at 10:18 am
Simon_L (11/5/2008)
a temporary dumping ground that was written to far more than it was read from for example ?
Something that's written to frequently is a bad candidate for...
November 5, 2008 at 10:16 am
Loner (11/5/2008)
How is the job market in your area?
Disparately short of good people, and not-so-good people for that matter. There's a massive shortage of skills in many ares of...
November 5, 2008 at 10:12 am
DBADave (11/5/2008)
Thanks Gail. Do they recommend rebuilding a HEAP in 2005 so the table stats get updated or is something else being done to the HEAP?
It's not possible to...
November 5, 2008 at 10:11 am
In addition to what John said, providing, requesting or using braindumps can result in all of your certifications been revoked, permanently. In addition, providing links to copyrighted material is not...
November 5, 2008 at 10:01 am
DBADave (11/5/2008)
I just began experimenting with online rebuilds yesterday and was surprised by how well it worked. It defragmented indexes just as good as an off-line rebuild.
Sure....
November 5, 2008 at 9:57 am
Leo (11/4/2008)
This is Test Table so that no indexes.I will going to do it on proper Table with indexes on when that Update process is okay.
You should put indexes...
November 5, 2008 at 9:54 am
Mani (11/5/2008)
So, if log backups run every 1hr and database crashed at 10:59am. That means whatever the activity happened between 10:00am to 10:59am will exist in ldf file.If We have...
November 5, 2008 at 1:02 am
Mani (11/4/2008)
niether replace nor append is fine...
November 5, 2008 at 12:10 am
Viewing 15 posts - 43,321 through 43,335 (of 49,571 total)