Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,766 through 54,780 (of 59,072 total)

RE: Limit Resources to UGLY query

Heh... no... not real painful 😀 Let me explain...
Let's say you have a table that looks like this...
--===== Create and populate a 1,000,000 row test 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)

October 2, 2007 at 12:17 am

#738020
RE: More newbie system table help

Heh... those are fun but I like the real-life questions that teach why or why not to do something... for example...
1. How many internal rows will be generated by...
--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)

October 1, 2007 at 10:27 pm

#738011
RE: More newbie system table help

GilaMonster (9/30/2007)
Jeff Moden (9/29/2007)
I can't tell you the number of folks I've interviewed who have Masters or PHDs in mathematics that couldn't tell me what bit will be set by...
--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)

October 1, 2007 at 10:12 pm

#738009
RE: can we modify system tables in SQL Server 2000?

What if I just want to delete orphaned users in sysusers and i enabled the "allow updates" then disabled it after deleting the orphaned user?Am I doing a very risky...
--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)

October 1, 2007 at 8:58 pm

#737974
RE: Data in Use or Data in memory

Won't work with 2005's encryption routines. They're non-deterministic. Encrypt and compare will get you no matches.
Didn't know that. Wow... the boy's in Redmond pretty much blew it there...
--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)

October 1, 2007 at 8:41 pm

#737971
RE: deduping query optimization

really old server, 512MB ram and 2 300Mhz processors (yes that's an M not a G)
I'm thinking that you've squeezed just about all the speed you're gonna get out 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)

October 1, 2007 at 8:33 pm

#737970
RE: Limit Resources to UGLY query

Bob Fazio (10/1/2007)
Formatting in this new site is less than adequate.
I absolutely agree!
Insert of 3.3m rows.
Best run (no index). 270 - seconds
worst run (with index) 283...
--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)

October 1, 2007 at 8:21 pm

#737969
RE: Limit Resources to UGLY query

Kurt W. Zimmerman (10/1/2007)
I've had to deal with very long running updates and processor intensive stored procedures that has been able to take my dual quad core w/ 8gb 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)

October 1, 2007 at 7:01 pm

#737950
RE: Is this workable

... and what about the EndDates that are 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)

October 1, 2007 at 6:38 pm

#737946
RE: Remove Decimals Without Rounding

Post the entire test harness so we can do the same test, Tom 😉
--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)

October 1, 2007 at 6:33 pm

#737945
RE: Remove Decimals Without Rounding

Oh... and do be aware that STR uses FLOAT for it's main operand... 😉
--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 30, 2007 at 9:46 am

#737527
RE: Remove Decimals Without Rounding

Ninja's_RGR'us (9/29/2007)
So Jeff, how do you solve this version of the problem?
Set @i = 0.034
PRINT REPLACE(@i,'.','')
--003400 OR 34?
Set @i = 0.0304
PRINT REPLACE(@i,'.','')
--003040 OR 304?
I assume you're talking about adding leading...
--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 30, 2007 at 9:45 am

#737525
RE: Update Trigger Updates Correct Record In Another Table

nigelrivett (9/29/2007)
There is a case for auditing inserts - it depends on what you are using the audit trail for.
If you want to report on full history of the data...
--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 30, 2007 at 9:09 am

#737522
RE: Update Trigger Updates Correct Record In Another Table

Ninja's_RGR'us (9/29/2007)
Sorry Jeff, but I only audit full rows, not columns sot he 5:1 ratio doesn't apply.
2 what do you do about the rule that says that auditing data should...
--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 30, 2007 at 8:40 am

#737516
RE: 500,000th member mark

Outstanding job Steve, Warren, and Andy!!! Yeah, I know... Warren and Andy are on the "sidelines" now, but that group of 3 started this! Nicely done!
--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 30, 2007 at 8:19 am

#737514

Viewing 15 posts - 54,766 through 54,780 (of 59,072 total)