You should not be truncating the log files. Either implement log backups (if you need point it time recovery) or switch to simple recovery.

Please read through this - Managing Transaction...

The information you need is here:

http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

I suggest picking up one of the MS self-paced training kits and working through it.

Paul White (3/8/2010)

---

I can relate. If I had $1 for every time someone had said, "We just need something quick and dirty - you can do your flash database...

8 on SQL 2000, 24 on SQL 2005+. 1 or 3 extents. Below that rebuilding the index will just lead to more mixed extents. Above that SQL will use dedicated...

Have you read everything there is about locks and transactions in Books Online?

No. Don't even consider changing a production DB to single user mode. It will...

No impact, providing the index really is unused. Make sure that you've monitored for...

Sqlfrenzy (3/8/2010)

---

GilaMonster (3/8/2010)

---

Please don't automatically drop

You can drop an index at any time, neither the DB nor the server have to be in single user mode. If the index...

The 1000 pages is a rough guideline for more-or-less where rebuilding an index has a noticeable effect on performance. If you know that you need to rebuild smaller indexes for...

Yes. When I moved to consulting (a year and a half ago) from a full time position. It was almost 6 months before my income matched monthly expenses and I'm...

Please don't automatically drop indexes that show low seeks/scans. That DMV is cleared whenever the DB is started, so if SQL is restarted often that will not show complete information....

They you're going to have to depend on licensing and legalities. Once a SQL database is deployed to an instance outside of your control, all bets are off. A sysadmin...

You'll need to script out all the objects, export all the data and recreate the database on SQL 2000.

Please post new questions in a new thread.

Thank you

Not possible

The SQL...