Viewing 15 posts - 1,576 through 1,590 (of 4,745 total)
yes I thought about that but as the OP admits to being 'a bit of a noob' i thought it might be better to start with a simple solution and...
August 5, 2011 at 3:28 am
you don't need to run an integrity check before a reindex, so yes run on different nights.
But you should run integrity checks on a regular basis, at least weekly. run...
August 4, 2011 at 4:58 pm
Gail, don't start this 'beat george to the post' thing again :w00t:
August 4, 2011 at 4:15 pm
try starting SSMS by right clicking and 'run as administrator'
August 4, 2011 at 4:14 pm
GilaMonster (8/4/2011)
george sibbald (8/4/2011)
Craig Farrell (8/4/2011)
It's been proven that you can *waltz* through American security even after 9/11 with:
...- 2 lbs of C4 ( shaped as/in your...
August 4, 2011 at 4:09 pm
such a command could easily take a while to rollback.
rerun the kill spid command again with the statusonly option to see how far it has got.
i.e.
kill spid with statusonly
August 4, 2011 at 4:06 pm
Craig Farrell (8/4/2011)
It's been proven that you can *waltz* through American security even after 9/11 with:
...- 2 lbs of C4 ( shaped as/in your flipflops... which are...
August 4, 2011 at 3:59 pm
this is how the sqlagentoperatorrole is designed to work, it still only allows you to fully manipulate jobs you actually own. If this gives you problems (and you are not...
August 4, 2011 at 7:12 am
Roy Ernest (8/2/2011)
"To determine if hyperthreading is enabled for the processor, compare NumberOfLogicalProcessors and NumberOfCores. If hyperthreading is enabled in the BIOS for the processor, then NumberOfCores is...
August 2, 2011 at 3:22 pm
The article had details on memory usage by memory outside the buffer pool. Might have been an MS engineer blog.
1Gb for the OS does not sound enough for a 64Gb...
August 2, 2011 at 3:14 pm
not the article I was thinking about, but try this:
August 2, 2011 at 3:01 pm
Ninja's_RGR'us (8/2/2011)
I don't remember.[/ too easy to ignore]
😀
Fraggle, I read a good article on setting max memory taking other factors into account recently, but damned if I can find it....
August 2, 2011 at 2:48 pm
whats your objective here? do you want to know exactly how SQL is using the memory and if so to what end, or do you just want to get a...
August 2, 2011 at 2:29 pm
trying to interpret the results and find out what it all means 😉
August 2, 2011 at 1:20 pm
Viewing 15 posts - 1,576 through 1,590 (of 4,745 total)