Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,636 through 52,650 (of 59,072 total)

RE: Creating a trigger to run inside a SP

You said that you wanted to pass parameters to the stored procedure in the trigger. That smacks of RBAR and single row processing which is a form of "Death...
--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)

February 8, 2008 at 5:05 pm

#776660
RE: Generating Missing Dates and Numbers

Then, you need to post the exact code you're getting the error with and the exact error... because the code I posted gives no such error on my machine. ...
--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)

February 8, 2008 at 4:08 pm

#776645
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Radovan Jablonovsky (2/8/2008)
Hi,
If it is possible in your production environment to dynamically change number of processors, then it is OK. In our environment it is more conservative, therefore I am...
--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)

February 8, 2008 at 4:04 pm

#776644
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

I absolutely agree, Matt... same thing goes with the SUM() OVER... they (MS) don't allow the necessary ORDER BY to calculate a running total using SUM() OVER like they do...
--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)

February 8, 2008 at 7:10 am

#776404
RE: Generating Missing Dates and Numbers

Which error? The one about conversion from char to date producing an out of range value? And, even if you fix that, you'll still end up with a...
--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)

February 8, 2008 at 7:06 am

#776401
RE: Is there a way to overcome the limitation of 8k per record in a table?

VARCHAR(MAX)
--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)

February 7, 2008 at 8:26 pm

#776267
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Philippe Cand (2/6/2008)
Hello,
This article is getting unprecedented proportions.
How could we have MS SQL engine development database guys participating in the discussion If they are not yet already doing so...
--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)

February 7, 2008 at 8:00 pm

#776261
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Radovan Jablonovsky (2/7/2008)
Replay for Jeff,
Server was setup to use 2 CPU for parallelism and query execution plan showed parallel execution was used in sorting index. See attached pictures.
Sincerely,
Radovan Jablonovsky
Amazing... I've...
--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)

February 7, 2008 at 7:57 pm

#776260
RE: splitting a string using delimeter

Adam Haines (2/7/2008)
Good solution Jeff, simply amazing. 😉
Thanks, Adam :blush:
--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)

February 7, 2008 at 7:26 pm

#776250
RE: splitting a string using delimeter

Just a couple of suggestions, folks...
First, there is no need for a loop in the creation of a "Tally" or "Numbers" table. Second, to be truly effective and 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)

February 7, 2008 at 6:56 am

#775989
RE: Bulkinsert

Yes... the solution is posted above... the server must be logged into the domain as a user that can actually "see" the file path.
--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)

February 7, 2008 at 6:18 am

#775972
RE: Need to generate csv file 4m DB

First, mailing you the solution wouldn't do anyone else any good...
Second, take a look at BCP in Books Online... it's likely your best bet.
--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)

February 7, 2008 at 6:14 am

#775970
RE: Stripping out double quotes (") in bulk insert

Import 1 line and count the LEN difference between the line with delimiters and the line where the delimiters have been replaced with nothing and add 1 to that.
For fixed...
--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)

February 7, 2008 at 5:59 am

#775965
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Chirag (2/6/2008)
Hi Jeff
I have a doubt abt the index selection when i ran your code
in the article ' Running total.......'
I created the table dbo.JBMTest , added the clustered...
--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)

February 7, 2008 at 5:51 am

#775963
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Matt Miller (2/5/2008)
Jeff Moden (2/5/2008)
It IS a cool solution... Wasn't so good in the performance department on my machine, though... it took 29 minutes to do the million row example...
--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)

February 7, 2008 at 5:22 am

#775950

Viewing 15 posts - 52,636 through 52,650 (of 59,072 total)