Today's Random Word!

Question

Today's Random Word!

Viewing 15 posts - 736 through 750 (of 21,190 total)

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

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

mbricker-600840 (3/16/2010)
Marguerita (too bad it's too early).
I used to work for a company that had a frozen marguerita machine in the kitchen.
Every afternoon, we would fire it up so it would be ready by 5. Ahhhhh, the good old days before
someone realized there was a liability issue.
Mike

It's 5 o'clock some where!

Ray K SSC-Dedicated Points: 31164 More actions · Answer 2

Steve Jones - Editor (3/15/2010)
baseball.
Registered for the new team and got a picture in the mail from Mom

You should post this in the baseball thread!

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

Paul White SSC Guru Points: 150467 More actions · Answer 3

mbricker-600840 (3/16/2010)
I used to work for a company that had a frozen marguerita machine in the kitchen

Why would anyone freeze a marguerita machine? 😛 :w00t:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (3/16/2010)
mbricker-600840 (3/16/2010)
I used to work for a company that had a frozen marguerita machine in the kitchen
Why would anyone freeze a marguerita machine? 😛 :w00t:

It fooled the hippo?

^{“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

Paul White SSC Guru Points: 150467 More actions · Answer 5

Chris Morris-439714 (3/16/2010)
It fooled the hippo?

Disturbing...:hehe:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 6

Steve Jones - SSC Editor

SSC Guru

Points: 736270

March 16, 2010 at 8:47 am

#1134505

Yep, #7, many moons ago.

Paul White SSC Guru Points: 150467 More actions · Answer 7

Steve Jones - Editor (3/16/2010)
Yep, #7, many moons ago.

Same guy - very different shirt :laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Paul White (3/16/2010)
Steve Jones - Editor (3/16/2010)
Yep, #7, many moons ago.
Same guy - very different shirt :laugh:

Resemblance is astounding.

As for the shirt, I am sure we can find somebody to fix that. Plenty of paintshop wizards lurking about.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

John Rowan SSC Guru Points: 56440 More actions · Answer 9

Pain.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

CirquedeSQLeil (3/15/2010)
Jeff Moden (3/15/2010)
Lynn Pettis (3/14/2010)
snowshoes
One Post. 😉
yeah, he's holding out on us now. He retreated to the tent knowing he was at 9999.

I wanted the 10,000th post to be one where I at least tried to help someone solve a problem. Turned out I ended up rewriting my own routine to use ALTER USER instead of sp_change_user_login (thanks Paul).

Paul White SSC Guru Points: 150467 More actions · Answer 11

Lynn Pettis (3/16/2010)
Turned out I ended up rewriting my own routine to use ALTER USER instead of sp_change_user_login (thanks Paul).

LOL. You should have edited your previous post instead and saved the 10,000 for something!

Only 240-ish posts until you hit 10K posts 😉

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (3/16/2010)
Lynn Pettis (3/16/2010)
Turned out I ended up rewriting my own routine to use ALTER USER instead of sp_change_user_login (thanks Paul).
LOL. You should have edited your previous post instead and saved the 10,000 for something!
Only 240-ish posts until you hit 10K posts 😉

I think my 10,000 post was okay. It wasn't a "water-cooler" post, and and it encouraged a rewrite of a routine that will be in production for (hopefully) a long time.

The only problem was the time it took to rewrite dynamic sql to write dynamic sql. Getting all the single quotes (') right is a RPITB, but once done, it's done.

Paul White SSC Guru Points: 150467 More actions · Answer 13

Lynn Pettis (3/16/2010)
The only problem was the time it took to rewrite dynamic sql. Getting all the single quotes (') right is a RPITB, but once done, it's done.

I must confess I usually use a CURSOR for that type of thing. Performance is never an issue; my time is 😉

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (3/16/2010)
Lynn Pettis (3/16/2010)
The only problem was the time it took to rewrite dynamic sql. Getting all the single quotes (') right is a RPITB, but once done, it's done.
I must confess I usually use a CURSOR for that type of thing. Performance is never an issue; my time is 😉

As often as I write cursors, it probably would have taken just as long.

You also could say performance here is an issue as this routine resync's SQL Server logins when we have a mirror failover. We may not have a lot of logins to resync, but you never know if that may change in the future.

Paul White SSC Guru Points: 150467 More actions · Answer 15

Lynn Pettis (3/16/2010)
As often as I write cursors, it probably would have taken just as long.

I see. I write a fair number of cursors, usually for drip-feeding semi-bulk data changes into busy production systems, so it would take about a minute, I reckon.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi