Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,071 through 32,085 (of 59,099 total)

RE: Maximum flow from continuous flow rate

Brian Ki (11/1/2011)
Sorry for the delay - back at it now. Normal flow rates of 0 to 10 mgd. Also there will be lots of data - perhaps...
--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)

November 1, 2011 at 10:09 pm

#1401966
RE: Wide table performance issue

Dev @ +91 973 913 6683 (10/20/2011)
That's what Views utilizing UNION are good for
Is it not a CLASSIC implementation in SQL Server (I believe SS2K), when we didn't...
--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)

November 1, 2011 at 5:15 pm

#1401928
RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

Jorge Serres (10/31/2011)
Simply use
exec sp_MSforeachTable 'sp_spaceused '
Oh... be careful, now. sp_spaceused in SQL Server 2000 doesn't always have accurate row counts. You have to use the "UPDATE USAGE"...
--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)

November 1, 2011 at 4:48 pm

#1401926
RE: What minimum rights do you need?

drew.georgopulos (11/1/2011)
Thanks a lot Mr. Moden;
I was strongly cautioned by Evil Kraig F's and Omar Ismail's responses, so we've split the difference...development stops at visual studio. once the report is...
--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)

November 1, 2011 at 4:35 pm

#1401923
RE: SPLITTING CSV COLUMN TO MULTIPLE COLUMNS IN 1 ROW

ramanamreddy (11/1/2011)
what will be the code if the no.of columns are unknown like how to write the code dynamically???
Kind of like the code in the following article...
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)

November 1, 2011 at 4:24 pm

#1401921
RE: Selecting list of month numbers between two dates

drew.georgopulos (6/21/2011)
looking forward to it!
I want you to know i am standing up at my desk to say Thank You immensely for your time and effort Mr. Moden!
drew
ps. this sucka...
--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)

November 1, 2011 at 4:20 pm

#1401916
RE: Selecting list of month numbers between two dates

Greg - KPS, LLC (11/1/2011)
Jeff,
I am looking at your sample and I have to ask one question:
By using master.sys.all_columns, aren't you limited to 1000 days?
I am looking at generating 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)

November 1, 2011 at 4:16 pm

#1401914
RE: Maximum flow from continuous flow rate

Brian Ki (10/31/2011)
yes, Rolling Window describes it well - never heard of that. Yes, we can limit it to a day, and yes, I should have put 2:02:14 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)

November 1, 2011 at 4:05 pm

#1401910
RE: Maximum flow from continuous flow rate

Evil Kraig F (11/1/2011)
Heh, I wonder if we're thinking along the same lines Jeff. I'm currently puzzling out a rolling window mechanic that should only need one (maybe two)...
--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)

November 1, 2011 at 7:39 am

#1401606
RE: Need Charindex to Pick Up the Second Instance

sdownen05 (10/31/2011)
Not a problem, Jeff. Thanks for calling me on that.
....
However, I just noticed Ninja's_RGR'us post. That code is much better than mine.
Thanks, Steve. That's the spirit. Now...
--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)

November 1, 2011 at 7:30 am

#1401600
RE: Help with performance - aggregating a lot of data

Kiara (11/1/2011)
Oh, I'm game to experiment. I'm not afraid of my test environment in the slightest, and I won't move something into production unless I'm convinced it will work well....
--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)

November 1, 2011 at 7:22 am

#1401597
RE: Help with performance - aggregating a lot of data

Evil Kraig F (11/1/2011)
Jeff Moden (10/31/2011)
I was simply going to add the date, EmpID, and 3 calculated columns to the detail table and hide them from the app using 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)

November 1, 2011 at 7:10 am

#1401593
RE: How to Get Month Using Given two Dates

codebyo (10/31/2011)
... so no need to worry about loops there and also because it's easier to read. 😉
You do understand that them's fightin' words, right Andre? 😉
--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 31, 2011 at 10:44 pm

#1401416
RE: Searching smallest unused number

Ninja's_RGR'us (10/26/2011)
@Cadavre We stopped wasting our time proving wrong JC (not short for Jesus-Christ).
No we didn't. 🙂 And I rather enjoyed the display of prowess that Cadavre put...
--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 31, 2011 at 10:40 pm

#1401415
RE: Isthere any function in T-SQL to get day of week using?

BWAA-HAAA!!! I just realized the original question is from 5 years ago and the OP is probably long gone. 😀
--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 31, 2011 at 10:27 pm

#1401412

Viewing 15 posts - 32,071 through 32,085 (of 59,099 total)