Please describe your current hardware configuration. ie TempDB is located on ??, RAID ??

Etc.

What kind of SAN are you currently using?

Is everything on it and how is it configured?

Please post your BCP command, as well as your form if you are using one.

Good question, and to Carlos - great addition.

Learned something new form both

Paul - here is another link that may explain the recoveryinterval better:

http://msdn.microsoft.com/en-us/library/ms191154(SQL.90).aspx

The recovery interval doesn't necessarily state how often that checkpoint will run but to have it run often enough...

Paul

I never mentioned log backups. Correct me if I'm wrong, but in simple recovery mode, doing a full backup will checkpoint the log file and allow for re-use. Is there...

Simon

I was simply trying to raise awareness about a common and often misunderstood command - the SHRINKFILE command as it relates to Data Files (not Log Files - see a...

Shrinking a database file (either using SSMS or T-SQL code) should be avoided if at all possible. In an ideal situation, it is much better to size the file appropriately...

Are all of the server startup services starting up with the same login, and what is the level of permissino for this login. We have over 200 servers talking amongst...

Which worked out great for me - as these were the reasons that my company got called in to...

SQLGuru

That is exactly the issue that most of my clients THINK is true, yet almost always is not. You have to scan the big temp table (tempdb read) then build...

The SQLGuru

I can probably count on my two hands cases where a query actually BENEFITED from such. But I can count probably a few hundred times where I have seen...

Very good question - I learned something today.

Hugo

If you take away the knowledge that you can use the OVER() clause for all aggregates except CHECKPOINT, that's fine. But if you...

Great question and explanation. Reinforces the need to pay attention to detail.

Simply put - yes. BUT (there always has to...

Additionally (suprised that Gila hasn't mentioned this yet) the continual grownig and shrinking of the database filse will cause fragmentation of the files, which will add to the overhead of...