Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,086 through 35,100 (of 59,102 total)

RE: ##Tables in concurrent environment

Ok... the following function will pretty much blow the doors off of other splitter functions including some of my old ones. I'll be using this new function in 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 14, 2011 at 12:35 am

#1286309
RE: ##Tables in concurrent environment

Yeah... that's the function I was thinking it was. It's going to be really slow because of the While Loop. And, yeah, I know... you don't have 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 14, 2011 at 12:18 am

#1286304
RE: How many types of integer primary keys we can give?

ramana 45417 (2/13/2011)
How many types of integer primary keys we can give?
Thanks,
Rams
This will sound strange but the answer is... "All of them". Every integer type can be used 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)

February 14, 2011 at 12:13 am

#1286302
RE: loop in function

L09041975 (2/13/2011)
Is it possible to write a loop in a function? I'm getting the following error:
"Cannot access temporary tables from within a function"
Is there a work around? :crazy:
My...
--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 14, 2011 at 12:11 am

#1286301
RE: Tuning on parallel processing

sql_butterfly (2/13/2011)
I checked all almost all of the things. Everything looks fine to me. However there is one update which affects around one thousand rows (on an average) on 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 13, 2011 at 11:58 pm

#1286297
RE: Are the posted questions getting worse?

Craig Farrell (2/13/2011)
Koen Verbeeck (2/13/2011)
You are certainly right. I'm afraid I didn't make myself clear with my statement.
The developer shouldn't be the only one who is testing his code. Unfortunately...
--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 13, 2011 at 11:55 pm

#1286295
RE: ##Tables in concurrent environment

Anamika (2/13/2011)
On the basis of the value is not null I'm adding those in to where conditions. while doing this i want to find the IDs from a comma separated...
--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 13, 2011 at 11:46 pm

#1286293
RE: Proc runs slow only during business hours?

sqldba_icon (2/13/2011)
I have a proc which takes 2secs to finish when there is minimal load on the server( night times) and takes 30 secs during day times. Mentioned below are...
--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 13, 2011 at 11:41 pm

#1286292
RE: CTE Query Parent/Child Struggles

Ack! I just reread your requirements. The part about multiple-parents for a given category ID isn't something easily resolved. Are you sure about the "multiple-parents" thing?
--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 13, 2011 at 11:37 pm

#1286287
RE: CTE Query Parent/Child Struggles

malik.robinson (2/13/2011)
Thanks for the warm welcome on my first post in this forum. I tried to be brief purely to avoid a long monolithic post.
I will keep trying 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 13, 2011 at 11:35 pm

#1286286
RE: Datewise Cummulative total for particular customer

Now be careful folks. You've both built Triangular Joins which can be literally millions of times worse than a cursor. If you don't want to use the "Quirky...
--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 13, 2011 at 11:24 pm

#1286282
RE: parse XML using sql

mister.magoo (2/13/2011)
Jeff, you gotta learn some XML !
Ok... how about an article on it? 😀
In the meantime, care to explain the code you wrote so an XML dummy like me...
--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 13, 2011 at 11:16 pm

#1286278
RE: PURPOSE OF TEMPORARY TABLES

SQLCHILD (2/13/2011)
Dear Jeff Sir,
Thanks a lot for your reply, i also wanted to know that how do temporary tables hold the result set of a stored procedure. i have read...
--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 13, 2011 at 11:07 pm

#1286276
RE: Query - Array

That's likely going to be quite slow because of the While Loop.
Your function will spilt single City.But i have to split some array of City
Why? :blink:
--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 13, 2011 at 12:57 pm

#1286186
RE: newbie - need help tweaking this script to make data in 1 db column parsed and extracted to 3 columns

One of the better ways to do this would be to do a BULK INSERT using "|" as the delimiter.
That, notwithstanding, I agree that a "Tally Table" based splitter function...
--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 13, 2011 at 12:40 pm

#1286183

Viewing 15 posts - 35,086 through 35,100 (of 59,102 total)