Viewing 15 posts - 76 through 90 (of 1,348 total)
i started out in IT without a degree, then started to get a degree in IT and changed it to finance. the one thing a lot of STEM people and...
November 16, 2011 at 7:33 am
i replicated this on a virtual XP instance i have for testing
in MS Access the columns aren't visible at all when linking to the table
in SSMS they are there but...
November 4, 2011 at 9:12 am
unless there is a way to see who made the change this is useless. we have analysts who use SSMS or MS Access to make changes to data outside of...
November 1, 2011 at 1:53 pm
if i understand this correctly there are two unique indexes that were created on the same column or columns. one clustered unique index and on PK unclustered. any reason for...
October 13, 2011 at 9:45 am
Dean Jones-454305 (9/5/2011)
The size is around 200GB for both differential and full.
i've seen that. chances are its something in your schema that causes too many extents to change with...
October 12, 2011 at 9:38 am
i've had a few instances where i do a back up audit and find that some server isn't being backed up for some reason. fixed it by dumping the tables...
September 26, 2011 at 12:40 pm
is this on the latest hardware? i have a 400GB database that we back up to tape and disk every day. the tape is the real backup and disk is...
August 23, 2011 at 8:40 am
Ignacio A. Salom Rangel (8/18/2011)
alen teplitsky (8/18/2011)
August 22, 2011 at 10:33 am
i back up more than a few databases over 500GB to tape. one or two are close to 2tb. we have a tape robot with LTO-4 tape and netbackup. if...
August 18, 2011 at 6:53 am
could have been bugs in earlier versions of sql 2005 but i used to have problems with temp tables not being deleted. my indexing maintenance was a stored procedure and...
August 10, 2011 at 8:31 am
probably just me but i try to avoid temp tables as much as i can only because i don't like the I/O overhead of using them. One developer i knew...
August 9, 2011 at 8:02 am
can you use this to monitor replication? say compare the publisher and subscriber tables? how long would it take to get a result on tables with tens of millions of...
August 8, 2011 at 11:55 am
DBANewbie (7/27/2011)
This is my frustration; i can't seem to track...
August 1, 2011 at 8:29 am
recently i had a server with a CPU issue. get SSMS 2008 R2 and use the activity monitor and check out the most expensive queries it reports back to you
August 1, 2011 at 8:24 am
Viewing 15 posts - 76 through 90 (of 1,348 total)