I heard early on that 50 databases was a limit, but I've not seen anyone running that far. I did see this blog (http://www.naterice.com/articles/70) where they mention a 64 bit...

File copy using VBScript or Powershell to move the files. VBScript with the FileSystemObject is pretty easy to write to move the files, and there should be scripts here on...

I think there is something that reads a header and deletes files, not just based on the extension. I found some issues with this in 2005, and I wouldn't be...

The question to ask yourself is why are you shrinking tempdb? If it grows every day, and you shrink it with a job, you're wasting cycles and disk I/O. Tempdb...

Check the error log in Windows for a reason why the service didn't start.

Thanks for the test. I've seen this before and can usually insert a space or two to clean it up.

There's a [ code = "sql ] tag to the left when you post. Use that. (spaces added so you can read this)

Derek Dongray (7/15/2009)

---

It is embedded HTML. If you look at the source of this post (753126) You'll see that what appears as

should actually have the characters < /...

How are you loading the data? Or querying it, which is what I think you mean.

You can compare the default session settings in SSMS as well. Right click server, properties,...

I know there are people using these to enforce naming of objects.

There are also people that use this to ensure that new instances are configured according to some rules they...

My guess is your database is in the full recovery model and you are not making log backups.

The short answer is that you should:

1. Backup the transaction log with truncate_only

2....

First physical drives matter. If you have 20 logical drives on the SAN that all are built on the same physical drives, you aren't helping.

You have to clarify what you...

A logical drive is a partition of a physical drive. It can be a complete partition of a drive or a partial partition.

A physical drive is where you determine performance....

It's a way for your to consume system data from a view, instead of having to parse results from sp_configure.

I assume you mean created 3 years ago or earlier. Lee's code should do that.