April 30, 2009 at 3:50 pm
Hmm. That blunted the intended impact somewhat :doze:
Fixed now - I must not put underline tags inside the url tags it seems!
Thanks everyone for letting me know.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 30, 2009 at 3:51 pm
New non off topic for this thread...
http://www.sqlservercentral.com/Forums/Topic706693-361-1.aspx?Update=1
April 30, 2009 at 3:54 pm
john.arnott (4/30/2009)
RBarryYoung (4/30/2009)
... I would have had him two feet off the ground, grasping at his own throat....as you sardonically tell him "I find your lack of respect for forum etiquette disturbing."
Heh, good line, John. I might use it in the future... 🙂
And thanks to all for the "Welcome Backs", just trying to take it easy for now.
[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]
April 30, 2009 at 3:55 pm
Florian Reischl (4/30/2009)
New non off topic for this thread...
:laugh:
Saw that yesterday and figured Steve had sorted it. He's a braver man than I.
Seems I underestimated the OP.
Ho hum.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 30, 2009 at 4:32 pm
Paul White (4/30/2009)
Florian Reischl (4/30/2009)
New non off topic for this thread...:laugh:
Saw that yesterday and figured Steve had sorted it. He's a braver man than I.
Seems I underestimated the OP.
Ho hum.
Paul
I don't think this one's carrying a squeegee. I got the impression from his syntax and use of "Ja..." that perhaps English is not his first language. Yes, Steve gave code samples, but the guy just (mis)read the post. I posted a reiteration of the advice and we'll see whether he comes back with an "oops. Now I get it".
April 30, 2009 at 4:40 pm
John,
Good point - I feel as though I was harsh now.
However, I suspect that expecting behaviour to change simply by deleting a comment is the same in any language 😉
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 30, 2009 at 4:45 pm
Gail - can you give a good answer to this? I kinda thought along these line also.
http://www.sqlservercentral.com/Forums/Topic707743-338-1.aspx
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 30, 2009 at 4:48 pm
WayneS (4/30/2009)
Gail - can you give a good answer to this?
Offhand, no, but I suspect it has something to do with Statement level recompile and/or temp table caching. I wonder if he'd see the same behaviour if two different connections were running the proc alternately.
Past bedtime (1am). Will look in tomorrow
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2009 at 4:50 pm
Lynn Pettis (4/29/2009)
Roy Ernest (4/29/2009)
I am reaching that magic figure of 1000. But that does not mean I know anything. But I try to learn from reading the solutions to different problems others have posted. I do not have that much knowledge to help others, but I try to learn from the Gurus here. 🙂And when ever I post an answer I say that this is what comes to my mind. But maybe others here have a better solution than mine.
And that, Roy, is what most of us do. The answers we post are the ones that come to our mind as well. The beauty of this site is that we get to see a variety of ways to accomplish the same task. Some are better than others, that's true. But you also hit the nail on the head when you say you try to learn from Gurus here; so do I. I have learned more here on SSC than I have from just doing my job. Everything I have learned I have also been able to apply in some way as well.
Edit: How does it go? The more I know, the more I know I don't know.
I think both of you'll are dead-on here. especially
I have learned more here on SSC than I have from just doing my job.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 30, 2009 at 4:52 pm
Roy Ernest (4/29/2009)
Its not a secret...Lots of people have written about it in different sites. I have tried my best. Hope it is good. It is about Transparent Data Encryption.
Sounds pretty interesting. Always looking for things that others have tried that I haven't (yet).
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 30, 2009 at 4:54 pm
Bruce W Cassidy (4/29/2009)
Roy Ernest (4/29/2009)
I finished my article and it is on the way for publication... May 4th is the D-Day for me....[font="Verdana"]Well done, Roy! International Star Wars day... "May the 4th be with you."[/font]
LOL :w00t:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 30, 2009 at 4:55 pm
WayneS (4/30/2009)
Gail - can you give a good answer to this? I kinda thought along these line also.http://www.sqlservercentral.com/Forums/Topic707743-338-1.aspx
I think Gail nailed it. I sure hope so since I posted that as a possible answer before I saw what she thought.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 30, 2009 at 4:56 pm
Lynn Pettis (4/29/2009)
[/quote-0]
Whatcha trying to do, find out how old I... errrr.... we are?
Yeah, I'm one.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 30, 2009 at 4:58 pm
Hi John
I'm quiet sure that English is not her/his first language (due to the "Ja" I think he is German) but this is not the problem. I would never finger point at somebody because of bad English.
If I post a 200 line question to an international forum and I get a four line answer (two lines text) which I don't understand I have to investigate what was meant. I'm also German and I know that my English is not the best so LEO is always one of the tabs in Firefox when I'm here.
Greets
Flo
April 30, 2009 at 5:08 pm
RBarryYoung (4/30/2009)[hrThe operation was entirely successful and I am home.
Glad to hear you're home, and good to see you back here! How long of a recovery period are they telling you?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 15 posts - 3,856 through 3,870 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply