Viewing 15 posts - 601 through 615 (of 921 total)
quote:
Thanks For Your Help Guys. But I have a problem, the solution of using the update statement which included the case statement...
October 28, 2003 at 9:35 am
SELECT SUM(CASE WHEN LocationTo = 1 THEN Qty ELSE 0 END) - SUM(CASE WHEN LocationFrom = 1 THEN Qty ELSE 0 END)
FROM Parts
WHERE Part = 'A'
--Jonathan
October 28, 2003 at 9:22 am
quote:
I believe the recompilation are still processed within the 3GB memory spaces the SQL Server can address.
October 28, 2003 at 9:04 am
As Crispin mentioned, be careful with the set methods when working with large tables, as the performance can degrade remarkably. Also, unless you want "golf tournament" ranking, you will...
October 28, 2003 at 7:18 am
quote:
Using Enterprise manager view the database (in 'task pad' view for SQL2000) and select 'Table Info' - Compare the two databases and...
October 28, 2003 at 6:50 am
quote:
I did a simple test: run queryselect convert (datetime, '')
The results were 1900-01-01 00:00:00.000
I think that it is casting '' to...
October 28, 2003 at 6:41 am
quote:
quote:
If you're performing more query plan compilations now, then your cache Hit Ratio would...
October 28, 2003 at 6:27 am
quote:
Unless you know you're going to have X number of concurrent users, you're probably better off buying per processor.The licensing is legal...
October 27, 2003 at 3:40 pm
quote:
Well under 8K - I'm not even able to increase size by 1.I also posted this in the General forum and a...
October 27, 2003 at 2:26 pm
quote:
Thank you Jonathan. My understanding was that a column wouldn't accept a NULL if a default was set.-SQLBill
October 27, 2003 at 12:55 pm
Wait a minute...
If you're performing more query plan compilations now, then your cache Hit Ratio would of course decrease; this would be normal after startup because the procedure cache starts...
October 27, 2003 at 11:49 am
quote:
First of all, thanks to both of you. Jonathans code gave me the right total for the correct day, but didn't...
October 27, 2003 at 11:18 am
quote:
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any...
October 27, 2003 at 10:43 am
Use the formatting capability of your front-end language.
--Jonathan
October 27, 2003 at 10:39 am
Viewing 15 posts - 601 through 615 (of 921 total)