Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,461 through 35,475 (of 59,099 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/7/2011)
I'm sure Jeff will like this: http://www.pcworld.com/article/215741/microsofts_hotmail_fail_a_bad_sign.html
It's most likely a people/process failure more than SQL Server, but it does give ammunition to the idea 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)

January 7, 2011 at 6:19 pm

#1271001
RE: How to improve performance using SCD transformation

lijnenjoost (1/7/2011)
Ps thread age doesn't realy matter, as long it's usefull for the next one that is reading the post.
I absolutely agree with 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)

January 7, 2011 at 6:05 pm

#1270999
RE: Are the posted questions getting worse?

Jeff Moden (1/7/2011)
SQLkiwi (1/6/2011)
Jeff Moden (1/5/2011)
Personally, I'd prefer a NULL to be returned instead of an error...
Hmmm. That's an interesting question. I don't like the idea of NULL...
--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)

January 7, 2011 at 5:52 pm

#1270998
RE: Are the posted questions getting worse?

SQLkiwi (1/6/2011)
Jeff Moden (1/5/2011)
Personally, I'd prefer a NULL to be returned instead of an error...
Hmmm. That's an interesting question. I don't like the idea of NULL being overworked...
--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)

January 7, 2011 at 5:47 pm

#1270996
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

jswong05 (1/7/2011)
Hi, mirzafahad1409,
To parse sophisticated text data (with multiple rules), you should use high level language like C# (it is easy to write and debug), you could embed C# into...
--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)

January 7, 2011 at 5:35 pm

#1270994
RE: Introduction to Indexes

Sorry I didn't comment on this series of articles before, Gail. They're absolutely awesome and should be required reading for everyone from SQL Neophyte to Ninja. Very well...
--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)

January 7, 2011 at 4:41 pm

#1270984
RE: Table variable vs Temp table for approx 50000 records?

CELKO (1/7/2011)
Neither approach is good. Your mindset is still thinking with magnetic tape scratch files. Read data to a tape, then hang the tape and run the next program in...
--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)

January 7, 2011 at 4:13 pm

#1270967
RE: How to break string and insert each substring

Heh... oh my... just on a "what if" whim, I just created a new splitter using the Tally Table. It's 3 times faster the DelimitedSplit8K proc and has flatter...
--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)

January 7, 2011 at 2:46 am

#1270510
RE: How to break string and insert each substring

Houston, we have a different winner. The test table is identical as before except I constrained my test data generator to only 8 values per row. The Tally...
--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)

January 7, 2011 at 12:05 am

#1270445
RE: How to break string and insert each substring

Houston, we have a winner.... and it's not the Tally Table. The recursive CTE splitter is about twice as fast as the DelimitedSplit8k function on 1000 rows of 800...
--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)

January 6, 2011 at 11:53 pm

#1270439
RE: How to break string and insert each substring

LutzM (8/12/2010)
Please search this site for "DelimitedString8K" to find a really fast T-SQL function or have a look at the TallyTable article referenced in my signature.
There is an even fast...
--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)

January 6, 2011 at 11:22 pm

#1270431
RE: How to break string and insert each substring

Post withdrawn. I was speaking out of school and haven't actually tested against that particular split 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)

January 6, 2011 at 11:21 pm

#1270430
RE: How to split a single record in multiple records based on a datetime period?

Rehman Rafique (1/6/2011)
ok ill check it out.....
with "runs fine" i meant dat it provides da required result, i wasnt pointing towards it's execution time etc...
Understood and appreciated. Since 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)

January 6, 2011 at 11:08 pm

#1270426
RE: Doubt clarification

deepikamm (1/6/2011)
what is the conclusion guys?
About what? Your original question (which has been very well explained on this thread) or whether or not you can guarantee an ordered result...
--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)

January 6, 2011 at 10:50 pm

#1270420
RE: Trigger regarding

Just a friendly suggestion... you should never have a trigger send an email because if the email system is down, the trigger may wait indefinitely for it to come back...
--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)

January 6, 2011 at 9:56 pm

#1270406

Viewing 15 posts - 35,461 through 35,475 (of 59,099 total)