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
did you see the url link i posted earlier?
---------------------------------------------------------------------
August 2, 2011 at 4:22 pm
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)