Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,831 through 46,845 (of 59,101 total)

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

John Barry (12/3/2008)
Jeff,
So are you saying that instead of creating a row at a time in the live table, stamping each one with a sequence number as you insert it,...
--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 3, 2008 at 7:13 pm

#907291
RE: Convert Rows to columns so...

Yes... everything is possible... but what are you going to do if there are 40 rooms on the same floor?
--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 3, 2008 at 6:57 pm

#907282
RE: Visual Basic code to write the last time a Table was updated in a DB

umanpowered (12/3/2008)
rbarryyoung (11/3/2008)
As Jonathan said: "getdate()" needs to be the definition of the column's default value, and not the definition of the column itself.
Hi,
As a side question, do you know...
--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 3, 2008 at 6:52 pm

#907280
RE: Determine if parameter is passed or DEFAULT

David Leaver (12/3/2008)
Yikes - Dip, Dive, Duck and Dodge! Doesn't pay to leave the forums for a few hours.
Here's the scenario - I'm taking an existing procedure that historically...
--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 3, 2008 at 6:41 pm

#907279
RE: Determine if parameter is passed or DEFAULT

Trebuchet... the ultimate pork chop launcher... can launch the whole pig and makes statements followed by "When pigs fly" come absolutely true. 😛
--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 3, 2008 at 6:37 pm

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

I see a bunch of stuff in that code snippet that I think is working against you. Please post the real table creationtion statement for the table you're deleting...
--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 3, 2008 at 6:20 pm

#907275
RE: Recommended path for advanced training?

I solved a post, last night, using the SIGN function instead of CASE for a pretty good performance gain. It reminded me of what my original programming mentor taught...
--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 3, 2008 at 3:59 pm

#907228
RE: Help with Data transformation

ishaan99 (12/3/2008)
Thanks Guys i used the charindex without sign function to resolve this. Thanks for everybody;s input.
You bet... thanks for the feedback.
--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 3, 2008 at 3:50 pm

#907221
RE: Help with Data transformation

Bob Hovious (12/3/2008)
... and now I know there is a SIGN function... which of course returns just exactly what is needed for setting the "bits". Remind me never...
--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 3, 2008 at 3:49 pm

#907219
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

mlandry (12/3/2008)
Jeff,
Whoa, using SQL to do cross-tabs really is "old school" (circa mid-90's or before.) It just wasn't designed for this.
Do yourself a BIG favor and try Analysis Services....
--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 3, 2008 at 9:41 am

#906997
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

ggraber (12/3/2008)
Great article Jeff!
Do you think this will perform better than a dynamic pivot?
Thanks for the feedback and absolutely! 🙂
--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 3, 2008 at 8:25 am

#906914
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Thanks for the great feedback Anirban. Great to know that folks get things out of these articles. 🙂
--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 3, 2008 at 8:00 am

#906895
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Chirag (12/3/2008)
Another masterpiece.
Small typo -
You have a single quote missing at the end of the date for the code under OLD fashioned swap.
"SET @EndDate = '2008-01-15 "
Thanks...
--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 3, 2008 at 5:03 am

#906757
RE: Script to find the datafile size and logfile size?

Is this what you want?
--===== Declare local files
--Jeff Moden
DECLARE @DBID INT
DECLARE @DBName VARCHAR(30)
DECLARE @Text ...
--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:57 pm

#906655
RE: Convert Rows to columns so...

fausto usme (12/2/2008)
Hello People,
i need to do the next.
Why? What's the goal or business rule other than someone said they wanted it?
--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:52 pm

#906653

Viewing 15 posts - 46,831 through 46,845 (of 59,101 total)