Viewing 15 posts - 12,361 through 12,375 (of 22,214 total)
Ah, well, since this is one of the DMOs that is only reset when the instance is restarted, I suspect it's not that vital.
June 10, 2011 at 12:09 pm
LutzM (6/10/2011)
GilaMonster (6/10/2011)
LutzM (6/10/2011)
Some folks refer the transaction log backup as an incremental log backup though....
I can call a horse a car, doesn't make it one. Incremental backups != transaction...
June 10, 2011 at 11:16 am
GilaMonster (6/10/2011)
Grant Fritchey (6/10/2011)
June 10, 2011 at 11:11 am
If by incremental you mean all the changes since the last incremental and then all the changes since that one... nope, no such critter. You answer that question with Differentials...
June 10, 2011 at 11:01 am
I have not seen a differential backup cause any more pain in terms of CPU than a regular backup. I suppose it might add something to the load, but from...
June 10, 2011 at 11:00 am
First off, that article is 7 years old, so almost anything it says might be slightly off these days. However, I just read through it and frankly, the author is...
June 10, 2011 at 10:55 am
It's not actually a table. It's a Dynamic Management View. If you're looking for it in SSMS, you need to look in system views. But no, unless you've got a...
June 10, 2011 at 10:49 am
Probably no difference because starting the shut down process on the server is going to start the shut down process on SQL Server. But I would still do it by...
June 10, 2011 at 10:45 am
The decision for which queries to put through parallelism is all based on the cost threshold, so controlling than rather than simply turning off parallelism completely I've found to be...
June 10, 2011 at 10:13 am
To my knowledge it can't be, but these tables are all very small. If you have that much memory pressure, you should be looking at your processes, not attempting to...
June 10, 2011 at 9:50 am
I would not recommend setting MAXDOP to 1 for most systems. Instead, I'd experiment with bumping up the cost threshold for parallelism. The default value of 5 is way too...
June 10, 2011 at 9:49 am
Nope, server aliases are a shortcut for local connections, not a way to rename the server.
June 10, 2011 at 9:48 am
What version of SQL Server are you running? If it's SQL Server 2000, that would explain your issue.
June 10, 2011 at 9:47 am
Tom.Thomson (6/10/2011)
Kit G (6/9/2011)
GilaMonster (6/9/2011)
Stefan Krzywicki (6/9/2011)
June 10, 2011 at 8:58 am
Spare time? Interesting concept as I sit here in an airport traveling back from a user group meeting and posting online here.
Write books and help run a scout troop,...
June 10, 2011 at 4:10 am
Viewing 15 posts - 12,361 through 12,375 (of 22,214 total)