This is some basic advice about how to decide the size of tempdb

tempdb needs to be sized so that it will not grow while your server is in use.

This is...

I have found that SQL gets a bit confused if you change the name of a Windows login in AD.

From memory, this is what happened... After changing...

I agree with Jeff. If you want to empty your temporary table at the end of the transaction, use a TRUNCATE statement before the final COMMIT.

There has been a lot of discussion in various forums about the merits of doing either an in-place upgrade or a new install. Most people who have done a...

This sounds like a 'slowly changing dimension' to me. Wikipedia has a good explanation of scd types and how to handle them. If you think this applies to...

I have not checked this out, but your problem sounds like the KB 941823 issue. Check that the SQLH2 service account has the permissions to the SQL service that...

When SQL want to grow the log, it will make 1 attempt to do so. If it cannot get enough extra space in that 1 attempt it will give...

In SQL 2000 you can set up one account per database so that the objects it creates will automatically have the prefix dbo.

To do this, first remove the account from...

Start with capping SQL at 2 GB below what Windows sees on machines over 10 GB memory. You may be able to fine tune to get a cap that...

I suggest you look at your processes to see if you can get the backup file on to the server where you wantto do the restore. If you are...

There are a number of issues you should look at.

a) High page file usage. Try to find the cause of this. You should limit the maximum memory SQL...

Maddy,

Why do you think you need to restore master. This is something you should plan to avoid. Please let us know your situation, as some of us may...

Brandie Tarvin (10/29/2007)

---

I was under the impression, generally speaking, that the master db doesn't change that much or very often at all. That being the case, why would you...

I think saying SQL 2008 will be released in Feb 2008 is speculative, in spite of what has been announced by MS.

If the next CTP of SQL Server 2008 (due...

I think you need to talk to your management about cost and risk.

Using standard SQL backup followed by a Zip is potentially greater cost and risk than using a 3-party...