Viewing 15 posts - 8,746 through 8,760 (of 9,725 total)
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...
July 24, 2008 at 7:44 am
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...
July 24, 2008 at 7:42 am
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...
July 24, 2008 at 7:37 am
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...
July 24, 2008 at 7:26 am
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...
July 24, 2008 at 7:18 am
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. @=)
July 24, 2008 at 7:06 am
Wow, I did not read your response carefully enough...
Is this okay
CASE WHEN ISNULL(SUM(QuantityShipped), 0) = 0 THEN 0
ELSE SUM(T_OrderLine.[Unit Price] * T_OrderLine.QuantityShipped) / SUM(T_OrderLine.QuantityShipped) END AS [A.S.P]
When I say...
July 23, 2008 at 11:32 am
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...
July 23, 2008 at 11:23 am
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...
July 23, 2008 at 10:43 am
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...
July 23, 2008 at 10:41 am
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...
July 23, 2008 at 6:24 am
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,...
July 21, 2008 at 10:56 am
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...
July 21, 2008 at 7:27 am
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...
July 18, 2008 at 7:26 am
Isn't Ralph the name of your evil twin brother, Ryan? @=)
July 18, 2008 at 5:40 am
Viewing 15 posts - 8,746 through 8,760 (of 9,725 total)