Viewing 15 posts - 10,621 through 10,635 (of 22,213 total)
I would get a full understanding of the state of the backups. In addition, what are the maintenance routines currently in place. After that, I'd want to work on establishing...
July 18, 2012 at 7:52 am
You can take a look at the DMO sys.dm_exec_requests. For a backup or restore it will show a percentage complete. It's not a perfectly accurate measure, but it will be...
July 18, 2012 at 7:49 am
You can get that right out of the Dynamic Management Objects (DMO). This will get that piece of data:
SELECT deqs.creation_time FROM sys.dm_exec_query_stats AS deqs;
July 18, 2012 at 6:48 am
In general, to coordinate databases with code, the best approach I've found over the years is to get your database into source control. That used to be quite difficult, but...
July 18, 2012 at 6:03 am
Disregarding the size of the databases, how many user connections does each have? What are the transaction rates? If there is more activity on one than the other, then you're...
July 18, 2012 at 3:55 am
You can change the alert to capture 1222. Or you can add 1205 traceflag so you get both, but that makes for very messy error logs.
July 18, 2012 at 3:54 am
And you're only ever taking the tail log backup in an emergency recovery situation anyway. Just take the backup and then use it as part of the recovery (if needed)....
July 18, 2012 at 3:25 am
The only way you can have foreign key constraints in place and still have orphaned records is for the foreign keys to have been added using the NOCHECK option after...
July 17, 2012 at 5:42 am
rodjkidd (7/17/2012)
Good to see you are still communicating fairly normally! I guess 6 sessions in two at SQL in the City just wasn't enough to push you over the edge....
July 17, 2012 at 4:13 am
And remember, foreign keys don't just act as a mechanism for preventing orphaned users. They also enhance performance (as long as they're enforced).
July 17, 2012 at 3:52 am
L' Eomot Inversé (7/15/2012)
July 16, 2012 at 2:07 am
Evil Kraig F (7/12/2012)
July 16, 2012 at 2:05 am
rodjkidd (7/12/2012)
David Sutcliffe and Grant Finchley - he's not that scary in person you know... Just don't tell him that!
Don't...
July 12, 2012 at 6:45 am
The single best source for understanding how to deal with wait states is this excellent white paper from Microsoft. It should answer most of your questions in detail.
In a nutshell,...
July 11, 2012 at 7:52 am
Divine Flame (7/11/2012)
I don't find DTA very useful. If we want to get the missing index recommendations, DMVs (such as sys.dm_db_missing_index_details) are more helpful.
And the missing index information is not...
July 11, 2012 at 7:37 am
Viewing 15 posts - 10,621 through 10,635 (of 22,213 total)