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...

The error message means exactly what it says. Right above your ORDER BY, you need a GROUP BY statement that lists out every field that is not aggregated in...

Why bother copying the files for TempDB? It practically gets "recreated" every time the service gets stopped. Just run the Alter Database command on the files, stop the...

And yet a poorly written ETL process could inadvertantly orphan records. Since I might not be the only person writing ETL processes (we're starting out with two DB sources,...

You mean besides referential integrity between the Fact table and the Dimension tables?

My setup includes 3 star schemas that overlap each other on one of the dimensions. I'd like to...

Steve, Unfortunately, all my different entities have different fields. Again with the Junk Dimensions issue. I might end up with a 40+ column wide "archive" table with millions of...

Isn't Ralph the name of your evil twin brother, Ryan? @=)

I've actually been thinking about that, but it would involve adding at least 12 more tables to my DB.

I did find an interesting article on "Junk Dimensions" in SQL Server...

I used to think that, but given how Indexes are set up (depending on the Clustered or Non-Clustered) and whether or not you have Triggers / Defaults / Etc... I...

Ryan,

If you read his first post, he doesn't want to SUM the QuantityShipped. And I was only addressing the math problem, not the GROUP BY (although I should have...