April 9, 2014 at 8:33 am
Lynn Pettis (4/9/2014)
OMG!yuvipoy (4/9/2014)
I have been using this statement for nearly 6 years in prodution i did not get any error or issue.all of the sudden it happened today and i am unable to resolve the issue, still searching for the reason.
I am not sure which part of this is more scary, the fact that (s)he has been using NOLOCK through an ODBC connection for 6 years or that with at least 6 years experience (s)he doesn't have a better grasp of the language. :w00t:
_______________________________________________________________
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/
April 9, 2014 at 9:10 am
jasona.work (4/9/2014)
How to have a day go from "going OK" to "I'm almost unable to see straight I'm so ticked off."Find out from your wife that sometime between you leaving for work, and her leaving for work, that someone keyed the drivers side of her car (which was parked outside) and keyed "f**k you" on the hood...
Because of "stuff" in the garage, her car has to be parked in the drive, and it's right by the sidewalk, no fence. I *suspect* it was a punk-**s kid who thought it would be funny while waiting for the school bus at the stop across the street, but have no way to prove it (no security cams on the house.)
No kids there when I left, they start showing up around 6:30 and I was gone by 5:30 this morning...
OK, done venting.
That really sucks. Some day people just need to grow up a bit.
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
April 9, 2014 at 9:11 am
Sean Lange (4/9/2014)
Lynn Pettis (4/9/2014)
OMG!yuvipoy (4/9/2014)
I have been using this statement for nearly 6 years in prodution i did not get any error or issue.all of the sudden it happened today and i am unable to resolve the issue, still searching for the reason.
I am not sure which part of this is more scary, the fact that (s)he has been using NOLOCK through an ODBC connection for 6 years or that with at least 6 years experience (s)he doesn't have a better grasp of the language. :w00t:
Yeah that is a wee bit scary.:sick::crying:
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
April 9, 2014 at 12:30 pm
Adding and bumping topics in here: http://qa.sqlservercentral.com/Forums/Forum2824-1.aspx
Please don't commit to more than one and please don't add in random comments. I'd like to try and keep track of these articles.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 9, 2014 at 12:31 pm
Jack Corbett (4/9/2014)
SO this vendor is not willing to share code because it is "complex" sql. Basically everything is RBAR in so our database is "too big". The suggestions I made, not including changing the app code, took the process from 45 hours to 20 hours. The answer we got from them, because they had it running in 4 against our data on their server is throw more resources at it. So we doubled RAM (8-16) and CPU (4 cores to 8 cores) in our test environment to match their test environment (we are on a VM) and matched their results. So the process is now acceptable to the business folks. I'm still ticked that we got stuck with a crappy application.
Maybe a writeup will be cathartic? It would be interesting to have you mock and discuss the changes you made, and the alternative of cranking up hardware (with some cost estimate)
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 9, 2014 at 6:12 pm
Steve Jones - SSC Editor (4/9/2014)
Adding and bumping topics in here: http://qa.sqlservercentral.com/Forums/Forum2824-1.aspxPlease don't commit to more than one and please don't add in random comments. I'd like to try and keep track of these articles.
I tried to reply in the updated PARSENAME thread (but it wouldn't let me) because I thought WayneS had done that: http://qa.sqlservercentral.com/articles/PARSENAME/106755/
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
April 11, 2014 at 6:30 am
Some very nice words about some thread people and these forums in general:
http://qa.sqlservercentral.com/Forums/Topic1553867-364-1.aspx (at the end of the thread)
The highlight:
In general this board is the most friendly and active technical forum I use with very little flaming and enduring patience for noobs. Creds go out to all the users.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 11, 2014 at 6:53 am
Koen Verbeeck (4/11/2014)
Some very nice words about some thread people and these forums in general:http://qa.sqlservercentral.com/Forums/Topic1553867-364-1.aspx (at the end of the thread)
The highlight:
In general this board is the most friendly and active technical forum I use with very little flaming and enduring patience for noobs. Creds go out to all the users.
It is always humbling to be recognized by those we help. It is those few kind words that make the effort all the more worthwhile.
April 11, 2014 at 7:48 am
Lynn Pettis (4/11/2014)
Koen Verbeeck (4/11/2014)
Some very nice words about some thread people and these forums in general:http://qa.sqlservercentral.com/Forums/Topic1553867-364-1.aspx (at the end of the thread)
The highlight:
In general this board is the most friendly and active technical forum I use with very little flaming and enduring patience for noobs. Creds go out to all the users.
It is always humbling to be recognized by those we help. It is those few kind words that make the effort all the more worthwhile.
It'ss nice to hear that people appreciate it over time and not just their immediate problem. I never would have made it to the Integration Services forum, so thanks for sharing it.
April 14, 2014 at 5:27 am
I know there are many crazy stories about the weather from this year all over the world, but I have to share today's crazy forecast.
In Michigan, we're at 71 F now with winds at 23 MPH. Rain arrives later this morning. One inch of snow tonight and a low of 28 F. It was beautiful this past weekend and now we're at 71 F with snow tonight! It doesn't do this here very often. In spite of this unusually cold and snowy winter, I'm sure everyone will instantaneously forget how to drive at some point today or overnight. :w00t:
April 14, 2014 at 4:43 pm
Hmmm... http://qa.sqlservercentral.com/Forums/Topic1561455-146-1.aspx
Edit: Fixed link
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 14, 2014 at 4:53 pm
GilaMonster (4/14/2014)
Hmmm... qa.sqlservercentral.com/Forums/Topic1561455-146-1.aspx
Yeah looks like it was removed.
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
April 14, 2014 at 5:02 pm
SQLRNNR (4/14/2014)
GilaMonster (4/14/2014)
Hmmm... qa.sqlservercentral.com/Forums/Topic1561455-146-1.aspxYeah looks like it was removed.
No, I linked it wrong.
If you're going to be around a bit, could you watch that one and this one please?
http://qa.sqlservercentral.com/Forums/Topic1561627-1550-1.aspx
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 14, 2014 at 5:07 pm
GilaMonster (4/14/2014)
SQLRNNR (4/14/2014)
GilaMonster (4/14/2014)
Hmmm... qa.sqlservercentral.com/Forums/Topic1561455-146-1.aspxYeah looks like it was removed.
No, I linked it wrong.
If you're going to be around a bit, could you watch that one and this one please?
http://qa.sqlservercentral.com/Forums/Topic1561627-1550-1.aspx
Yup - I'll keep an eye on them.
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
April 16, 2014 at 1:57 pm
Ed Wagner (4/14/2014)
I know there are many crazy stories about the weather from this year all over the world, but I have to share today's crazy forecast.In Michigan, we're at 71 F now with winds at 23 MPH. Rain arrives later this morning. One inch of snow tonight and a low of 28 F. It was beautiful this past weekend and now we're at 71 F with snow tonight! It doesn't do this here very often. In spite of this unusually cold and snowy winter, I'm sure everyone will instantaneously forget how to drive at some point today or overnight. :w00t:
Sat in Denver it was 70F. I was out walking the dogs in shorts and a long sleeve T (I little windy). Sun I left and it was 35F and raining, with 6-10" of snow coming.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 15 posts - 43,696 through 43,710 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply