Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,006 through 43,020 (of 59,063 total)

RE: Help us tune a query

GilaMonster (7/14/2009)
Jeff Moden (7/14/2009)
Jack Corbett (7/14/2009)
Was Jeff referring to the Order By in the ROW_NUMBER() function?
Yes.
Ok, misunderstood you earlier. Are you suggesting adding a second temp table, one to store...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 14, 2009 at 12:59 pm

#1024644
RE: Help us tune a query

Jack Corbett (7/14/2009)
Was Jeff referring to the Order By in the ROW_NUMBER() function?
Yes.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 14, 2009 at 10:54 am

#1024565
RE: Help us tune a query

GilaMonster (7/14/2009)
Christopher Stobbs (7/14/2009)
but creating the clustered Index on #TopScores after the actual insert?
Would this help at all?
If the cluster goes on after the insert then first SQL has to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 14, 2009 at 10:53 am

#1024563
RE: Help us tune a query

Mel,
I haven't had the time to look at all the fine suggestions folks may have given, but if I look at your original query, I see the potential for a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 14, 2009 at 5:48 am

#1024334
RE: Update where field is NULL

You bet. Thank you for the feedback.
As a bit of a sidebar, NULLs are some of the oddest things and can also be a very, very powerful tool depending...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 14, 2009 at 5:30 am

#1024327
RE: DBCC IND - how can I run it when there is a locked row in the table I am looking at?

cb (7/13/2009)
Hi Gaby
Whilst everything you say is true, the environment I have to deal with is:
Software vendor creates a product based on SQL, and sells it to client.
Client wants some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 14, 2009 at 5:19 am

#1024319
RE: Create a Tally or Numbers Table

I'd have a hard time doing that because Number is a reserved word but to each their own. Also, are you implying that you have two separate tables? ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 14, 2009 at 4:59 am

#1024315
RE: Are the posted questions getting worse?

Matt Miller (7/13/2009)
Jeff Moden (7/13/2009)
Dave Ballantyne (7/13/2009)
You can lead a horse to water but you cant force him to drink
Heh... well... you can if you don't mind getting your lips...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 14, 2009 at 4:44 am

#1024310
RE: Update where field is NULL

On most systems, you cannot say WHERE something NULL... instead, you usually have to say WHERE something IS NOT NULL or WHERE something IS NULL depending on what you're...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 13, 2009 at 10:27 am

#1024027
RE: Are the posted questions getting worse?

Dave Ballantyne (7/13/2009)
You can lead a horse to water but you cant force him to drink
Heh... well... you can if you don't mind getting your lips dirty. I'm going...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 13, 2009 at 8:59 am

#1023937
RE: Split string using XML

Eralper (7/10/2009)
Actually, I made a simple test to see that the xml function is quicker.
Actually, let's see THAT test. 😉 I already posted mine.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 13, 2009 at 8:24 am

#1023910
RE: Split string using XML

Kindred spirit, Goldie. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 13, 2009 at 8:13 am

#1023900
RE: The Worst Advice

rf44 (7/12/2009)
Maybe I should precise that I never intended to promote or even condone the use of cursors. I know that cursors are not efficient tools in MS SQL Server...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 13, 2009 at 6:55 am

#1023838
RE: The Worst Advice

rf44 (7/11/2009)
Answering "never, ever use a cursor" or something equally smart.
The poster did not ask for a personal opinion about cursors (even if it's a wise one), he asked for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 12, 2009 at 7:57 am

#1023612
RE: The Worst Advice

Dave Ballantyne (7/11/2009)
Only heard it once , but it was from a trainer on a vb .net course from one of the largest training companies in the uk.
Dont use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 12, 2009 at 7:49 am

#1023611

Viewing 15 posts - 43,006 through 43,020 (of 59,063 total)