Jeff Moden

Forum Replies Created

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

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
RE: Database Developers - The Missing Link

john.henderson (6/29/2008)
whether the set has one member or a million doesnt matter - handle the whole set.
That's step 1 to perfect set based thinking... glad to see someone else believe...
--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:26 pm

#835935
RE: How do I fill in the dates with the same data as the previous record until it changes in SQL Server 2000?

Search the following article for "Dozens of Other Uses" and look at the first script after that... correctly applied, it's the answer to your problem...
--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:22 pm

#835934
RE: One function causes CPU 100

It's a challenge only if you can't get people to listen... I couldn't get them to listen the first time either... then, I took a 24 hour process that would...
--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:19 pm

#835932
RE: no parallelism in the execution plan - why?

TRACEY (6/29/2008)
Hi there - i had similar thing this week - where it took over 10 minutest to run a process and cpu went to 100%....and stayed there...I turned off...
--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:15 pm

#835931
RE: The T-SQL Quiz

dfalso (6/29/2008)
So now, what's the minimum number of rows guaranteed to be in master's syscolumns?
Like Barry said... there's always at least 11,000 rows even in a brand new installation. ...
--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:09 pm

#835929
RE: The T-SQL Quiz

rbarryyoung (6/29/2008)
Any of this cow left for me? 🙂
Here is my entry (really just a tweak of Jeff's):
Nicely done, Barry... but I get numbers just a bit slower (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 29, 2008 at 5:08 pm

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

Ummm... go check the final date Barry... might explain the "speed" you're getting...
--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 1:05 pm

#835903
RE: General Feedback on The Voice of the DBA podcasts

I think that's more of what they're after... I don't listen to the pod-casts for many of the same reasons... I'll even add a reason... I don't remember 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)

June 29, 2008 at 1:02 pm

#835901

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