I'm not sure about the latch error, but the timeout could be just trying to do too much at a time.

Try smaller increments. Do something like:

dbcc...

I guess my first question might be why do you need to restore the master DB?

In general the only things that I find acceptable for the master database...

Nice blog Grant!

1) If it is too slow to be useful -> then you need to tune it more 🙂

2) If no one is complaining, then it might be...

I will have to assume that they already have some DBA's on staff. When I brought up Jr DBA's, this is how I determined when they were ready to...

I thought it had to be some sort of trick question. (Halloween and all). 🙂

Assuming you have all of your backup logs, this is one way. http://www.red-gate.com/products/SQL_Log_Rescue/index.htm

Have fun!

Unless you have setup monitoring of past values there are very few options at...

No you can't install.

They apparently only offer mysql.

http://smallbusiness.yahoo.com/webhosting/hostingfeatures.php

However, you could always do access instead 🙂

The more I read this question the less I understand what the issue actually is. I get the impression that you received an alert, that tells you that the...

EXEC MASTER.dbo.sp_MSforeachdb 'USE ? SELECT DB_NAME() as DBname,8*SUM(size)/1024 as MegUsed FROM sys.database_files where data_space_id <> 0'

That will show you which of your databases is the largest. You can use...

A quick search found these guys http://www.grcdi.nl/dmtools.htm never used them so I have no recommendation to give, but they have a 30 day trial 🙂 ...

Unless you are going to use some sort of address validation software to verify your change you will most likely completely scramble the data more than humpty dumpty. I...

to run the SQL use SQL Command, but use the following to format the data the way you requested

DROP TABLE [#testtable]

GO

SELECT [name],

[object_id] AS c1,

principal_id...

BSEE (Electrical Engineering) in 1986.. In all that time I have not designed a single circuit board. I did program a robot while I was at Westinghouse. ...

I am not saying that your choice is good or bad, but just making sure what you are actually getting.

Temp tables are real tables stored in the TEMPDB. The...

Ok. If it worked as a permanant table, then I understand.

However, I am not sure what you are gaining then. Temp tables are real tables, just...