Viewing 7 posts - 1 through 7 (of 7 total)
Just adding my two cents.
June 7, 2011 at 6:03 am
Really liked the concept, but I ran into one issue. The object backupmediafamily.physical_device_name is nvarchar(260) so I changed @filename to nvarchar(260).
Thanks for the clear and concise article(s).
July 29, 2010 at 6:08 am
We all know that some can wait and some cannot wait. And there are some database changes that you would never make over a weekend.
February 19, 2010 at 8:59 am
I definitely agree. Overall, it helps to give a fresh look when Monday rolls around. And if someone drops something off late on a Friday, it'll be something to...
February 19, 2010 at 6:02 am
As a couple of comments stated, the names may not come back in the order you want. On the same server, I ran this query at different times and...
February 16, 2010 at 7:15 am
In your diagrams, how did you get the yellow information boxes included. Did you just do multiple screen prints and then included them, or did you find some tool...
September 22, 2009 at 1:26 pm
Dropped all the Foreign Keys that were associated with the Person primary key.
Dropped the Unique Clustered Index over Person.
Created the Primary Key as Clustered over Person_ID
Added the Foreign key constraints...
June 4, 2008 at 8:34 am