May 9, 2012 at 7:07 am
May 9, 2012 at 7:16 am
Steve Jones - SSC Editor (5/8/2012)
Thanks, everyone. She struggled a bit to get going yesterday in the rain, but today she's having fun working in the barn.
First of all, congrats to both of you for working together for this goal.
But secondly.... seriously? fun working in the barn? mucking it out?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
May 9, 2012 at 8:35 am
WayneS (5/9/2012)
First of all, congrats to both of you for working together for this goal.But secondly.... seriously? fun working in the barn? mucking it out?
LOL, she's actually cleaning it up. She had a potential boarder come and mention that it was a bit of a mess and was wondering how she (the boarder) would organize her tack. So my wife is trying to clean out thing, move some to storage, and she's got me a few projects to build a bench and more saddle racks.
Actually mucking is relaxing work. Mindless, easy, a little sweat, and good time to think. We don't keep the horses in stalls, except in bad weather, so there usually isn't too much to clean up on a daily basis.
May 9, 2012 at 8:41 am
Steve Jones - SSC Editor (5/9/2012)
WayneS (5/9/2012)
First of all, congrats to both of you for working together for this goal.But secondly.... seriously? fun working in the barn? mucking it out?
LOL, she's actually cleaning it up. She had a potential boarder come and mention that it was a bit of a mess and was wondering how she (the boarder) would organize her tack. So my wife is trying to clean out thing, move some to storage, and she's got me a few projects to build a bench and more saddle racks.
Actually mucking is relaxing work. Mindless, easy, a little sweat, and good time to think. We don't keep the horses in stalls, except in bad weather, so there usually isn't too much to clean up on a daily basis.
Mucking stalls is how Kassondra got riding lessons from our neighbor many years ago. He also gave her some driving lessons early, letting her drive the pickup truck on the farm. His only rule, don't hit the cow. She didn't. Dropped him off the back of the truck once, and got the truck stuck between two trees, but didn't hit the cow.
May 9, 2012 at 10:39 am
Steve Jones - SSC Editor (5/9/2012)
WayneS (5/9/2012)
First of all, congrats to both of you for working together for this goal.But secondly.... seriously? fun working in the barn? mucking it out?
LOL, she's actually cleaning it up. She had a potential boarder come and mention that it was a bit of a mess and was wondering how she (the boarder) would organize her tack. So my wife is trying to clean out thing, move some to storage, and she's got me a few projects to build a bench and more saddle racks.
Actually mucking is relaxing work. Mindless, easy, a little sweat, and good time to think. We don't keep the horses in stalls, except in bad weather, so there usually isn't too much to clean up on a daily basis.
And really, how bad can it be? If I remember correctly from childhood reading, all you have to do is divert the local river and it washes everything clean!
--------------------------------------
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
May 9, 2012 at 12:09 pm
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
hii have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.
I am calling 5-6 sp inside my main sp and using table variables.
what causes it to run longer, what is the alternative of any of this??
thankis
I hate to say it, but I knew this post was coming. You do realize that had you given us what we asked for many posts ago on several threads you posted we would have shown you a better way to write your stored procedure without using a cursor or while loop.
So the question now is, are you finally going to provide us with everything we need to help you?
Guess Lynn's copy of DBCC TimeWarp is working now.
i would post in the thread but its not constructive to that conversation. here however its perfectly on point.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
May 9, 2012 at 12:22 pm
Steve Jones - SSC Editor (5/8/2012)
I assume most of you saw it, but for those that didn't, my wife quit her job[/url].
CONGRATS
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
May 9, 2012 at 1:01 pm
capn.hector (5/9/2012)
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
hii have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.
I am calling 5-6 sp inside my main sp and using table variables.
what causes it to run longer, what is the alternative of any of this??
thankis
I hate to say it, but I knew this post was coming. You do realize that had you given us what we asked for many posts ago on several threads you posted we would have shown you a better way to write your stored procedure without using a cursor or while loop.
So the question now is, are you finally going to provide us with everything we need to help you?
Guess Lynn's copy of DBCC TimeWarp is working now.
i would post in the thread but its not constructive to that conversation. here however its perfectly on point.
Okay, this got my curiosity going, so I hunted down the thread and responded to it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
May 9, 2012 at 1:05 pm
WayneS (5/9/2012)
capn.hector (5/9/2012)
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
hii have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.
I am calling 5-6 sp inside my main sp and using table variables.
what causes it to run longer, what is the alternative of any of this??
thankis
I hate to say it, but I knew this post was coming. You do realize that had you given us what we asked for many posts ago on several threads you posted we would have shown you a better way to write your stored procedure without using a cursor or while loop.
So the question now is, are you finally going to provide us with everything we need to help you?
Guess Lynn's copy of DBCC TimeWarp is working now.
i would post in the thread but its not constructive to that conversation. here however its perfectly on point.
Okay, this got my curiosity going, so I hunted down the thread and responded to it.
Don't do it Wayne...this guy is a black hole. He will post random gibberish and useless code snippets and get mad because your crystal ball can't see what he wants to do. Probably the most persistent and incompetent person to ever wield a keyboard. Run away now while you still have the chance.
_______________________________________________________________
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/
May 9, 2012 at 1:11 pm
Sean Lange (5/9/2012)
WayneS (5/9/2012)
capn.hector (5/9/2012)
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
hii have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.
I am calling 5-6 sp inside my main sp and using table variables.
what causes it to run longer, what is the alternative of any of this??
thankis
I hate to say it, but I knew this post was coming. You do realize that had you given us what we asked for many posts ago on several threads you posted we would have shown you a better way to write your stored procedure without using a cursor or while loop.
So the question now is, are you finally going to provide us with everything we need to help you?
Guess Lynn's copy of DBCC TimeWarp is working now.
i would post in the thread but its not constructive to that conversation. here however its perfectly on point.
Okay, this got my curiosity going, so I hunted down the thread and responded to it.
Don't do it Wayne...this guy is a black hole. He will post random gibberish and useless code snippets and get mad because your crystal ball can't see what he wants to do. Probably the most persistent and incompetent person to ever wield a keyboard. Run away now while you still have the chance.
Oh, and don't forget that sometime later he will come back and say he solved his problem.
May 9, 2012 at 1:15 pm
Lynn Pettis (5/9/2012)
Sean Lange (5/9/2012)
WayneS (5/9/2012)
capn.hector (5/9/2012)
Lynn Pettis (5/9/2012)
riya_dave (5/9/2012)
hii have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.
I am calling 5-6 sp inside my main sp and using table variables.
what causes it to run longer, what is the alternative of any of this??
thankis
I hate to say it, but I knew this post was coming. You do realize that had you given us what we asked for many posts ago on several threads you posted we would have shown you a better way to write your stored procedure without using a cursor or while loop.
So the question now is, are you finally going to provide us with everything we need to help you?
Guess Lynn's copy of DBCC TimeWarp is working now.
i would post in the thread but its not constructive to that conversation. here however its perfectly on point.
Okay, this got my curiosity going, so I hunted down the thread and responded to it.
Don't do it Wayne...this guy is a black hole. He will post random gibberish and useless code snippets and get mad because your crystal ball can't see what he wants to do. Probably the most persistent and incompetent person to ever wield a keyboard. Run away now while you still have the chance.
Oh, and don't forget that sometime later he will come back and say he solved his problem.
That is the still undocumented DBCC FindFixThroughOsmosis
Either that or the "fix" will spawn a new thread to fix the new problem created by the previous fix. The current thread is an example of that. He created an even performing pile of stink by implementing the previous OsmosisFix and now needs to know what to do to fix it.
Hopefully he will become very familiar with the common phrase, "Do you want fries with that?"
_______________________________________________________________
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/
May 9, 2012 at 1:17 pm
Okay, I know that there was a recent forum thread about upper and lower case keywords. The last post had a link to a site that could format sql code. I can't find that thread for anything and I know it was active just this week. Anyone help me find it?
All I know is that my ability to find it is weak, very weak.
May 9, 2012 at 1:20 pm
Lynn Pettis (5/9/2012)
Okay, I know that there was a recent forum thread about upper and lower case keywords. The last post had a link to a site that could format sql code. I can't find that thread for anything and I know it was active just this week. Anyone help me find it?All I know is that my ability to find it is weak, very weak.
_______________________________________________________________
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/
May 9, 2012 at 1:24 pm
Sean Lange (5/9/2012)
Lynn Pettis (5/9/2012)
Okay, I know that there was a recent forum thread about upper and lower case keywords. The last post had a link to a site that could format sql code. I can't find that thread for anything and I know it was active just this week. Anyone help me find it?All I know is that my ability to find it is weak, very weak.
Thank you.
May 9, 2012 at 1:29 pm
Lynn Pettis (5/9/2012)
Okay, I know that there was a recent forum thread about upper and lower case keywords. The last post had a link to a site that could format sql code. I can't find that thread for anything and I know it was active just this week. Anyone help me find it?All I know is that my ability to find it is weak, very weak.
There are a few: http://www.tsqltidy.com/
http://www.dpriver.com/pp/sqlformat.htm
and one from Red Gate: http://www.format-sql.com/
Viewing 15 posts - 35,971 through 35,985 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply