Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,531 through 49,545 (of 59,099 total)

RE: The T-SQL Quiz

It will vary from machine to machine... except on Tuesdays... 😛
--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)

July 1, 2008 at 12:23 am

#836451
RE: Replace non numeric characters in string

Please define what the US non-special characters are...
--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)

July 1, 2008 at 12:20 am

#836448
RE: dbcc showcontig - why does it show an index that doesn't exist?

Thanks for that... good to know! 🙂
--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 30, 2008 at 8:57 am

#836186
RE: Is T-Sql really that hard to learn?

GSquared (6/30/2008)
I've seen the same thing happen when someone discovers "all the wonderful performance benefits" of "with (nolock)" and just goes crazy including it in everything. (I think every...
--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 30, 2008 at 8:07 am

#836138
RE: Is T-Sql really that hard to learn?

Matt Miller (6/26/2008)
In my mind, the bigger problem isn't that bad code occurs, or that sloppy developers put it out; the bigger problem is that it's allowed to continue 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)

June 30, 2008 at 8:01 am

#836131
RE: Is T-Sql really that hard to learn?

Antares686 (6/26/2008)
You could go to your bosses and propose the idea of a DBA doing code quality exams and explain they improve performance, can reduce unexpected downtime and overall produce...
--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 30, 2008 at 7:58 am

#836128
RE: Retreiving a count by date including dates with no data.

It's ok... the ORDER BY's don't hurt anything and they both make it very obvious to the reader what's happening. That can be worth it's weight in gold when...
--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 29, 2008 at 7:58 pm

#835958
RE: help with data type and default value

fisher08 (6/27/2008)
Its the partners specs not ours, we are working for them in a way or else they will go elsewhere...that's why don't ask why...:)
In that case, I'd ask "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)

June 29, 2008 at 6:34 pm

#835953
RE: Retreiving a count by date including dates with no data.

True enough... I kinda like @Days, though... makes the CTE easier to read from a self documenting aspect. Yeah, I know... easy to read anyway. 🙂
--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 29, 2008 at 6:25 pm

#835950
RE: Retreiving a count by date including dates with no data.

Actually, no Order By is really necessary except to satisfy the syntactical requirements of Row_Number()...
For example...
[font="Courier New"]SET STATISTICS TIME OFF
SET STATISTICS IO OFF
PRINT REPLICATE('=',100) ---------------------------------------------------------
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
PRINT '===== Jeff Moden''s...
--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 29, 2008 at 6:01 pm

#835947
RE: The T-SQL Quiz

Similar error as to what someone recently did with dates 😉 Check the final value of @BitBucket on Matt's...
--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 29, 2008 at 5:47 pm

#835944
RE: eliminating duplicates

rbarryyoung (6/29/2008)
Hey, did you get a chance to look at that draft yet?
Barely... I did a quick scan and now I need to do a full read...
--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 29, 2008 at 5:41 pm

#835941
RE: SQL table dynamic creation

gerald.duncan (6/29/2008)
The "WHY" is a business requirement that is really none of your concern. I've asked about a solution for a problem and all I'm getting is why do I...
--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 29, 2008 at 5:33 pm

#835939
RE: Retreiving a count by date including dates with no data.

... and, come to think of it... I think 1 Order By in the CTE will probably be enough, as 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)

June 29, 2008 at 5:30 pm

#835937
RE: Retreiving a count by date including dates with no data.

Much better... now, with the TOP in the CTE, do you really need the WHERE clause?
--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 29, 2008 at 5:28 pm

#835936

Viewing 15 posts - 49,531 through 49,545 (of 59,099 total)