Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,801 through 34,815 (of 59,099 total)

RE: T-SQL Cursor Puzzle

WayneS (3/4/2011)
Jeff Moden (3/4/2011)
Thank you very much for the feedback... but Lutz set the stage to avoid RBAR using some very high performance code. All I did was tweek...
--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)

March 5, 2011 at 9:33 am

#1294995
RE: Using Cross tab updates in SQL2008

pverma (3/4/2011)
Jeff
Thanks for the prompt reply.
But it seems u have misunderstood my post.
The "pipe" used in the post is just for structuring the data in a table format.
Kindly execute the...
--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)

March 5, 2011 at 9:27 am

#1294993
RE: How to sort using DateTime

LutzM (3/4/2011)
gemni7 (3/4/2011)
But again, there are at least three reasons Jeffs code is recommended for such scenarios: speed, performance and duration 😀
Heh... that's a nice thing to say, Lutz. ...
--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)

March 4, 2011 at 5:50 pm

#1294934
RE: How to sort using DateTime

gemni7 (3/4/2011)
Hi LutzM,
I have a question about Exclusive Table Lock. What would be SQL servers behavior if my application open connection to insert data into same table while exclusive table...
--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)

March 4, 2011 at 5:49 pm

#1294933
RE: Using an IN Operator as a Parameter in a Stored Procedure

Sean Lange (3/4/2011)
Gus, that may have just revolutionized how I handle those types of situations from this point on. I took your example and put together a quick proof of...
--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)

March 4, 2011 at 3:26 pm

#1294911
RE: 'Pretty-up' the code

aureolin (3/4/2011)
Remember: 50% of all doctors graduated in the bottom half of their class!
Oh! Now THERE's a scary thought, for sure.
--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)

March 4, 2011 at 11:40 am

#1294828
RE: Using an IN Operator as a Parameter in a Stored Procedure

Cool. Thanks, Gus. I'll give it a try and read up on it in BOL but simple examples like the one you provided go a very long way...
--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)

March 4, 2011 at 11:37 am

#1294827
RE: Using Cross tab updates in SQL2008

Substitute a "pipe" for the comma's in the following article...
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--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)

March 4, 2011 at 10:04 am

#1294780
RE: Using an IN Operator as a Parameter in a Stored Procedure

stewsterl 80804 (3/4/2011)
"change the parameter to a table variable" - Brilliant!!! 😀
Thanks!
If you get the chance, please, I'd love to see the code that you end up with for that....
--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)

March 4, 2011 at 9:48 am

#1294764
RE: T-SQL Cursor Puzzle

Thank you very much for the feedback... but Lutz set the stage to avoid RBAR using some very high performance code. All I did was tweek his code. 🙂
As...
--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)

March 4, 2011 at 9:35 am

#1294754
RE: T-SQL Cursor Puzzle

Send me an email, CC.
--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)

March 3, 2011 at 10:59 pm

#1294450
RE: SLA Contracts

Gosh. We should setup a poll. I wonder how many DBAs subscribe to the idea that it's ok to lose data on a production system... SLA or not......
--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)

March 3, 2011 at 10:38 pm

#1294447
RE: Can I copy tasks from one package and paste into another?

Heh... or just do it all in T-SQL stored procedures. :-D:-P;-)
--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)

March 3, 2011 at 10:17 pm

#1294446
RE: Parse City and State

You don't understand what I'm saying. There is no way to know if a word is a part of the city or part of the address for any of...
--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)

March 3, 2011 at 10:13 pm

#1294444
RE: T-SQL Cursor Puzzle

LutzM (3/3/2011)
Thank you! :blush:
What needs to go into the ORDER BY clause of ROW_NUMBER() is sort of unclear based on the data provided so far:
If there will ever be 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)

March 3, 2011 at 9:56 pm

#1294440

Viewing 15 posts - 34,801 through 34,815 (of 59,099 total)