Good question.

I didn't realize that the union would affect the first table as well. Was expecting both of the 1's to still be intact and therefore give 5 instead of...

As always the real answer is test, test and more tests...

But looking at the stats and the output of the 2 statements, I will not be feeling guilty about using...

Thanks for the question.

I hardly use math functions at work, so its sometimes a shock that these simple functions can be so tricky..... A misunderstood (or missing) parameter would mean...

Now this is a good question....:-D

From now on I will be more careful when using [] in my code...:w00t:

Thanks for something practical and not another trick question that hides something.

Thanks for the link SQL Kiwi!

But, is it your favorite?:rolleyes: Am reading through it now....

Why are there so many questions about SQL Server Code names?

Do I need this for the exams or is this just reminiscing about the 'Good Ole Days'?:hehe:

I was robbed....:( the 3rd answer is wrong!

I was going to say Good Question and Good Explanation but after reading the posts and trying to understand the rounding, I'm not so sure anymore:doze:

Anyway its still a good...

I believe we don't have just the basic indexes because in our OLTP environment, there are just too many inserts into this table and the reports are run only by...

Thanks Gail for the explanation. Much appreciated.

To Rich, the only comment I can offer is that in Itzik Ben-Gan's book 'Inside Microsoft SQL Sever 2008:TSQL Querying' (see link in earlier...

Sorry for taking so long to reply; I'm replying while at work.

Please see below links:

http://www.sql.co.il/books/insidetsql2008/Logical%20Query%20Processing%20Poster.pdf

http://blogs.x2line.com/al/archive/2007/06/30/3187.aspx

Please could you give your views on this as there are probably...

That was my example to show that the IN statement would be quicker. No, there isnt an index on the called number, and the table is huge, but I am...

Thanks for that Guys.

Its been worrying me since I read in a book that sql will join tables from left to right. I guess they were simply explaining how the...

That isn't much of a poll....

Please try a search and see what comes up. I would suggest getting Microsoft Certified and that is what I'm doing after reading an excellent...

Unfortunately it is a big table. If I use = and put the exact wording will that be faster? I will have to put about 7...