Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,671 through 32,685 (of 59,099 total)

RE: Are the posted questions getting worse?

SQLRNNR (9/1/2011)
GSquared (9/1/2011)
I've hated horses ever since I had to ride them every day to get to the school bus. It was only up hill one way, but 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)

September 1, 2011 at 2:37 pm

#1376186
RE: Rebuilding indexes on solid-state disks; is it worth it?

+1 on Gail's recommendation.
+1 for anyone else that said "test it" because one simple test is worth a thousand "expert" opinions. If you need help created a highly fragmented...
--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)

September 1, 2011 at 11:48 am

#1376095
RE: Month and YTD Running Totals

Sorry I forgot the URL. Yep, that's the one. The code is very similar to the same way you would do a running total in a programming language...
--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)

September 1, 2011 at 11:37 am

#1376089
RE: Month and YTD Running Totals

Michael A. (8/31/2011)
Thanks again for any ideas.
Regards,
Mike
Mike,
Take a look at the following article to understand what I'd recommend to do this. If you do try the code on...
--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 31, 2011 at 8:06 pm

#1375785
RE: Month and YTD Running Totals

ColdCoffee (8/31/2011)
NOw, Jeff Moden is going to kill me for not using the Quirky update method.
Nope... no killing. I just want to know how you like your Pork Chops...
--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 31, 2011 at 8:01 pm

#1375784
RE: Running totals

cidr (8/31/2011)
I think I may have misled you. in the text file, there's around 18000 records in total per month. Below is what I wrote previously. However, the last...
--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 31, 2011 at 5:50 pm

#1375773
RE: Running totals

Understood... If I'm understanding things correctly, you also stated that you wanted one running total for each Sales Person and Product combination by day of month. You have 9578...
--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 31, 2011 at 12:54 pm

#1375647
RE: Are the posted questions getting worse?

WayneS (8/31/2011)
I'll be presenting to Roy's UG tomorrow night (Sept 1, 2011 @ 7:15pm EST). Click here (my blog)[/url] for details and a livemeeting link to attend virtually. Hope 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)

August 31, 2011 at 12:05 pm

#1375615
RE: Query execution much slower after upgrade

webtekkie (8/31/2011)
I'm back off my hols, and raring to go again.
Out of the three suggestions here, I've tried two of them. Sadly, the 'drop & recreate' idea failed 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)

August 31, 2011 at 12:01 pm

#1375614
RE: Running totals

Just as a side bar, you do realize than 9758 * 30 days per month will create more than a quarter million rows per month? It's no problem for...
--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 31, 2011 at 11:59 am

#1375612
RE: Running totals

Perfect. Thanks. I'll spend some time on it afterwork and try to git'er done.
--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 31, 2011 at 11:54 am

#1375608
RE: Running totals

Sorry for peppering you with individual questions... how many total rows (orer of magnitude) do have in a given month ?
--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 31, 2011 at 7:27 am

#1375461
RE: Running totals

To be clear on the "2702 products sold per month"... that's 2702 unique product IDs?
--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 31, 2011 at 7:17 am

#1375450
RE: HELP...need to speed this up, taking +15 hrs now. Goal: insert rows for missing dates, based on previous date

Nope. No points or anything like that. I'm just glad to help. Thank you for your kind feedback. I always like to know how these things...
--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 30, 2011 at 6:23 pm

#1375283
RE: SQL 2008 - T-SQL query assistance

Sean Lange (8/29/2011)
Jeff do you have any experience using Nested Sets with multiple root level elements? for example in a menu system. I have used it in an org chart...
--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 30, 2011 at 6:12 pm

#1375280

Viewing 15 posts - 32,671 through 32,685 (of 59,099 total)