Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,891 through 52,905 (of 59,098 total)

RE: help-how to generate date backward from end to start

Thanks, Matt... you just saved me from having to breakout the Tally table "porkchops"! 😛
--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 16, 2008 at 5:00 pm

#769014
RE: Splitting Data Files

Tobi White (1/11/2008)
Thank you for your reply, but it really didn't have anything to do with my question. I really just want information related to my question about splitting files...
--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 16, 2008 at 4:58 pm

#769013
RE: Splitting Data Files

TheSQLGuru (1/11/2008)
1) It has been my experience that queries are almost NEVER as optimized as my clients think they are.
Spot on, Kevin...
--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 16, 2008 at 4:41 pm

#769009
RE: New Company, new DBA Tools budget, can you recommend any?

I consider myself to be one of the best around at sql server perf tuning and this product will take me to the next level due to some of 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)

January 16, 2008 at 4:34 pm

#769007
RE: Performance of Scripts in SQL Server 2000

You from Michigan, Kevin?
--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 16, 2008 at 4:32 pm

#769006
RE: Some are just awful...

Heh... understood on the scheduling thing... not a predictable "tide".
--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 16, 2008 at 4:30 pm

#769005
RE: LTRIM linked field

Heh! Similar effect! Gets their attention and it's fun to watch! :hehe:
--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 16, 2008 at 8:13 am

#768698
RE: Performance of Scripts in SQL Server 2000

Shaun McGuile (1/16/2008)
Current petrol prices here are abou $7.73 per gallon(US)!!!!!
:crying:$6.18 of that is tax!!!!!:crying:
--Shaun
Dang! You got Grandholm for a Governor, too? 😛 They should leave out gasoline...
--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 16, 2008 at 8:12 am

#768693
RE: Not able to locate stored proc. but it is running in job step

Haven't tried it, Matt, but is that true even when you're logged in as a System Admin?
--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 16, 2008 at 8:04 am

#768686
RE: LTRIM linked field

Heh... (laughing out loud, now)... do you think it matters when you get hit in the kisser by a 90 mile an hour porkchop? 😀 😛 😉 :hehe:
--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 16, 2008 at 8:01 am

#768680
RE: Performance of Scripts in SQL Server 2000

Shaun McGuile (1/16/2008)
Jeff: Would those be USA gallons then? (English gallons are bigger!) 😉
--Shaun
Heh... only if I forget to take the brick out of my coffee pot from the water...
--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 16, 2008 at 7:57 am

#768672
RE: Query for work shift differential

Heh... understood and thanks...
Becareful, though, Sam... one of the things that an Execution Plan will do, is "lie"... frequently, it can't "see" past the first row of the correlated sub-query...
--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 16, 2008 at 7:49 am

#768665
RE: Performance of Scripts in SQL Server 2000

Heh... spot on, Matt... Just like you did, I load what I call a "discovery load". The only difference is that I don't even take the time to change...
--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 16, 2008 at 7:40 am

#768657
RE: SQL - Derived Tables

jldsql (1/16/2008)
Microsoft documentation suggest that both derived tables and temporary table will first use memory cache if available.
Jim
Jim... First, I absolutely agree with what you said... But, I also...
--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 16, 2008 at 7:24 am

#768640
RE: Performance of Scripts in SQL Server 2000

Shaun McGuile (1/16/2008)
Sorry - had not read all of the posts before posting!:rolleyes:
--Shaun
Heh! Man, I had to laugh out loud! I've done that many times myself... it's normally...
--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 16, 2008 at 7:15 am

#768635

Viewing 15 posts - 52,891 through 52,905 (of 59,098 total)