T-Sql rant

Question

Post reply

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: 442447 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442447

March 16, 2009 at 9:06 am

#960309

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: 53353 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: 728159 More actions · Answer 5

Steve Jones - SSC Editor

SSC Guru

Points: 728159

March 16, 2009 at 9:32 am

#960353

I am starting to cringe. Two threads :w00t:

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

GabyYYZ SSCertifiable Points: 7913 More actions · Answer 6

GabyYYZ

SSCertifiable

Points: 7913

March 16, 2009 at 9:34 am

#960355

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: 53353 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: 53353 More actions · Answer 10

The Dixie Flatline

SSC Guru

Points: 53353

March 16, 2009 at 9:54 am

#960383

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: 442447 More actions · Answer 11

Lynn Pettis

SSC Guru

Points: 442447

March 16, 2009 at 10:43 am

#960408

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: 53353 More actions · Answer 13

The Dixie Flatline

SSC Guru

Points: 53353

March 16, 2009 at 11:07 am

#960428

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: 53353 More actions · Answer 15

The Dixie Flatline

SSC Guru

Points: 53353

March 16, 2009 at 11:19 am

#960440

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