Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,786 through 49,800 (of 59,102 total)

RE: Table var maximum row number

Yeah... I know... Microsoft is pretty much non commital when it comes to stuff like that because the amount of memory and the I/O system will make it vary quite...
--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)

June 23, 2008 at 9:01 am

#832768
RE: sa removal

Heh... Embarassingly simple. Thanks Stacey.
Mobasha... that's gotta be as good as deleting SA... still, your users are going to know that you can give SA privs to any login......
--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)

June 23, 2008 at 8:54 am

#832759
RE: Pivot... I don't think it's possible...

By the way, Peter... you machine is about twice as fast as more poor ol' 6 year old single processor 1.8 GHz box... what are you using?
--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)

June 23, 2008 at 8:48 am

#832753
RE: Pivot... I don't think it's possible...

That really puts the stuff on the Pivot method, huh? 🙂
--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)

June 23, 2008 at 8:46 am

#832749
RE: Pivot... I don't think it's possible...

Same conclusion I came to... Thanks Peter. It also means that it could be done using a CTE with the same performance if the data is pre-aggregated like you...
--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)

June 23, 2008 at 8:26 am

#832733
RE: Pivot... I don't think it's possible...

It's funny how changing the CTE into a derived table improved performance like that. I'll dig into that and see why.
--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)

June 23, 2008 at 8:06 am

#832703
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Ian Crandell (6/23/2008)
Jeff Moden (6/23/2008)[hrIt was designed as a replacement for OTTO Fuel II which is what the Navy is currently using. OTTO Fuel II has a couple 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)

June 23, 2008 at 8:01 am

#832692
RE: sa removal

gregers65 (6/23/2008)
My approach to being a DBA is that I am here to protect the companies data. These to me means that no one ever uses the sa account...
--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)

June 23, 2008 at 7:53 am

#832682
RE: sa removal

Manoj (6/3/2008)
You Should not be able to Delete SA login from the server, But you could be able to DISABLE the SA account from the server.
Cool... how would you go...
--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)

June 23, 2008 at 7:51 am

#832676
RE: Pivot... I don't think it's possible...

Heh... I wonder if the use of UNPIVOT constitutes cheating too much in this case?
Still, some awesome code... Thanks Jeff W and Peter. I really didn't think it could...
--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)

June 23, 2008 at 7:49 am

#832674
RE: Pivot... I don't think it's possible...

Haven't checked it for accuracy, but that's more like it... getting real close to the Cross Tab version of the code for performance. Thanks, Peter.
--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)

June 23, 2008 at 7:44 am

#832666
RE: Forum Etiquette: How to post data/code on a forum to get the best help

jcrawf02 (6/23/2008)
Nothing is new under the sun, Jeff. Experts are expert by being able to concisely compile information and explain something, not necessarily make it up.
I'd buy 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)

June 23, 2008 at 7:38 am

#832660
RE: Pivot... I don't think it's possible...

Peso (6/23/2008)
You didn't dare to post the question on "the other forum"? 😀
Nah... I knew great minds like yours would eventually show up... Besides... I didn't want to get one...
--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)

June 23, 2008 at 6:49 am

#832613
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Anirban Paul (6/23/2008)
Jeff I believe you are tired of getting words like 'Excellent', 'Awesome', 'Great', etc for your. So I will suggest you this time one thing. Start writing books...
--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)

June 23, 2008 at 6:00 am

#832591
RE: Pivot... I don't think it's possible...

Jeffrey Williams (6/22/2008)
Okay, it can be done in a single pivot - but I had to cheat and performance will probably suffer. As far as I have been able...
--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)

June 23, 2008 at 5:42 am

#832578

Viewing 15 posts - 49,786 through 49,800 (of 59,102 total)