What happens if you change select * to specific column names?

See this for more info...

http://www.sql-server-performance.com/transact_sql.asp

Apparently it will evaluate AND from left to right but Or's are not indicated as exiting.  But there appears to be performance issues with OR's...

one more suggestion --

 SQL Server Query Performance Tuning Distilled

(http://www.curlingstone.com/)

In addition to really good advice - it is well written.

I use a script that is something like:

select

sum(case when a.field1 <> b.field1 then 1 else 0 end) cntErrfield1,

sum(case when a.field2 <> b.field2 then 1 else 0 end) cntErrfield2,...

from tbl1...

Dynamic sql:

declare @selField varchar(50), @sql nvarchar(1000)

declare @selTbl varchar(50)

set @selField = 'name'

set @selTbl = 'sysobjects'

set @sql = N'select '+@selfield+' from '+@seltbl

exec sp_executesql @sql

Yes, thats right. It needs to be a datastream. You can still use bcp but you would need to attach the file to an email to send it - thats what i...

I am pretty sure you could use ado but I dont have a lot of experience with it so I am not able to help much beyond that.

If you...

use the ordinal position in your case statement. No dynamic sql required.

Set @order = 2

select empid, empname

from employees

order by case @order

when 1 then empid --(or 1)

when 2 then empname

when....end

it has to be in the form of a data stream - bcp or ado

see this for suggestions:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=21&messageid=160112

There is no rule that you primary key must be an identity field. An int is faster to deal with but if it isnt convenient to use that isnt going...

how large SQl Server can be is directly related to the space available on the server. You are not in danger of maxing out SQl but you might be in...

its not clear to me how you are trying to do this. If you are still looking for an answer can you please indicate if you are trying to query...

Do you enjoy numbers and puzzles? Risk analysts require advanced SQL skills and do pretty well financially. Often you also need a masters but you can do pretty well as a...

I needed a separate book for mysql. Luckily the online manual is very good and free to download. you can also buy it in print. So far it has had what...

SQL server can handle it given appropriate...

hardware configuration

maintainence plan

query and achitect performance optimization