Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,546 through 49,560 (of 59,102 total)

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

Wingenious (6/28/2008)
It would seem more sensible to have database developers guiding and coordinating database development.
...
The databases were built on an impromptu basis by application developers working outside their area 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)

June 29, 2008 at 12:58 pm

#835900
RE: The T-SQL Quiz

Nah... After adding the "ALL", yours is just as fast, fewer lines to remember, and easier on the eyes.
a lot of shops have prohibitions about using system objects...
--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 12:47 pm

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

Sorry... I don't get it... Why were 7 rows for EventData1 = 7 included in the output?
Also, please see the link in my signature for how to post data so...
--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 12:36 pm

#835898
RE: One function causes CPU 100

You can't replace the vendor's sproc? Heh... I do it all the time especially when it sucks the life out of my servers... 😉
--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 11:27 am

#835893

Viewing 15 posts - 49,546 through 49,560 (of 59,102 total)