Eric,

Timeouts are usually caused by resource contention. The problem that you have with using Virtual servers is that you may be sharing resouces with other Virtual servers running...

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

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

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

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

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

tfifield (11/21/2007)

---

This is really a matter of what the database was created for. If there is only 1 front end application doing all of the inserts and deletes, there...

Close David, you were only 4 hours off :Whistling:

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

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

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

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?

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?

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

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