I hate to point out the obvious, but the first question asked by Singer Sewing Machines tech support is: Is your sewing machine plugged in?  (50% of the calls end...

Here you go, simple solution:

1. Put Database into full recovery mode.

2. Backup up the transaction log (you should then see used space shrink)

3. Put Database back into simple recovery mode.

4....

I would also check your database fragmentation and current statistics.

For getting the restore splash screen, there are other posts on using: msdb.dbo.sp_delete_backuphistory '01-may-2006' (substitute date as required)

Please note that there...

I thank you for the information, but I would like to ensure that I have understood your article correctly.

For the new roles, the only role that can start or stop a...

Linda, thankyou for the information.  I haven't downloaded 2005 yet, and forgot that I could look in MSDN.  One question that wasn't easily answerable from the BOL, was how best...

Thank you for the information Scott.  I figured that there was probably a new way to get to it, but the BOL did not make it obvious.

Thanks again,

Brian

Since the goal of your program is data import, can you drop constraints, load the data and then re-apply the constraints?  (i.e. a bulk load during a "down time" for...

If by truncated you mean is the file shrunk, then no it is not.

What does happen as I understand it, is the records are written out, and any "complete" transactions...

Thanks, Ok I think I figured out what is happening.

I have recently installed Quest's LiteSpeed and it probably sets that on for updating the statistics in its central repository.  Makes...

I will add on that we have multiple web servers that back each other up and the talk to a clustered pair of SQL Servers.  So yes seperate them, it...

Yep as stated, backup MSDB when you change jobs/maintenance plans etc.

If you want to move SQL Server 2000 Jobs related to a maintenance plan, I would recomend re-creating the maintenance plan...

Well I had been working on Oracle but switched projects back in 1998 or 1999.  I had been doing Y2K stuff with a completely useless totally incompetent and technologically ignorant...

I agree with you.  Like I said no-one and no text ever pointed it out to me.  I stumbeled across it when I deleted a database and it took for...

I just happened to run into this problem and found this solution, but as I was working on implementing it, I noticed a critical item:

Put a non-clustered, non-unique index on...

See also this thread:

http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=246656

It is discussing some solutions to your same problem.  Check Usage statisitcs, index fragmentation, Compare schemas, etc.

Good Luck.