Select 'Our only member so far is ' + firstname + ', ' + lastname + '. Let''s all say hello.'

from names

Fix the formatting as you want.

The only acceptable way to compare dates is something like the following:

WHERE datecol >= @startdate AND datecol < @enddate

See SQL Server MVP Tibor Karaszi's excellent article "The ultimate guide to...

But you are using OBJECTPROPERTY incorrectly. The first parameter (which is called id) should contain the object_id of the object you are checking a property for, and the second parameter...

B, F

The procedure cache is part of the memory pool for each specific SQL Server instance. So if you move a database from one server to another then naturally the procedures...

A column with the identity property is a surrogate key, and as such should never have any meaning in reality. If you have data that should be labeled as wp00001...

Have you got SQL Server 2005 installed on the same machine? I had a similar problem when I had that setup, think it was back in Yukon Beta 2 days.

Yep, I do not normally use case-sensitive servers, but I always try to enforce naming and coding conventions that say exactly how to name objects and write code, where to...

Very good point David. And it is in fact much worse for sp_executesql, since there it means that a new plan must be compiled (and cached) in order to execute...

I agree with the others, very interesting article and something that I did not know about. However, I am not quite sure that everything is fully correct in the article,...

Not any way that I can think of. Either shut down SQL Server or detach that specific database while you are defragging the files, otherwise it will not work.

David: Using those tools I mentioned you will have to sum up the numbers. Ad msuraski said there are other tools that can give a better idea of the entire...

Ah, you're right, I can't change the licensing mode. Only add extra per seat licenses...

slider,

It is both ways. If you create and test the scenario I describe you will see that it is John.Orders that is truncated. Normally SQL Server will default to...

Chris,

Your thoughts about my intent of the example are correct. I never even thought about the possibility to misinterpret it the way you fear 'newbies' might. But I do understand...