Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,966 through 37,980 (of 59,098 total)

RE: Make a 100+ Server Inventory in 30 minutes

Stanley Chan (6/23/2010)
Jeff Moden (6/22/2010)
stephen.burke (6/14/2010)
MAPS from Microsoft is the best way to record all such info in a database for you, plus a ncie report and excel spreadsheet.
In order...
--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)

June 23, 2010 at 6:14 am

#1183873
RE: Make a 100+ Server Inventory in 30 minutes

stephen.burke (6/14/2010)
MAPS from Microsoft is the best way to record all such info in a database for you, plus a ncie report and excel spreadsheet.
In order to produce the inventory...
--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)

June 22, 2010 at 4:03 pm

#1183634
RE: Records per hour within a time span

daveb-840383 (6/22/2010)
OK... I tried out Eugenes code on a much bigger data set. It appears to be aggregating hourly.
What I'm trying to do is get a total hourly count, not...
--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)

June 22, 2010 at 3:55 pm

#1183628
RE: Cursors Be Gone!

YSLGuru (6/21/2010)
Wow Tom, you really need to whip up on this guy bad ey?
It my be just me but it doesn't look that way to me. Gaby cited some...
--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)

June 22, 2010 at 7:18 am

#1183307
RE: Records per hour within a time span

Eugene Elutin (6/19/2010)
Jeff, in a final code I would use temp table (like in the first sample). But in this case I did it with CTE to save few lines...
--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)

June 21, 2010 at 10:52 am

#1182858
RE: Records per hour within a time span

Ya know... after I got done tweaking my code, except for the way we gen the dates, the code came out nearly identical as your latest tweek. I'll also...
--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)

June 19, 2010 at 10:02 am

#1182444
RE: Records per hour within a time span

Eugene Elutin (6/19/2010)
Your query does proper check and returns the count of records for each hour between given dates in StartDate and NextStartDate, however if you add time part (eg....
--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)

June 19, 2010 at 8:44 am

#1182442
RE: Are the posted questions getting worse?

Greg Edwards-268690 (6/18/2010)
WayneS (6/18/2010)
Just my luck.....
Wednesday, I updated a test box to SQL 2008. Pretty old (> 9 years)...
Last night, the drive controller failed spectacularly (sparks, smoke, everything), completely corrupting...
--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)

June 18, 2010 at 9:11 pm

#1182405
RE: Formatting and Readability

Nadrek (6/18/2010)
Different styles are different styles, neither good nor bad:
SELECT a.c1
,a.c2
,b.c1
FROM db.schema.tbla a
INNER JOIN db.schema.tbla b
ON b.col1 = a.col1
AND a.col2 = b.col2
Heh... well, except for maybe that leading...
--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)

June 18, 2010 at 9:03 pm

#1182404
RE: Records per hour within a time span

Scott is correct. The code I posted has no checks for whole days nor even whole hours.
If your code is passing the start date as a legal...
--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)

June 18, 2010 at 6:44 pm

#1182389
RE: Simple query for the Months of a year

WayneS (6/18/2010)
Dan.Humphries (6/18/2010)
Actually before I read your article I must admit I gave very little thought to set based programming at all.
Now, this here is a man that isn't afraid...
--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)

June 18, 2010 at 5:01 pm

#1182382
RE: Records per hour within a time span

Eugene Elutin (6/18/2010)
Nice problem.
Here is my first attempt:
declare @periodStart datetime
declare @periodEnd datetime
-- they must be inside of the same day!!!!
set @periodStart = '20100601'
set @periodEnd = '2010-06-10 23:59:59.000'
declare @givendate datetime
set...
--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)

June 18, 2010 at 4:52 pm

#1182381
RE: Simple query for the Months of a year

Dan.Humphries (6/18/2010)
just to throw my two since in I think that if you are doing a full blown table with dates then this is a better option this is particularly...
--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)

June 18, 2010 at 2:11 pm

#1182342
RE: Cursors Be Gone!

TheSQLGuru (6/18/2010)
Myself and a number of other MVPs have been hitting Microsoft up to get them to make cursors perform much better on the platform, which would be a benefit...
--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)

June 18, 2010 at 1:02 pm

#1182323
RE: Formatting and Readability

Agreed... both formatting and appropriate commenting are essential ingredients to good code.
--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)

June 18, 2010 at 6:51 am

#1182091

Viewing 15 posts - 37,966 through 37,980 (of 59,098 total)