Viewing 15 posts - 1,981 through 1,995 (of 3,232 total)
Great article Jeff! I agree in that I've read sooo many posts that were so badly presented that I simply move on to another. I read/answer posts while...
November 27, 2007 at 3:22 pm
Really, your best bet here would be to not default your value to 'Select One' but to default it to NULL instead or to use a stored procedure for your...
November 27, 2007 at 9:10 am
Try using NULLIF. Here's an example:
declare @table table (sex varchar(10))
declare @CSex varchar(20)
set @CSex = 'Select One'
insert into @table
values(NULLIF(@CSex,'Select One'))
set @CSex = 'Female'
insert into @table
values(NULLIF(@CSex,'Select One'))
select * from @table
November 27, 2007 at 8:59 am
Well, I see a couple of things wrong here. First, you cannot have a 'SELECT' statement in a VALUES clause and second, you have no END on your CASE...
November 27, 2007 at 8:32 am
In that case, the JOIN should out perform the SELECT most of the time as PW and Gail have already posted. Write both SQL statements and do a performance...
November 26, 2007 at 10:18 am
tfifield (11/21/2007)
November 23, 2007 at 10:04 am
David Paskiet (11/21/2007)
DDarn! Rich beat me to the punch! :w00t:
Close David, you were only 4 hours off :Whistling:
November 21, 2007 at 2:31 pm
The backup operation will read the .mdf and .ldf file locations from the backup header. So by default, it will try to restore the database to the exact same...
November 21, 2007 at 2:12 pm
There are 2 types of read only modes. One is a database level option that you can set to make the DB read only. The other, and more...
November 21, 2007 at 2:02 pm
SQL Server 2005 offers new optimistic isolation levels that may help you out here but it would not be portable to your SQL Server 2000 box and it must be...
November 21, 2007 at 1:39 pm
It looks like your post got cut off, can you re-post your code.
Also, your question states 'what is faster', what do your tests show?
November 21, 2007 at 1:32 pm
This looks like it would be a pretty easy one to test. Have you tried to do this yet? If so, did you get an error?
November 21, 2007 at 12:48 pm
Well, it probably has to do with the number of reads. While your old query is written as a LEFT JOIN, the query analyzer will treat it as an...
November 21, 2007 at 12:41 pm
If you are applying SP4, you will still be on Standard Edition. SP4 is a service pack upgrade. Going from Standard Edition to Enterprise Edition is a version...
November 21, 2007 at 10:25 am
It IS a balancing act, but starting with the attitude that FK's are worthless (which is what you're not just portraying - it's like you're screaming it from the rooftops)...
November 20, 2007 at 3:03 pm
Viewing 15 posts - 1,981 through 1,995 (of 3,232 total)