Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,456 through 37,470 (of 59,098 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

LutzM (8/1/2010)
A few things to notice:
You should start a new thread in the SSIS forum if you're looking for a SSIS solution.
Also, please read and follow the advice given in...
--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)

August 1, 2010 at 12:08 pm

#1200773
RE: Deterministic UDF slower than Non-Deterministic?

dant12 (7/31/2010)
wow Jeff, thats a nice load of replaces lol. ill test it first thing on monday and post the results against the old T-SQL and the CLR functions. 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)

August 1, 2010 at 12:00 pm

#1200772
RE: Calendar Tables

Looking at the "Tally" table code that someone else wrote, I can certainly see why it's so slow. No chance of the clustered index being used there!
Thanks for 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)

July 31, 2010 at 8:27 pm

#1200716
RE: The Rich Rewards of Tuning SQL

I know this is an old post but I had to say "Hear Here!" to it. Great post Tony. Phil is absolutely correct about how even the worst...
--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)

July 31, 2010 at 7:56 pm

#1200714
RE: Deterministic UDF slower than Non-Deterministic?

Try this, Thiango... it may even give your .Net code a run for it's money. It's 32 to 64 times faster than the T-SQL Function you wrote. If...
--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)

July 31, 2010 at 1:53 pm

#1200683
RE: Unzip files from Stored Procedure using 7zip

Agreed... especially on the environment thing. We had the joy of doing cross-domain across servers through a fire wall on SOX compliant systems on one side and "open" systems...
--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)

July 30, 2010 at 9:08 am

#1200422
RE: how to update millions of records quickly........

Bhuvnesh (7/30/2010)
Jeff Moden (7/29/2010)
Bhuvnesh (7/28/2010)
Jeff Moden (7/28/2010)
you'd need a loop for that.
or may be batch approach can make work smoother
The loop would control "batches". That being said, what...
--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)

July 30, 2010 at 9:03 am

#1200419
RE: Fall 2010 Speaking Opportunities

Steve Jones - Editor (7/30/2010)
The Colorado event is in South Denver, #52
http://www.sqlsaturday.com/52/eventhome.aspx
Thanks, Steve... doesn't look like there's any shortage of speakers for that one. 🙂
--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)

July 30, 2010 at 9:02 am

#1200416
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Heh... I guess it depends on what one's definition of "set based" is. Either way, I sure appreciate your 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)

July 30, 2010 at 8:50 am

#1200403
RE: Fall 2010 Speaking Opportunities

You spoke of a Denver event and I don't see that on the list anywhere.
--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)

July 29, 2010 at 11:39 pm

#1200133
RE: Unzip files from Stored Procedure using 7zip

You should submit this as an article, Jeff.
--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)

July 29, 2010 at 11:12 pm

#1200125
RE: Deterministic UDF slower than Non-Deterministic?

Can't help in the CLR area but if you demonstrate the string manipulation you're trying to do in a CLR, I can try to beat it in T-SQL. 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)

July 29, 2010 at 11:07 pm

#1200123
RE: CrossTab or Pivot

You need some tools for that. Fortunately, you can find them all in one place. Please see the following link...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

July 29, 2010 at 11:04 pm

#1200122
RE: Toubles With User defined split function and while loop

tmlawlo (7/29/2010)
Thank you both very much! Last night i got it to work with the loop, but like you said it was much much slower. This worked perfectly. I...
--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)

July 29, 2010 at 10:43 pm

#1200116
RE: Sum Daily Data Into Weekly Data

Novicejatt (7/26/2010)
Hi
This is how my Table Looks like with 3 weeks of data on daily basis for two CP Codes:
I have data for 30 such Codes.
CP CodeDateTotal Pageviews
510142010-06-272623221
510142010-06-281985718
510142010-06-291815712
510142010-06-302126104
510142010-07-011702672
510142010-07-021666468
510142010-07-032019123
510142010-07-041783373
510142010-07-051890672
510142010-07-062424314
510142010-07-072197743
510142010-07-082097884
510142010-07-092029226
510142010-07-101989296
510142010-07-111833109
510142010-07-122398424
510142010-07-132365550
510142010-07-141810926
510142010-07-152483211
510142010-07-162327007
510142010-07-171758154
530372010-06-276059
530372010-06-286310
530372010-06-296394
530372010-06-304627
530372010-07-013402
530372010-07-023115
530372010-07-033032
530372010-07-042995
530372010-07-053122
530372010-07-073040
530372010-07-083638
530372010-07-093767
530372010-07-103745
530372010-07-113576
530372010-07-123860
530372010-07-133123
530372010-07-143458
530372010-07-153516
530372010-07-163233
530372010-07-173176
After converting this...
--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)

July 29, 2010 at 10:38 pm

#1200114

Viewing 15 posts - 37,456 through 37,470 (of 59,098 total)