Viewing 15 posts - 16,711 through 16,725 (of 39,922 total)
There really isn't a single measure that tells you what database uses the most resources. How can you decide if a database using a large amount of CPU is doing...
March 9, 2011 at 9:05 am
DR for 100 databases, 30GB.
Solution1 : Copy the backups onto DVDs/tape, have someone drive them to a remote location every afternoon. Have standby serverse ready in the second location.
Solution 2...
March 9, 2011 at 9:00 am
I kind of randomly change pictures here and there. No special reason for me. Speaking of which, I think it's time to find a new one.
March 9, 2011 at 8:29 am
It's clear to me, and if you think there is some implication that you are restoring to some specific point in time, you are reading something into the question that...
March 9, 2011 at 8:16 am
Please start a new thread for new questions.
Also, you need to think about what you mean by verify. There is no such thing in SQL Server, so there's no way...
March 9, 2011 at 8:09 am
Anipaul (3/9/2011)
Will all the stairway articles later published in a book for collection? The articles are great...
This is probably what we will do when they are completed. So once we...
March 9, 2011 at 8:06 am
Jim has explained this well. It's mostly so you can get a valid comparison of two different sets of code that do the same thing. You can't count on these...
March 8, 2011 at 5:29 pm
taylor_benjamin (3/8/2011)
I am not sure, but as...
March 8, 2011 at 10:14 am
T-Log backups typically don't have a huge impact on performance, but there is writing to the IO subsystem, so there could be some contention there, depending on your setup. If...
March 8, 2011 at 9:38 am
Anthan has the best suggestion I've seen. I might do some metrics, maybe a large copy to the disks or something to test the current performance, and then another test...
March 8, 2011 at 9:36 am
If the log grew, shrinking isn't necessarily the solution. It fixes things, but please read Gail's (GilaMonster) article and make sure you have full backup set up.
March 8, 2011 at 9:34 am
I think you'd be better copying the data into a new table, with the changed data type, then building nonclustered indexes, then renaming the old, and rename the new.
If you...
March 8, 2011 at 9:13 am
A little old, but this might give you some pointers on setup
http://www.sqlshare.com/clustering-sql-server-2005_33.aspx?searchid=150263
March 8, 2011 at 9:01 am
jcrawf02 (3/7/2011)
March 8, 2011 at 8:56 am
So, you're still saying this is simple, but it's not as simple as you ask.
If this is the same server instance, then names matter. If this is another instance, then...
March 8, 2011 at 8:53 am
Viewing 15 posts - 16,711 through 16,725 (of 39,922 total)