Viewing 15 posts - 391 through 405 (of 938 total)
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...
November 26, 2007 at 10:23 pm
Sergiy (10/17/2007)
It's on top of the page, between "Home" and "T-SQL".
There is no point to...
October 17, 2007 at 7:27 pm
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...
October 17, 2007 at 5:33 pm
Example removed at Sergiy's request.
October 16, 2007 at 6:48 pm
Something like this should do the trick, using [font="Courier New"]censored[/font]:
Sample code removed at Segiy's Request
October 15, 2007 at 7:31 pm
That brings up the Y10K problem, and Joe Celko's descendants will be cursing your name for not addressing it in the 21st century 🙂
October 10, 2007 at 3:12 pm
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...
October 10, 2007 at 10:16 am
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...
October 9, 2007 at 12:55 pm
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...
October 9, 2007 at 7:34 am
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...
October 5, 2007 at 5:35 pm
Another classic editorial Steve If I keep reading yours I might eventually get the hang of it
September 5, 2007 at 10:16 pm
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...
September 3, 2007 at 9:30 am
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...
August 30, 2007 at 1:16 pm
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...
August 30, 2007 at 1:08 pm
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...
August 30, 2007 at 4:48 am
Viewing 15 posts - 391 through 405 (of 938 total)