Hey Jeff, people trying to get answers in the newsgroups can certainly learn from your experience. The only thing I would add is that it also helps if people...

Sergiy (10/17/2007)

---

Mike, it would be nice if you'd pay some attention to the name of the forum.

It's on top of the page, between "Home" and "T-SQL".

There is no point to...

Sergiy,

Would it make you feel better if I said this feature was introduced in SQL 2005, as I did a couple of times in the first couple of posts of...

Example removed at Sergiy's request.

Something like this should do the trick, using [font="Courier New"]censored[/font]:

Sample code removed at Segiy's Request

That brings up the Y10K problem, and Joe Celko's descendants will be cursing your name for not addressing it in the 21st century 🙂

You got it. Think of it like this - if you use a function in a WHERE clause or in an ON clause of a JOIN, SQL is forced...

That's because the integer/smallint/tinyint data types have higher precedence in conversions, so the implicit conversions will try to convert character types to int* types. The COALESCE function you used...

Hi BonnieMan,

COALESCE() is different from ISNULL(), and I would guess that the difference in performance you experienced is probably owing to the differences in how COALESCE() and ISNULL() implicitly cast...

I just performed a quick + dirty test to see the performance difference of using COALESCE in the WHERE clause. I ran three tests on the same simple data...

Another classic editorial Steve   If I keep reading yours I might eventually get the hang of it

Worth noting that you can use use " select * " rather than " select 1 " or " select 12345 " for that matter.

I have a sneaking suspicion that using select...

It's been reported that they've grandfathered in some sort of long-term "loss-leader" contracts from back in the day just to keep their sales numbers up (those pesky shareholders want to...

The soldiers reported having been Sprint Nextel customers for several years prior to this incident.  When they arrived back in the States, Sprint Nextel was more than happy to upsell...

One thing that's really confusing about the Sprint Nextel situation is that the customers they are firing are not bad customers.  These appear to be people who pay their bill...