Jeff Moden

Forum Replies Created

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

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
RE: The T-SQL Quiz

Matt Miller (6/28/2008)
It's just that I can more easily control the number I need to generate
Just messing with you a bit now, ol' friend... It's pretty easy 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 29, 2008 at 11:24 am

#835892
RE: The T-SQL Quiz

Matt Miller (6/28/2008)
Oh I know. It's just that I can more easily control the number I need to generate (when you get that big of a set you really...
--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 10:42 am

#835884
RE: The T-SQL Quiz

That's the big thing... the other thing not so obvious is you don't show how to limit the output to any given number. 😉
--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 28, 2008 at 11:57 pm

#835848
RE: The T-SQL Quiz

Thanks Matt...
Hey... like I said, take the exact code you posted and try to gen a 1000 rows... you'll see 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 28, 2008 at 10:31 pm

#835833
RE: eliminating duplicates

rbarryyoung (6/28/2008)
OK, I sent you the draft. Heh, I didn't see your reply before I sent, hopefully the mess o' text I sent will be alright.
I gotta wonder how...
--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 28, 2008 at 6:11 pm

#835815
RE: Increase Max characters retrieved in SQL SERVER 2005

You're gonna think I'm nuts, but that's the kind of stuff that you should turn around and write an article about.
--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 28, 2008 at 6:02 pm

#835813
RE: eliminating duplicates

rbarryyoung (6/28/2008)
Writing here is hard enough, but adapting to the form or an article, especially anything long, presents an almost insurmountable barrier to me...
Heh... nah... you have the knack and...
--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 28, 2008 at 5:16 pm

#835811
RE: The T-SQL Quiz

Then, if you add a check, all this talk about dynamic SQL becomes a moot point. 😉
--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 28, 2008 at 5:09 pm

#835810
RE: One function causes CPU 100

Like everyone has said, we'd probably need a lot more detail than that to actually help...
... but, based on your general description immediately above, I have to say 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)

June 28, 2008 at 1:53 pm

#835800
RE: Tricky Transact SQL

Carl Federl (6/28/2008)
This appears to be a variation on First-In First-Out allocation such as for allocating Payments to Invoices or for "best fit"
Someone posted a SQL solution this month but...
--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 28, 2008 at 12:25 pm

#835795
RE: Table Valued functions Vs Scalar Valued Functions

about 300-million rows
That's kinda what I thought you were going to say.
What I was suggesting is that the distance from Point A to Point B is exactly the same 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 28, 2008 at 12:22 pm

#835794

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