Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,861 through 52,875 (of 59,072 total)

RE: Why deadlocks occuring when I have @@lock_timeout set to -1 (infinite wait) ???

Why are you getting deadlock timeout errors? Because when a deadlock occurs, there's always a victim...
There really way to much to explain about deadlocks here... you really need 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)

January 16, 2008 at 7:44 pm

#769038
RE: Splitting Data Files

The folks that gave those types of answers didn't help?
--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:32 pm

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

See?
--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:28 pm

#769036
RE: Billee-yons and Billee-yons of Gigabytes

Johan Kempe (1/16/2008)
Well that post was a lot of talk and nothing of interest.. just a notice of the obvious, disappointing read from an usually interesting writer.
Heh... it's an "editorial"......
--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:09 pm

#769015
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

Viewing 15 posts - 52,861 through 52,875 (of 59,072 total)