September 6, 2012 at 12:47 pm
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?What is the circle of life?
And they appear to be ignoring the advice they had been given in the other thread. What is wrong with this picure (and please, don't say the painter or the photographer)?
The illustrator?:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
I was going to say "what the heck is a picure?", but then I figured it was just that English thing again.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 6, 2012 at 1:07 pm
jcrawf02 (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?What is the circle of life?
And they appear to be ignoring the advice they had been given in the other thread. What is wrong with this picure (and please, don't say the painter or the photographer)?
The illustrator?:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
I was going to say "what the heck is a picure?", but then I figured it was just that English thing again.
No, that was a failure to strike the 't' hard enough on the keyboard.
September 6, 2012 at 1:08 pm
Lynn Pettis (9/6/2012)
jcrawf02 (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?What is the circle of life?
And they appear to be ignoring the advice they had been given in the other thread. What is wrong with this picure (and please, don't say the painter or the photographer)?
The illustrator?:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
I was going to say "what the heck is a picure?", but then I figured it was just that English thing again.
No, that was a failure to strike the 't' hard enough on the keyboard.
I thought a picure was 3.1415926% of a remedy.
--------------------------------------
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
September 6, 2012 at 2:10 pm
Stefan Krzywicki (9/6/2012)
Lynn Pettis (9/6/2012)
jcrawf02 (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?What is the circle of life?
And they appear to be ignoring the advice they had been given in the other thread. What is wrong with this picure (and please, don't say the painter or the photographer)?
The illustrator?:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
I was going to say "what the heck is a picure?", but then I figured it was just that English thing again.
No, that was a failure to strike the 't' hard enough on the keyboard.
I thought a picure was 3.1415926% of a remedy.
nah it is just 2/3 of a
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
September 6, 2012 at 2:36 pm
Steve Jones - SSC Editor (9/4/2012)
OK, not my day. Not sure how to break the news here that this person is in way, way, over their head.http://www.sqlservercentral.com/Forums/Topic1353224-2799-2.aspx#bm1354093
Okay, you're right. This person is in over their head.
September 6, 2012 at 2:48 pm
Lynn Pettis (9/6/2012)
Steve Jones - SSC Editor (9/4/2012)
OK, not my day. Not sure how to break the news here that this person is in way, way, over their head.http://www.sqlservercentral.com/Forums/Topic1353224-2799-2.aspx#bm1354093
Okay, you're right. This person is in over their head.
OH MY!!! I hadn't looked at that train wreck in a day or so. That is going to be a long painful ride to say the least.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 6, 2012 at 3:05 pm
Lynn Pettis (9/6/2012)
Steve Jones - SSC Editor (9/4/2012)
OK, not my day. Not sure how to break the news here that this person is in way, way, over their head.http://www.sqlservercentral.com/Forums/Topic1353224-2799-2.aspx#bm1354093
Okay, you're right. This person is in over their head.
Yup
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
September 6, 2012 at 3:08 pm
Lynn Pettis (9/6/2012)
I guess we are supposed to be miracle workers here and know just what went wrong given minimal information.
I saw that post and got very quiet as I tiptoed towards the exit. Seems they don't even know what the question is let alone where to begin to solve it.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 6, 2012 at 3:29 pm
Lynn Pettis (9/6/2012)
I guess we are supposed to be miracle workers here and know just what went wrong given minimal information.
With login failures the state is enough to diagnose the cause most of most cases.
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
September 6, 2012 at 3:48 pm
SQLRNNR (9/6/2012)
Stefan Krzywicki (9/6/2012)
Lynn Pettis (9/6/2012)
jcrawf02 (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?What is the circle of life?
And they appear to be ignoring the advice they had been given in the other thread. What is wrong with this picure (and please, don't say the painter or the photographer)?
The illustrator?:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
I was going to say "what the heck is a picure?", but then I figured it was just that English thing again.
No, that was a failure to strike the 't' hard enough on the keyboard.
I thought a picure was 3.1415926% of a remedy.
nah it is just 2/3 of a
Don't say you baked a pie and didn't have the decency to calculate past the 27th decimal?
September 6, 2012 at 5:48 pm
Jan Van der Eecken (9/6/2012)
SQLRNNR (9/6/2012)
Stefan Krzywicki (9/6/2012)
Lynn Pettis (9/6/2012)
jcrawf02 (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
SQLRNNR (9/6/2012)
Lynn Pettis (9/6/2012)
Why do people think that they will get a different answer to the same problem if they post it in the correct forum?What is the circle of life?
And they appear to be ignoring the advice they had been given in the other thread. What is wrong with this picure (and please, don't say the painter or the photographer)?
The illustrator?:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
I was going to say "what the heck is a picure?", but then I figured it was just that English thing again.
No, that was a failure to strike the 't' hard enough on the keyboard.
I thought a picure was 3.1415926% of a remedy.
nah it is just 2/3 of a
Don't say you baked a pie and didn't have the decency to calculate past the 27th decimal?
It's just an urban legend that pi has more than 27 decimal places. The Illuminati propagated the myth centuries ago in order to control the internet.
Now don't you read too closely into what I say. It makes me nervous. :ermm:
Steve.
P.S. It's Friday morning and I haven't had coffee yet. :blink:
September 6, 2012 at 8:03 pm
Why does he have to be so anal all the time? It gets real tiring reading it day after day. I wish SQLTeam would take him back.
September 6, 2012 at 8:12 pm
Lynn Pettis (9/6/2012)
Why does he have to be so anal all the time? It gets real tiring reading it day after day. I wish SQLTeam would take him back.
Pretend you're floating on calm seas with the sound of whales singing in the background.
Works for me.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
September 7, 2012 at 5:56 am
dwain.c (9/6/2012)
Lynn Pettis (9/6/2012)
Why does he have to be so anal all the time? It gets real tiring reading it day after day. I wish SQLTeam would take him back.Pretend you're floating on calm seas with the sound of whales singing in the background.
Works for me.
Even better, pretend you're floating on calm, singing whales!
--------------------------------------
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
Viewing 15 posts - 37,771 through 37,785 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply