Jonathan

Forum Replies Created

Viewing 15 posts - 601 through 615 (of 921 total)

RE: Updateable Cursors

quote:
Thanks For Your Help Guys. But I have a problem, the solution of using the update statement which included the case statement...

--Jonathan

October 28, 2003 at 9:35 am

#479910

RE: Tricky SQL Problem



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

#479908

RE: Perf. counters not affected by memory encrease

quote:
I believe the recompilation are still processed within the 3GB memory spaces the SQL Server can address.

--Jonathan

October 28, 2003 at 9:04 am

#479903

RE: RowNum Function in SQLServer

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

--Jonathan

October 28, 2003 at 7:18 am

#479868

RE: Database size, I am confused

quote:
Using Enterprise manager view the database (in 'task pad' view for SQL2000) and select 'Table Info' - Compare the two databases and...

--Jonathan

October 28, 2003 at 6:50 am

#479859

RE: Setting a DateTime Field to NULL

quote:
I did a simple test: run query
select convert (datetime, '')
The results were 1900-01-01 00:00:00.000
I think that it is casting '' to...

--Jonathan

October 28, 2003 at 6:41 am

#479858

RE: Perf. counters not affected by memory encrease

quote:
quote:
If you're performing more query plan compilations now, then your cache Hit Ratio would...

--Jonathan

October 28, 2003 at 6:27 am

#479853

RE: SQL on the Internet. A License Question!

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

--Jonathan

October 27, 2003 at 3:40 pm

#479783

RE: Unable to increase size of varchar column

quote:
Well under 8K - I'm not even able to increase size by 1.
I also posted this in the General forum and a...

--Jonathan

October 27, 2003 at 2:26 pm

#479771

RE: Setting a DateTime Field to NULL

quote:
Thank you Jonathan. My understanding was that a column wouldn't accept a NULL if a default was set.
-SQLBill

--Jonathan

October 27, 2003 at 12:55 pm

#479754

RE: Perf. counters not affected by memory encrease

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

--Jonathan

October 27, 2003 at 11:49 am

#479734