I also disagree with the "correct" answer. And the link to the background information on the answer page is broken, so I can't find any reference material to support the...

I, too, assumed that the second 2382 was intended to read 2383. So I, too, missed getting this question right.

🙁

Hi Wayne,

>>I dont see a list of any new features included in the service pack<<

On the download page for the SP2 CTP, there's a link to an overview of all...

Richard,

You wrote:

>> I think this is because SQL ignores trailing white space when comparing strings. <<

<pedantic>

Not exactly. SQL Server will pad the shorter string with spaces to match the length...

Hi,

I don't think that this answer is correct. Checking Books Online, I see that the OPENROWSET(BULK ...) command only accepts a filename as parameter, plus optionally a formatfile and several other...

Hi Trigger,

The @numDays parameter is the number of business days to move forward in time.

To get 2006-12-27, you should have used:

SET @Date = dbo.

Hi Simon,

The point you are making is absolutely correct, but your example isn't.

The query you posted would probably use a scan on the IX_Person_DateOfBirth table, followed by a bookmark lookup...

What bugs me, is that the answer, the explanation and the further description on replicationanswers.com appear to be in direct contradiction with the description in Books Online. See the page at:

 ...

I understand the approach, but I don't understand the reasons for it.

Wouldn't it be a lot easier to just:

1. Create stored procedures for all data modifications;

2. Have checks for validity...

Hi Steve,

No apologies needed. To err is human - you've just proven that you're still one of us <g>.

Thanks for the speedy reaction!

>> Correct Answer: The maximum size of a text field on the server. 2GB in SQL Server 2005.

>>

>> You Answered: The current value of the TEXTSIZE option for...

Hi Steve,

Can I offer one more learning suggestion? Microsoft E-Learning features a set of upgrade courses targetted specifically at people who are already familiar with SQL Server 2000 but need...

The "correct" answer is in fact only partially correct. FTS will first search for word breakers and stemmers for the language family (for instance, using French word breakers if Canadian...

Hi Skip,

>>The problem I found was that you don't get exact representation when using float<<

Of course you don't - check Books Online. Float is an approximate-number data type. For most...

Nice function.

Tip 1: Instead of the CASE to get rid of negative values, use ABS.

Tip 2: Add a CASE to work around the domain error you'd get from LOG10(0).

Tip 3:...