Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,571 through 24,585 (of 59,102 total)

RE: Are the posted questions getting worse?

rodjkidd (1/30/2014)
Company has out sourced prod DBA team. Been up and running since start of year, so some things are still falling through the cracks. So don't know if they...
--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)

January 30, 2014 at 11:30 am

#1684800
RE: Today's Random Word!

"JOCC BOOSTR" (pronounced "jock booster")
Definition:
Justification Of Crap Code Based Only On Small Table Requirements
🙂
--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)

January 30, 2014 at 11:01 am

#1684787
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Jerry Kelk (1/30/2014)
I think it depends on the purpose of the request.
If my 'customer' wants a one-time answer to such a question, on less than a huge table, I think...
--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)

January 30, 2014 at 10:43 am

#1684780
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Jerry_Boutot (1/30/2014)
Nice article, well written. As a developer that has had to do a lot of work around date and time functionality, I can appreciate this article. You are correct...
--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)

January 30, 2014 at 8:56 am

#1684716
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Jerry Kelk (1/30/2014)
Fair comment Jeff. Point taken.
Fortunately, I don't have huge data or paying customers, so on a horses-for-courses basis, the method suits me well enough.
Food for thought though,...
--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)

January 30, 2014 at 8:47 am

#1684708
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Sean Lange (1/30/2014)
Thomas Abraham (1/30/2014)
When I went to review this spackle, I found the current rating was "Good". Can't agree. Jeff has, as usual, taken a problem of some import,...
--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)

January 30, 2014 at 8:41 am

#1684701
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Thomas Abraham (1/30/2014)
When I went to review this spackle, I found the current rating was "Good". Can't agree. Jeff has, as usual, taken a problem of some import, broken 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)

January 30, 2014 at 8:27 am

#1684695
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

vitex2003 (1/30/2014)
SELECT RangeType,StartDate,EndDate,Comment
FROM dbo.TestTable
WHERE convert(char(10),EndDate,102) >= cast('01 Oct 2013' as datetime)
AND convert(char(10),StartDate,102) <= cast('01 Nov 2013' as...
--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)

January 30, 2014 at 8:14 am

#1684692
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Jerry Kelk (1/30/2014)
This deals with the time problem without having to give it a thought.
Thanks for the feedback and the code, Jerry, but you've just exemplified one of the reasons...
--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)

January 30, 2014 at 8:10 am

#1684689
RE: Are the posted questions getting worse?

rodjkidd (1/30/2014)
Serious Doh! Moment today.
... {snip}...
Went to talk to one of the Prod DBA's as my access on the server is limited, and he spots that the server has run...
--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)

January 30, 2014 at 8:01 am

#1684686
RE: Are the posted questions getting worse?

rodjkidd (1/30/2014)
Another awesome SQL Spackle from Jeff today.
Cheers Jeff!
Rodders...
Thanks Rodders. This one was aimed mostly at helping newbies to SQL Server understand the problem especially since there have been...
--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)

January 30, 2014 at 7:39 am

#1684673
RE: Comparing string with date

Lempster (1/29/2014)
Jeff Moden (1/29/2014)
Too bad because I finally learned how to copy'n'paste my SARGable solution correctly. :blush:
Could you post your solution anyway Jeff?
Regards
Lempster
Sure. With the understanding that such...
--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)

January 30, 2014 at 7:24 am

#1684664
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

vitex2003 (1/30/2014)
Everything is right, but there are and other ways how to make your code bullet proof.
Thanks for the insight. Would you post some code for said bullet proofing?...
--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)

January 30, 2014 at 7:09 am

#1684651
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

danielfountain (1/30/2014)
Excellent article. A problem that i have never come across but may do. The train of thought on the problem was insightful.
That, good sir, is why...
--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)

January 30, 2014 at 7:01 am

#1684644
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Thanks guys. I appreciate 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)

January 30, 2014 at 6:58 am

#1684637

Viewing 15 posts - 24,571 through 24,585 (of 59,102 total)