Viewing 15 posts - 2,611 through 2,625 (of 2,645 total)
Matt Whitfield (1/1/2009)
Jeff Moden (1/1/2009)
Yes! He actually want's to delete FROM from UPDATE. The smiley face was an indication of something else this time...
Daym.
Has anyone told him about...
January 1, 2009 at 4:44 pm
Haroon Said (12/24/2008)
December 24, 2008 at 3:02 pm
Matt Whitfield (12/24/2008)
I didn't get any faster results out of the firehose than I did out of the select-only method. I ran it a few times, they came out...
December 24, 2008 at 8:33 am
Shane Redding (12/24/2008)
December 24, 2008 at 7:17 am
Matt Whitfield (12/24/2008)
SET NOCOUNT ON
declare @query varchar(100), @id...
December 24, 2008 at 6:16 am
Jeff Moden (12/24/2008)
Good idea, Gaby, and good article...
Could you list one thing that's a good idea in this article, spelling mistakes aside?
December 24, 2008 at 3:18 am
A bit of an odd example to pick. All that effort to avoid using a cursor on an example that executes dbcc checkdb for each of just a few rows....
December 24, 2008 at 2:59 am
My original actual query was a lot different and maybe I've over simplified it for want of a simple example. I used to have two tables, RefDates which was just...
November 28, 2008 at 10:47 am
Jeff Moden (11/28/2008)
I have SET NOCOUNT ON in the test code so I can't do the verification. Pardon me for asking stupid questions, but I have to check... Have...
November 28, 2008 at 9:15 am
Jeff Moden (11/28/2008)
===== Set based method with Date table =====
SQL Server Execution Times:
...
November 28, 2008 at 8:45 am
Joe Celko (11/28/2008)
You build a look-up table once (and if you did a proper calendar table, you also benefit from other uses). ...
November 28, 2008 at 8:10 am
Jeff Moden (11/27/2008)
jacroberts (11/27/2008)
Here's my example:
We had a...
November 28, 2008 at 5:51 am
Lynn Pettis (11/27/2008)
jacroberts (11/27/2008)
Lynn Pettis (11/27/2008)
jacroberts (11/27/2008)
timothyawiseman (11/27/2008)
jacroberts (11/25/2008)
timothyawiseman (11/24/2008)[hr
This is true, for a small number of rows. Your RBAR TVF will become ineffecient should requirements change and the...
November 27, 2008 at 12:40 pm
Lynn Pettis (11/27/2008)
jacroberts (11/27/2008)
timothyawiseman (11/27/2008)
jacroberts (11/25/2008)
timothyawiseman (11/24/2008)[hr
This is true, for a small number of rows. Your RBAR TVF will become ineffecient should requirements change and the number of rows...
November 27, 2008 at 10:41 am
timothyawiseman (11/27/2008)
jacroberts (11/25/2008)
timothyawiseman (11/24/2008)[hr
>>The problem is that your example did not show a case where efficiency is not a concern.
>>But, in your example you say there is no need to...
November 27, 2008 at 9:43 am
Viewing 15 posts - 2,611 through 2,625 (of 2,645 total)