Viewing 15 posts - 16 through 30 (of 33 total)
Silverfox (9/10/2009)
Paul Monaghan (9/10/2009)
At my current company I'm one of those 'involuntary DBAs'. Someone who has be thrust into the role as there was a need for it...any they didn't...
September 10, 2009 at 9:01 am
Active/Passive. If it turns out we have no choice but to dedicate new LUNs to the OCS instance, I'll probably change it to Active/Active (since it would be separately licensed,...
September 10, 2009 at 8:46 am
Check out the dmv sys.dm_db_index_usage_stats - that should give you pretty much exactly what you're looking for. Of course, you'll need to do some extra work to track down which...
September 10, 2009 at 7:35 am
GilaMonster (1/29/2009)
Matt Cherwin (1/28/2009)
January 29, 2009 at 7:35 am
Paul Randal (1/28/2009)
January 28, 2009 at 6:09 pm
Garadin (1/21/2009)
January 21, 2009 at 8:07 am
Check.
I've had this on hold for a little while now due to issues in production, but I'll probably have time this week to get back to it. I'll give it...
November 25, 2008 at 9:20 am
Grant Fritchey (9/10/2008)
September 10, 2008 at 8:16 am
To answer the question, I have occasionally had the need to restore from backup via a UNC path across the LAN, and I haven't seen any issues. I have had...
September 9, 2008 at 3:10 pm
Michael Valentine Jones (9/9/2008)
Michael Earl (9/9/2008)
The alternate universe in which two files could be in the same folder with the same name would be a very...
September 9, 2008 at 12:12 pm
toparsi (9/9/2008)
I have a lot of databases to work with and need to keep track of all the changes. In my case, I need to copy backup files to...
September 9, 2008 at 10:04 am
What GSquared said, with one addition: in the SAN environments I've worked in, two LUNs with different RAID levels will automatically be on separate spindle sets. So, even if you've...
September 9, 2008 at 9:45 am
Sandra Skaar (9/9/2008)
September 9, 2008 at 9:25 am
Preston (9/3/2008)
What does FILE = 1, NOUNLOAD, & STATS = 10 mean in a Restore statement? Thanks.
FILE is used to identify a file to include in the restore; I'm...
September 4, 2008 at 7:46 am
Grant Fritchey (9/4/2008)
This is from BOL. I'd suggest trying it.
SELECT referencing_schema_name, referencing_entity_name, referencing_id, referencing_class_desc, is_caller_dependentFROM sys.dm_sql_referencing_entities ('Production.Product', 'OBJECT');
I had never heard of sys.dm_sql_referencing_entities before - that's fantastic. Thanks!
September 4, 2008 at 7:37 am
Viewing 15 posts - 16 through 30 (of 33 total)