T-Sql rant

Question

T-Sql rant

Viewing 15 posts - 121 through 135 (of 465 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Gaby Abed (3/16/2009)
Steve Jones - Editor (3/16/2009)
I think THE THREAD has no worries from this one.
I'm guessing this thread is the one you're referring to? 🙂
Gaby

Sure is.

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 2

All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.

Let us make great sacrifice of cursors and recursive CTEs....

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

GabyYYZ SSCertifiable Points: 7913 More actions · Answer 3

Bob Hovious (3/16/2009)
All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.
Let us make great sacrifice of cursors and recursive CTEs....

"In the beginning was the THREAD.

The THREAD was without form and light.

And lo, St. Michael did ask his question,

and the THREAD was born.

"It is destined to grow forever,

Having so many devotees paying homage

To it's sheer magnaminity,

And fed with the blood of those who dare

Question without thought."

Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 4

Gaby Abed (3/16/2009)
Bob Hovious (3/16/2009)
All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.
Let us make great sacrifice of cursors and recursive CTEs....
"In the beginning was the THREAD.
The THREAD was without form and light.
And lo, St. Michael did ask his question,
and the THREAD was born.
"It is destined to grow forever,
Having so many devotees paying homage
To it's sheer magnaminity,
And fed with the blood of those who dare
Question without thought."

Blimey...you're all turning into L Ron's...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 5

Steve Jones - SSC Editor

SSC Guru

Points: 736494

March 16, 2009 at 9:32 am

#960353

I am starting to cringe. Two threads :w00t:

GabyYYZ SSCertifiable Points: 7913 More actions · Answer 6

Steve Jones - Editor (3/16/2009)
I am starting to cringe. Two threads :w00t:

Okay, will stop...LOL

Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 7

I am starting to cringe. Two threads

Sacrilege!!

Heresy!!

There can only be One!!

I think I need to go take my meds, now...

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 8

Bob Hovious (3/16/2009)
I am starting to cringe. Two threads
Sacrilege!!
Heresy!!
There can only be One!!
I think I need to go take my meds, now...

You'll be oblivious, Bob Hovious, that's obvious.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Gift Peddie SSC Guru Points: 73570 More actions · Answer 9

You mean like Thomas Hardy's the Sacrilege. 🙂

Title: The Sacrilege

Author: Thomas Hardy

"I have a Love I love too well

Where Dunkery frowns on Exon Moor;

I have a Love I love too well,

To whom, ere she was mine,

'Such is my love for you,' I said,

'That you shall have to hood your head

A silken kerchief crimson-red,

Wove finest of the fine.'

http://www.readbookonline.net/readOnLine/10303/

:Whistling:

Kind regards,
Gift Peddie

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 10

Further banter along these lines should continue in The Thread.... so I'm posting my response there, Chris.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Steve Jones - Editor (3/16/2009)
I am starting to cringe. Two threads :w00t:

Hmmm, remember I think some pondered about the Son of the Thread...

RBarryYoung SSC Guru Points: 143329 More actions · Answer 12

Gaby Abed (3/16/2009)
Bob Hovious (3/16/2009)
All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.
Let us make great sacrifice of cursors and recursive CTEs....
"In the beginning was the THREAD.
The THREAD was without form and light.
And lo, St. Michael did ask his question,
and the THREAD was born.
"It is destined to grow forever,
Having so many devotees paying homage
To it's sheer magnaminity,
And fed with the blood of those who dare
Question without thought."

Nice, Gaby. Is that from Paradise Lost?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 13

Isn't it nice that we can end this particular rant on a pleasant note?

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 14

Bob Hovious (3/16/2009)
Isn't it nice that we can end this particular rant on a pleasant note?

C#

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 15

Et tu, Chris?

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills