Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,0374,0384,0394,0404,041»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 3:52 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:40 AM
Points: 33,169, Visits: 15,303
touche, I was trapped by Jon and Joe.

Good seeing you in any case and glad you had a good week.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1468372
Posted Thursday, June 27, 2013 9:12 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:33 PM
Points: 23,237, Visits: 31,932
Cleared IRDO and will be heading to Afghanistan tomorrow via Kuwait.

It is actually happening! I am getting much more anxious!

I will probably be dark for about a week. Not sure about the internet situation in transit or once I get there.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1468416
Posted Thursday, June 27, 2013 10:19 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 4,013, Visits: 6,098
Godspeed, Lynn


__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #1468422
Posted Thursday, June 27, 2013 10:21 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:51 AM
Points: 5,587, Visits: 24,942
The Dixie Flatline (6/27/2013)
Godspeed, Lynn


+1


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1468423
Posted Friday, June 28, 2013 12:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 7,191, Visits: 13,645
Lynn Pettis (6/27/2013)
Cleared IRDO and will be heading to Afghanistan tomorrow via Kuwait.

It is actually happening! I am getting much more anxious!

I will probably be dark for about a week. Not sure about the internet situation in transit or once I get there.


Keep your head below the parapet, Lynn. Best wishes.


“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
Exploring Recursive CTEs by Example Dwain Camps
Post #1468446
Posted Friday, June 28, 2013 3:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:05 AM
Points: 2,982, Visits: 5,397
Steve Jones - SSC Editor (6/27/2013)
touche, I was trapped by Jon and Joe.

Good seeing you in any case and glad you had a good week.


That sounds like the title of your autobiography Steve!

Good seeing you as well. It was an awesome week. And you got a taste for it as well!

Rodders...



Post #1468471
Posted Friday, June 28, 2013 3:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:05 AM
Points: 2,982, Visits: 5,397
bitbucket-25253 (6/27/2013)
The Dixie Flatline (6/27/2013)
Godspeed, Lynn


+1

+2

Rodders...



Post #1468473
Posted Friday, June 28, 2013 11:45 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:00 AM
Points: 979, Visits: 5,090
Lynn: Stay safe!


Everyone else: Did everyone (in the US at least) start their July 4 weekend early? Sheesh...
Nothing in here since ~5:30am and that from someone I think is on the other side of the Atlantic...
Post #1468654
Posted Friday, June 28, 2013 11:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:44 PM
Points: 2,762, Visits: 7,235
jasona.work (6/28/2013)
Lynn: Stay safe!


Everyone else: Did everyone (in the US at least) start their July 4 weekend early? Sheesh...
Nothing in here since ~5:30am and that from someone I think is on the other side of the Atlantic...


That'd be very early indeed. The July 4th weekend is next weekend.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1468657
Posted Friday, June 28, 2013 11:53 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:56 PM
Points: 36,958, Visits: 31,466
rodjkidd (6/27/2013)
Jeff Moden (6/24/2013)
Steve Jones - SSC Editor (6/24/2013)
Just so the rest of you can feel jealous, I got a hug from Gail and a handshake from Rodney last week :)


I can't top that recently but I still have the piece of rebar that Rodney presented to me back in 2011.


Steve - you only got a handshake because of the desk you were sitting behind!
Hope SQL in The City went well. I hear the last seassion with Gail, Grant and yourself was the highlight.

Jeff you sure it was me? I remember having to looking up what one was as it was slightly lost in translation. Actually you came up in conversation at the Southampton Relay event. One of the speakers mentioned Numbers table, and pointed a couple of folks to your article here on SSC!

Cheers,

Rodders...


Sorry. Different Rodney.

Thanks for the referral on the Tally Table article.


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1468659
« Prev Topic | Next Topic »

Add to briefcase «««4,0374,0384,0394,0404,041»»»

Permissions Expand / Collapse