Definitely put together this utilization stuff for an article, please. That would be FANTASTIC.

And if your tempDB is full, no query you write on that SQL Instance is going to work. All databases utilize TempDB to some extent (even if you don't...

Dean,

Unfortunately, a generic "I'm getting errors" doesn't give us anything to go on. We're not going to do all your work for you. If you want the correct...

It Depends... (a DBA's favorite answer).

There is no right or wrong way in this situation. There is only your situation.

My advice is to set up a job...

GilaMonster (7/24/2008)

My main system is more a datawarehouse than anything. It grows and...

20GB should be fine so long as you don't put any SQL Server databases (including system DBs) on your C: drive.

Usually I reserve C: drive for the OS and for...

Gail,

AHHH. We're not encountering latch errors, but I haven't split the TempDB for the same reason I haven't split out other DBs. It didn't make sense from an...

Sheer laziness or the inability to properly determine the growth rate of your DB. @=)

Actually, our unrestricted DBs tend to be in our DEV environments where we're unsure of...

SOX compliance....

Here's what you need to do. Be warned, it is TEDIOUS and work intensive.

First, list out every account you have in SQL Server with that account's permissions and db...

Angie,

We actually have some DBs with UNRESTRICTED on them, but on the other hand, we also have several Alerts and jobs set up to monitor Hard Drive space. When...

I just cut-n-pasted this into SSMS verses my SQL 2000 db. It appears you're only getting Syntax errors. Run a check against the code, double-click the error and...

I'd really love to have enough partitions in my SAN to have more than one file for my TempDB. @sigh. Gail, you're making me jealous. @=)

Wow, I did not read your response carefully enough...

When I say...

B_Boy,

Syntax-wise, it is acceptible to put the ISNULL outside of the SUM, but practically speaking, it's a bad idea.

If there is one single NULL value in the column you are...

And I would STRONGLY urge you to use a CASE statement to verify your QuantityShipped is not NULL or Zero or you will, at some point in the future, get...