I use the index almost exclusively. It seems to be the best way to find what I'm looking for.

The % operator is in Books Online. The actual name is modulo (though most people know it as mod in part because many programming languages use MOD as the modulo...

No, need. I'm quite aware that the client processing time is due to processing 1000000 recordsets of 1 record instead of 1 recordset of 1000000 records.

Ironically, I tested it with...

My laptop is a 1.8 Ghz single AMD Turion 64 bit CPU (though with 32 version of Vista) with 2 GB of RAM on SQL Server Express 2005 SP2

My code was...

I wasn't attempting to choose or even write the best option. I was merely pointing out that they could get the same result by checking for % 15 as they...

Well, 2 comments to this:

1. It would depend on whether or not I believed that it was a typo or a big gaping hole in the applicant's understanding of how...

Hotfix build 2153 claims to fix some CLR memory leak problems (also claimed in SP2 as it includes the build 2153 hotfix).

If you are actively using the CLR in SQL...

I would discount any solution that resorted to the CLR for something that T-SQL can do. It's quicker now, but once the infamous SQL CLR memory leak kicks in, your...

I believe it was Jeff Moden who touched on code readability. As someone that has interviewed many database developers and even hired a few of them, if someone submitted the...

If I modify my query to output 1,000,000 rows, it runs in 3 seconds and does not peg the single CPU of my laptop.

You're right. From your comments, I had assumed you were using a table of your own creation. My mistake!!

However, your query would still fail the test as it only...

Interesting example, but fails to follow the directions. The directions is to substitute the value with the string, not provide it as a second value.

I'm afraid you wouldn't make it to the 2nd round. If you're interviewing for a job, you're not going to already have that table in there. Your query would return...

Let's use a little logic. Any number divisible by both 3 and 5 will be divisible by 15. You don't need to check for both 3 & 5, you simply...

Sounds good to say that there is a insignificant difference between 4 bytes and 16 bytes, but when you get to 2,147,483,647 records, the size difference is 8,589,934,588 to 34,359,738,352...