Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,861 through 34,875 (of 59,099 total)

RE: is UNION ALL inherantly slow?

BenWard (2/28/2011)
Ah genius! thanks fellas 🙂
having done some testing using insert instead of union is VASTLY quicker and requires less re-write of our existing programs so we'll probably end up...
--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)

February 28, 2011 at 7:22 pm

#1292682
RE: High CPU usage due to bad execution plan occurs unexpectedly

Gosh... if it's only running 100 times in 5 minutes, try adding OPTION(RECOMPILE) to the offending statement and you'll likely be done with the problem.
--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)

February 28, 2011 at 7:14 pm

#1292681
RE: documentation

magasvs (2/28/2011)
Something else important that you should request - installation media for all versions of SQL Server installed in company.
And proof of licensing.
--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)

February 28, 2011 at 6:49 pm

#1292679
RE: Are the posted questions getting worse?

Craig Farrell (2/28/2011)
Personally preferring nice nylons myself, but that may have more to do with who I have in mind wearing them at the time....
.... AAAAaaaaand I'm in trouble again....
--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)

February 28, 2011 at 6:05 pm

#1292674
RE: How to tune/speed up a procedure

gregory.anderson (2/28/2011)
Jeff Moden (2/21/2011)
gregory.anderson (2/18/2011)
Been searching on how to concatenate rows into a single field and I found a link to a recursive CTE for unknown number of rows 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)

February 28, 2011 at 5:46 pm

#1292672
RE: Are the posted questions getting worse?

Craig Farrell (2/28/2011)
Hey Jeff, your mailbox is full again. I didn't want to keep cluttering up the newbie's thread regarding unioning and the like, he's got enough confusion 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)

February 28, 2011 at 5:37 pm

#1292667
RE: 'Pretty-up' the code

The hierarchical examples of Recursive CTE's in BOL aren't that bad and they aren't actually full blown RBAR because they process full levels at a time instead of just one...
--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)

February 28, 2011 at 5:11 pm

#1292664
RE: Odd Questions

Eric M Russell (2/28/2011)
Jeff Moden (2/25/2011) . . .
You're locked in a cell with a steel floor. At the center of the room is a pipe with massively thick...
--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)

February 28, 2011 at 7:46 am

#1292318
RE: SQL & the JOIN Operator

SQLkiwi (2/27/2011)
Jeff Moden (2/27/2011)
Isn't this a bit like the article you wrote on designing databases? While I agree with all the things you've stated, entire books have been written...
--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)

February 28, 2011 at 7:36 am

#1292315
RE: Help needed to decode comma delimited string and insert into tables

Thanks, Paul.
I agree... in particular, I saw that 70% sort on the second use of the Tally Table and believe it would go away if we simply wrote the results...
--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)

February 28, 2011 at 6:55 am

#1292280
RE: How to solve this 2 query

Craig Farrell (2/27/2011)
Sorry for the delay, I was fiddling with the code you provided Jeff, trying to see what I'd not been paying attention to. I've known about 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)

February 28, 2011 at 6:48 am

#1292277
RE: Key Word Searches

I was going to post that the result table and the related methods for this code article are nearly identical to what full-text-search (FTS) does but I see that folks...
--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)

February 28, 2011 at 6:34 am

#1292269
RE: Key Word Searches

AndrewJacksonZA (2/28/2011)
Hi
Please include a link to where Jeff Moden posted his function.
This search turned up this result.
Is that where you got the function from?
Thanks
Andrew
That's likely it. I've only posted...
--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)

February 28, 2011 at 6:19 am

#1292262
RE: Help needed to decode comma delimited string and insert into tables

Jeff Moden (2/28/2011)
SQLkiwi (2/28/2011)
A couple of tweaks to Jeff's code, mostly for correctness
I was in a bit of a hurry... what tweaks did you make?
Never mind. I see. ...
--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)

February 28, 2011 at 5:54 am

#1292250
RE: Help needed to decode comma delimited string and insert into tables

SQLkiwi (2/28/2011)
A couple of tweaks to Jeff's code, mostly for correctness
I was in a bit of a hurry... what tweaks did you make?
--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)

February 28, 2011 at 5:51 am

#1292247

Viewing 15 posts - 34,861 through 34,875 (of 59,099 total)