Yes that's just what I mean - so if you have say IF (A!=B OR C!=D) then there is no need to evaluate C!=D id A did not equal B...

dgvsbabu (11/21/2007)

---

If you want to copy table including data you can try the below querry

select * into otherdbname..tblname from currentdbname..tblname

otherwise if you want to copy ony the table structure try...

Surely it isn't beyond the realms of what the optimiser is doing ... but as database is one area MS does have real competition I guess if...

So MS could add a performance boost in SQL2009 by short circuiting ...

No wonder it was faster ....

If any of the variables are Null if will be doing a compare with a Null which is a no no -- perhaps this simple...

Pedantically you should use LIKE '[_]WA[_]Sys[_]%' because the underscore is a match for any single character in a like clause so Like '_WA_Sys%' would also match e.g. XWAZSYsIndex though of...

Most interesting ...

I guess the most likely indexing regime would be the single index per column (i.e INDEX A, B and C) - and in that mode the IS NOT...

Will do ... if it is e.g. MyID=IsNull(@MyID,MyID) then I would think it can still use any index on MyID rpovided @MyID was NOT null and the optimiser might be...

SELECT 1 FROM dbo.tblRoadShowAllocation

WHERE

RoadShowID = @RoadShowID AND

RoadShowEventID = @RoadShowEventID AND

SellerID = @SellerID AND

EmployerID = @EmployerID

)

The problem is that @RoadShowEventID and @SellerID can be null....

Thanks for answering for me Adam - I have also PM'd the answer - I never really considered it before but I guess it is confusing that CHAR() is both...

Maybe something like this:

DECLARE @sql nvarchar(4000)

DECLARE @counter int

SET @sql='ALTER VIEW VW_MYVIEW AS ' + CHAR(13) + CHAR(10)

SET @counter = 0

Select top 13 @counter = @counter + 1, @sql = @sql...

WinZip is really becoming BloatWare now so...

I do of course agree with you that you can't generalise - but many (most?) businesses do actually generalise by deciding they can't possibly share any changes they have made...

Steve Jones - Editor (10/23/2007)The problem with giving back to open source, in many cases, is that the competitive advantage you might gain from adding your own cool customization or...

Kenneth Gladden (8/16/2007)

---

Long story but a vendor dropped and reattached my databases but did not reattach the MSDB database. As a result all (about 40) of my DTS packages are...