Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,896 through 41,910 (of 59,102 total)

RE: Please review BCNF (Put things where it belongs)

David Portas (9/19/2009)
Jeff Moden (9/17/2009)
the surrogate key is the check account number
An account number is not a surrogate key. It's a business key, i.e. it identifies something in the business...
--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)

September 19, 2009 at 2:03 pm

#1055982
RE: Help writing a SQL

Garadin (9/18/2009)
...but it still doesn't even come close to the speed of the update. Even selecting that entire 2 million row dataset into a temp table and running 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)

September 18, 2009 at 9:32 pm

#1055911
RE: Help writing a SQL

Garadin (9/18/2009)
Jeff Moden (9/18/2009)
Turn off the execution plan and see what you get.
Without the execution plan, 12 seconds for quirky with MAXDOP 1, 151 for the RCTE. I ran...
--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)

September 18, 2009 at 9:29 pm

#1055910
RE: Qry Performance

If nothing else, the NOT LIKE will likely force a scan.
--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)

September 18, 2009 at 12:25 pm

#1055796
RE: Parse data colunm into 3 columns

vmon (9/18/2009)
Thanks for replying Jeff. I am not sure how to go about this. The order of data will be constant. The tags will be constant 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)

September 18, 2009 at 12:20 pm

#1055792
RE: Help writing a SQL

Turn off the execution plan and see what you get.
--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)

September 18, 2009 at 12:18 pm

#1055791
RE: Are the posted questions getting worse?

Paul White (9/18/2009)
¿???p??? o? p??? si?? pui? lli? ????dsi??? u?????ou ??? ?o?? ?ldo?d ?i ??puo? i
Heh... I guess it literally depends on how you look at it. 😛
I've gotta know......
--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)

September 18, 2009 at 9:35 am

#1055690
RE: Help writing a SQL

That works but be careful... recursive CTE's are as slow as a While Loop in most cases and are actually a form of RBAR.
--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)

September 18, 2009 at 6:54 am

#1055557
RE: Pulling Filename from Windows directory into table

erouse (9/18/2009)
Attached file shows results 250 to 260. Note that after row 255 all the file details are the same yet the row number changes.
That looks like a bug 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)

September 18, 2009 at 6:50 am

#1055554
RE: How To Efficiently Index Using a VARCHAR Column?

Matt Miller (#4) (9/17/2009)
With a combo like that - be sure to say hi to the Pink Elephants that come by:)
Ohhhhh... THAT's what those 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)

September 18, 2009 at 6:40 am

#1055547
RE: Parse data colunm into 3 columns

Thanks for the table statement. This will be easy and, no, it doesn't matter what it looks like, we don't need to go through the rigors of XML 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)

September 18, 2009 at 6:36 am

#1055546
RE: Single table format

DBCC UPDATEUSAGE does nothing more than update the sysIndexes table with the latest information. It may take a while to run but it will cause no harm.
As for 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)

September 18, 2009 at 6:31 am

#1055543
RE: Help writing a SQL

Heh... I'm actually worse... I just don't let people put CLR's in my systems. It's not that I'm against them... it's that they're not worth having to go through...
--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)

September 17, 2009 at 10:56 pm

#1055381
RE: how to write the query with sub sub query

rajeshhalyal (9/17/2009)
I have a field in table which contains comma delimited id values for each related record.
Now I want to find the records from main table with Ids not 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)

September 17, 2009 at 10:48 pm

#1055378
RE: how to write the query with sub sub query

lmu92 (9/17/2009)
This link should help you further.
Heh... not so funny, Lutz 😉 ... the very first article that shows up contains both a UDF and a While Loop. ...
--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)

September 17, 2009 at 10:39 pm

#1055376

Viewing 15 posts - 41,896 through 41,910 (of 59,102 total)