Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,346 through 45,360 (of 59,095 total)

RE: Sql Query Help

Eric Klovning (1/22/2009)
This article should give you the info you need.
http://www.sqlservercentral.com/articles/Test+Data/61572/
Heh... you beat me to it with my own stuff. 🙂
--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)

February 1, 2009 at 8:45 pm

#936235
RE: list of month names and week ranges between dates

ghughes (1/29/2009)
I found a great answer on 2005...
Would you post the URL for that answer, please? Thanks.
--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)

February 1, 2009 at 8:42 pm

#936234
RE: list of month names and week ranges between dates

ghughes (1/29/2009)
ok, for some reason I have never been asked this in my 5 years working on SQL server (2000).
I need to figure out how to get a list 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)

February 1, 2009 at 8:40 pm

#936233
RE: Keeping user database in memory

Do a test... build a RAM DISK and put the database on it. You'll soon find out that putting the database in memory can't make up for an improperly...
--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)

February 1, 2009 at 7:15 pm

#936221
RE: Get first and last date of supplied week & year

Thanks for the feedback, Buzz. 🙂
--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)

February 1, 2009 at 7:02 pm

#936219
RE: Undocumented Routines: Forbidden fruit.

GilaMonster (2/1/2009)
Jeff Moden (2/1/2009)
Like I said, wait until they fix the very well documented SUM() OVER... lot's of people are gonna have to fix a lot 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)

February 1, 2009 at 7:01 pm

#936218
RE: Undocumented Routines: Forbidden fruit.

ALZDBA (2/1/2009)
Jeff Moden (2/1/2009)
And THAT is what I'm really getting at... it doesn't matter if it's an undocumented feature or not! If you don't do any regression testing before...
--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)

February 1, 2009 at 7:00 pm

#936217
RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

Marios Philippopoulos (2/1/2009)
The SELECT query is for capturing the system info; has nothing to do with the trigger.
I know that... I'm suggesting that it's giving you bad information.
--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)

February 1, 2009 at 6:51 pm

#936216
RE: Subject and descriptions for posts

My thoughts are, if they don't want to include the important stuff in the body of the post, then they can wait. 😉
--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)

February 1, 2009 at 9:09 am

#936165
RE: Get first and last date of supplied week & year

I'd suggest the creation of a Calendar table. It has many uses including this one.
--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)

February 1, 2009 at 9:06 am

#936164
RE: Round

John is correct. To become better familiar with the ROUND function, take a look a Books Online... it has a full description and many examples to help you determine...
--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)

February 1, 2009 at 9:04 am

#936163
RE: Multiple Resultset in a single resultset (UNION)

I think that's begging for trouble, but thank you for the explanation.
--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)

February 1, 2009 at 8:45 am

#936161
RE: Using trim with Join

Ramesh (2/1/2009)
Hey Jeff, it was related to SSRS...
Yep... knew that and I admittedly haven't used SSRS... but, there are certain things like the presence or absense of "=" signs that...
--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)

February 1, 2009 at 8:37 am

#936160
RE: Undocumented Routines: Forbidden fruit.

Phil Factor (2/1/2009)
Yeah. spMakeWebTask. I love using this for dishing out excel-based reports via email. I still use it, but with a delegation process for doing daily reports (I'm too...
--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)

February 1, 2009 at 8:34 am

#936158
RE: Undocumented Routines: Forbidden fruit.

ALZDBA (2/1/2009)
Jeff Moden (1/31/2009)
That little privs change on sp_MakeWebTask killed a lot of people's code because it now requires "SA" privs and a lot of smart DBA's won't allow...
--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)

February 1, 2009 at 8:26 am

#936157

Viewing 15 posts - 45,346 through 45,360 (of 59,095 total)