Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,096 through 43,110 (of 59,102 total)

RE: SQL Split query

Heh... dang it... I had the right thread after all. That code above is slow. Where all the other methods take something less than 16 ms to split...
--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 6, 2009 at 9:02 pm

#1020834
RE: SQL Split query

Sorry... wrong thread.
--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 6, 2009 at 8:50 pm

#1020830
RE: SQL brian teaser...

Digs (7/5/2009)
I havent built it yet. Because what comes first the chicken or the egg,...
By the way... the answer to that question is the "egg" because a chicken can only...
--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 6, 2009 at 8:30 pm

#1020823
RE: SQL brian teaser...

Where'd Digs go? He owes us a post with his solution...
--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 6, 2009 at 8:26 pm

#1020821
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

wesigler (7/6/2009)
Jeff, I am a little confused by your last two posts. The Alternate IDs start at 800000000 and go to 899999999. I don't see how you can...
--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 6, 2009 at 8:24 pm

#1020819
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

There may be even a better way to avoid deadlocks on this. Combine the Insert with the Select... I believe you'd still need the TABLOCKX because you're needing 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 6, 2009 at 8:12 pm

#1020817
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

smunson (7/6/2009)
I'd agree but for the "human factor". Often, people have to deal with these numbers regularly, and a lack of "organization" of those numbers can 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)

July 6, 2009 at 8:06 pm

#1020814
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

smunson (7/6/2009)
Here's the BOL entry on SET TRANSACTION ISOLATION LEVEL:
"SERIALIZABLE
Specifies the following:
Statements cannot read data that has been modified but not yet committed by other transactions.
No other transactions can modify...
--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 6, 2009 at 7:52 pm

#1020809
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

smunson (7/6/2009)
Jeff Moden: I'd really appreciate your input on this...
It might not be what you expect... my input is that in this modern day of computers and other new fangled...
--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 6, 2009 at 7:44 pm

#1020806
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

wesigler (7/6/2009)
My approach is to come up with a couple of options and then look at the pros and cons of each.
Then, my approach would be to avoid all deadlocks...
--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 6, 2009 at 7:34 pm

#1020803
RE: SQL Split query

sanjeev40084 (7/6/2009)
see if this works:
http://sqlservercode.blogspot.com/2005/09/split-comma-delimited-string-fast.html
Heh... that blog contains the same method we've already talked about in this thread.... except it's usually just called a "Numbers" or "Tally" table instead 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)

July 6, 2009 at 3:12 pm

#1020689
RE: CHARINDEX in reverse

Sergiy (7/5/2009)
Jeff Moden (7/2/2009) Andrew already did exactly what I would do...
I would not.
There was a member of Led Zeppelin, John Paul Jones.
Would not be happy seeing his name...
--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 6, 2009 at 2:54 pm

#1020668
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

I'm still wondering about that primary key.... What happens if a company needs more numbers? Maybe it's in one of the previous posts. Haven't had time to study...
--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 6, 2009 at 2:46 pm

#1020661
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

wesigler (7/6/2009)
Yes those 3 records are the starting conditions. The example scenario would be a user enters a RangeID of 'D' and the number of Alternating ID's they want...
--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 6, 2009 at 8:25 am

#1020418
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

Heh... it does help but there's still one piece of info missing.... so, lemme ask the same question as before...
My apologies for being thick... just trying to figure this out...
--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 6, 2009 at 6:22 am

#1020309

Viewing 15 posts - 43,096 through 43,110 (of 59,102 total)