Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,846 through 46,860 (of 59,101 total)

RE: Processing a non-locked row update from within a TRANSACTION

John Barry (12/2/2008)
Jeff,
Thanks - I have used that syntax as well - it's cool. And I agree if I move the Nextval outside the transaction it would solve 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)

December 2, 2008 at 10:46 pm

#906651
RE: UPDATE SET =NULL running over an hour

One more thing... you're updating the same columns that you have in your criteria. Sometimes, and it's again unpredictable, that will cause a recompile for every row updated. ...
--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)

December 2, 2008 at 10:42 pm

#906650
RE: UPDATE SET =NULL running over an hour

P.S. You may want to stop that single Update you're running right now. It may take several hours to rollback or it might rollback quicker. But even...
--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)

December 2, 2008 at 10:38 pm

#906649
RE: UPDATE SET =NULL running over an hour

To add to what Lynn stated.... there are two reasons you need to break up such a large update... the first is the LOG file. Even with the SIMPLE...
--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)

December 2, 2008 at 10:36 pm

#906648
RE: How to convert hhmm into datetime 13:30:00 T-SQL?

That's not really a DateTime datatype you asked for or it would have a date with it like this...
DECLARE @Time CHAR(4)
SET @Time = '1330'
SELECT CAST(STUFF(@Time,3,0,':')...
--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)

December 2, 2008 at 7:40 pm

#906613
RE: Processing a non-locked row update from within a TRANSACTION

John Barry (12/2/2008)
I do not want to use an identity field in the tables to get a sequence number. This would present many additional challenges that are worse than...
--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)

December 2, 2008 at 7:27 pm

#906609
RE: Determine if parameter is passed or DEFAULT

Heh... if you need to borrow some 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)

December 2, 2008 at 7:12 pm

#906604
RE: Help with Data transformation

Bob Hovious (12/2/2008)
Seeing no way to improve on the CASE logic in the proposed solution
Heh... "Must look eye..." 😛
SET STATISTICS TIME ON
SELECT ID,
...
--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)

December 2, 2008 at 6:45 pm

#906600
RE: Import Excel File to SQL Database

Steps 1 through 3 can can be very easily accomplished... open the file in Excel. Step 4 is a simple "Save As". You don't need to even go near...
--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)

December 2, 2008 at 6:25 pm

#906596
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Same thing, though... use MAX instead of SUM...
--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)

December 2, 2008 at 6:17 pm

#906595
RE: Getting lost in Group, Top for Select

That'll work... just be advised that it does contain a "partitioned" triangular join and if there're a large number of Pr_ID's for each agent, there will be a big time...
--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)

December 2, 2008 at 6:12 pm

#906593
RE: Database testing

Yep... that'll work, too! Haven't tested it for performance, though.
--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)

December 2, 2008 at 6:07 pm

#906592
RE: Data between set delimited fields

1) Would I need to do a union all necessarily? Is it just considered good housekeeping to do it or does it serve a distinct purpose within this statement?
Heh... First,...
--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)

December 2, 2008 at 6:06 pm

#906591
RE: The Full Potential of SQL 2000

I know lot's of good folks that like it, but I don't care for Oracle much, either. Many will disagree with me, but I find it too limiting.
--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)

December 2, 2008 at 5:57 pm

#906590
RE: Recommended path for advanced training?

jeffkretz (12/2/2008)
Gaby Abed (12/2/2008)[hr
Agreed...I'm working on my MCTS for SQL 2005 but I plan to emphasize my experience first on the resumes and keep the certification at the end, probably...
--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)

December 2, 2008 at 2:04 pm

#906497

Viewing 15 posts - 46,846 through 46,860 (of 59,101 total)