Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,301 through 36,315 (of 59,067 total)

RE: Calculating Moving Averages with T-SQL

First, my humble apologies for how long this has taken... I've been pretty busy.
Second, let's expand the test a bit. Let's say that we got a day's worth of...
--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)

October 21, 2010 at 6:22 pm

#1240665
RE: Best code for generating sequence numbers

ta.bu.shi.da.yu (10/21/2010)
Jeff Moden (2/6/2010)
Here's the code that my old DBA and I came up with. The day we replaced the original code with the following code, the deadlocks dropped...
--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)

October 21, 2010 at 6:37 am

#1240242
RE: Are the posted questions getting worse?

GSquared (10/20/2010)
it's been worse than every other standard hierarchy implementation that I know of
What do you mean, Gus? How has it been worse? Implementation, performance, easy of...
--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)

October 20, 2010 at 3:20 pm

#1239967
RE: Are the posted questions getting worse?

Stefan Krzywicki (10/20/2010)
ALZDBA (10/20/2010)
GSquared (10/20/2010)
Jeff Moden (10/19/2010)
Steve Jones - SSC Editor (9/21/2010)
Paul White NZ (9/21/2010)
...
The current SQL development model is to address a small number of main product features 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)

October 20, 2010 at 3:17 pm

#1239965
RE: Are the posted questions getting worse?

Paul White NZ (10/20/2010)
GSquared (10/20/2010)
I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a "worst of...
--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)

October 20, 2010 at 3:16 pm

#1239963
RE: Using a common seed generation for multiple tables.

Randy Emerson (9/21/2010)
I haven't found a solution yet. But here is why we are trying this solution. We have an address table which needs to be referenced from...
--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)

October 19, 2010 at 11:34 pm

#1239477
RE: Cumulative sum for multiple sequences

jkeys-972541 (10/19/2010)
Hi,
I have set up a derivative of the above function on several databases and worked fine. On the last database I got the error:
Msg 4138, Level 16, State...
--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)

October 19, 2010 at 11:23 pm

#1239474
RE: Calling a Stored Procedure inside a stored procedure

Marv-1058651 (10/19/2010)
I am dumping these records into one table to then use for a Crystal Report, thats why I am deleting my results before the proc executes.
It doesn't solve your...
--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)

October 19, 2010 at 11:06 pm

#1239471
RE: Calculating Moving Averages with T-SQL

greg 2201 (9/24/2010)
Here is one approach for regularizing data into time "bars" that I found, posted on dbformus: http://www.dbforums.com/microsoft-sql-server/1660120-regularizing-time-intervals.html#post6478463
It runs very slowly however due to all the "group by" activity.
Soooooo.......
--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)

October 19, 2010 at 10:53 pm

#1239465
RE: Are the posted questions getting worse?

Stefan Krzywicki (10/19/2010)
Jeff Moden (10/19/2010)
Steve Jones - SSC Editor (9/21/2010)
Paul White NZ (9/21/2010)
...
The current SQL development model is to address a small number of main product features in each new...
--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)

October 19, 2010 at 9:55 pm

#1239457
RE: More efficient way

sturner (10/19/2010)
Thanks for making that point GregE.
Just so the original poster doesn't think I'm a grouch and since others did point a few of the more obvious problems, 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)

October 19, 2010 at 4:59 pm

#1239420
RE: Else '' Returns a 0?

gah (10/19/2010)
CELKO (10/18/2010)
1) Learn the differences between rows and records, columns and fields; it will help.
Apologies for going off topic here, but I am confused by this statement above.
BOL states...
--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)

October 19, 2010 at 4:46 pm

#1239415
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (9/21/2010)
Paul White NZ (9/21/2010)
...
The current SQL development model is to address a small number of main product features in each new major release. 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)

October 19, 2010 at 4:33 pm

#1239411
RE: Are the posted questions getting worse?

Paul White NZ (9/21/2010)
Gianluca Sartori (9/21/2010)
I agree that some of the new features have been implemented poorly, but I really would like to see those window functions in the next...
--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)

October 19, 2010 at 4:27 pm

#1239408
RE: Are the posted questions getting worse?

Gianluca Sartori (9/21/2010)
Paul White NZ (9/20/2010)
Steve Jones - Editor (9/20/2010)
BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote...
--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)

October 19, 2010 at 4:25 pm

#1239407

Viewing 15 posts - 36,301 through 36,315 (of 59,067 total)