August 11, 2015 at 12:10 pm
Lynn Pettis (8/11/2015)
Can't place the movie or show that came from, but love the editing!
Big Trouble in Little China.
"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
August 11, 2015 at 12:15 pm
Grant Fritchey (8/11/2015)
Lynn Pettis (8/11/2015)
Can't place the movie or show that came from, but love the editing!Big Trouble in Little China.
That was quick.
Nothing better than a whole hog chop SOM.
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
August 11, 2015 at 12:31 pm
SQLRNNR (8/11/2015)
Grant Fritchey (8/11/2015)
Lynn Pettis (8/11/2015)
Can't place the movie or show that came from, but love the editing!Big Trouble in Little China.
That was quick.
Nothing better than a whole hog chop SOM.
Those are cluster chops, been banned for years
😎
August 11, 2015 at 12:48 pm
Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.
August 11, 2015 at 12:52 pm
Steve Jones - SSC Editor (8/11/2015)
Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.
Would have been more if "someone" hadn't whacked it few months back, can't remember who it was but the name starts with............:-D
😎
August 11, 2015 at 1:23 pm
Eirikur Eiriksson (8/11/2015)
Steve Jones - SSC Editor (8/11/2015)
Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.Would have been more if "someone" hadn't whacked it few months back, can't remember who it was but the name starts with............:-D
😎
Oh the restored the thread after it was whacked. The points tied to the thread have yet to be restored.;-)
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
August 11, 2015 at 1:28 pm
SQLRNNR (8/11/2015)
Eirikur Eiriksson (8/11/2015)
Steve Jones - SSC Editor (8/11/2015)
Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.Would have been more if "someone" hadn't whacked it few months back, can't remember who it was but the name starts with............:-D
😎
Oh the restored the thread after it was whacked. The points tied to the thread have yet to be restored.;-)
Actually, makes sense to me that the points from The Thread would not be restored.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 11, 2015 at 1:30 pm
Alvin Ramard (8/11/2015)
SQLRNNR (8/11/2015)
Eirikur Eiriksson (8/11/2015)
Steve Jones - SSC Editor (8/11/2015)
Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.Would have been more if "someone" hadn't whacked it few months back, can't remember who it was but the name starts with............:-D
😎
Oh the restored the thread after it was whacked. The points tied to the thread have yet to be restored.;-)
Actually, makes sense to me that the points from The Thread would not be restored.
Agreed, in fact they probably shouldn't count at all.
_______________________________________________________________
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/
August 11, 2015 at 1:39 pm
Grant Fritchey (8/11/2015)
Lynn Pettis (8/11/2015)
Can't place the movie or show that came from, but love the editing!Big Trouble in Little China.
That is actually what I suspected but wasn't sure.
August 11, 2015 at 1:40 pm
Lynn Pettis (8/11/2015)
SQLRNNR (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
VARCHAR(1) and NVARCHAR(1) are my absolute favorite "stupid database design" problems. Seriously. Love them. I point and laugh and laugh. Weird how the database design people don't appreciate the humor.
I sort of get it when they allow NULL. I wouldn't design anything like that but I can understand where that comes from. But to allow variable length and force a single character just kills me. :-D:-D:-D
I especially love it when they use an NVARCHAR(1) to store a 0 or 1. Unfortunately, that's a real-life example.
It's not just an edge-case real life example either. I have seen something like this at just about every client I have had.
Using SQL Server, storing a 0,1, or null; sounds like a good use of the BIT data type to me.
Yes it does, doesn't it? You'd think it would be intuitive, but I guess it isn't to everyone. Like I said, Lynn, it's a real-life example. 🙁
Jason, I admit I'm surprised to hear you've seen others plagued with the same thing. I don't know whether to be happy or sad to know I'm not the only one to encounter it. Did they then set it to null and then ISNULL the column everywhere, just to make sure the non-SARGable predicate hurt performance as much as possible?
August 11, 2015 at 1:48 pm
Sean Lange (8/11/2015)
Alvin Ramard (8/11/2015)
SQLRNNR (8/11/2015)
Eirikur Eiriksson (8/11/2015)
Steve Jones - SSC Editor (8/11/2015)
Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.Would have been more if "someone" hadn't whacked it few months back, can't remember who it was but the name starts with............:-D
😎
Oh the restored the thread after it was whacked. The points tied to the thread have yet to be restored.;-)
Actually, makes sense to me that the points from The Thread would not be restored.
Agreed, in fact they probably shouldn't count at all.
While there is a lot of water cooler talk here, we see the same thing in many of the threads.
Then on the other hand, there is a lot of talk about things here that makes sense to have it here and to help each other in various manners.
I am not sure the points have any more or less weight from this thread than the QoTD points or the points from numerous threads where we continue to beg for more information.
In the end, they don't have any monetary value, so there is probably little to no harm counting them.
That said, Steve has a magic query that can help determine points from this thread so it can be excluded from total counts should anybody need to know their point counts.
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
August 11, 2015 at 1:52 pm
Ed Wagner (8/11/2015)
Lynn Pettis (8/11/2015)
SQLRNNR (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:
ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
VARCHAR(1) and NVARCHAR(1) are my absolute favorite "stupid database design" problems. Seriously. Love them. I point and laugh and laugh. Weird how the database design people don't appreciate the humor.
I sort of get it when they allow NULL. I wouldn't design anything like that but I can understand where that comes from. But to allow variable length and force a single character just kills me. :-D:-D:-D
I especially love it when they use an NVARCHAR(1) to store a 0 or 1. Unfortunately, that's a real-life example.
It's not just an edge-case real life example either. I have seen something like this at just about every client I have had.
Using SQL Server, storing a 0,1, or null; sounds like a good use of the BIT data type to me.
Yes it does, doesn't it? You'd think it would be intuitive, but I guess it isn't to everyone. Like I said, Lynn, it's a real-life example. 🙁
Jason, I admit I'm surprised to hear you've seen others plagued with the same thing. I don't know whether to be happy or sad to know I'm not the only one to encounter it. Did they then set it to null and then ISNULL the column everywhere, just to make sure the non-SARGable predicate hurt performance as much as possible?
Be sad knowing that your next gig will probably have the same sort of horse manure in it.
And in answer to the ISNULL question - My answer is NULL. Is that a yes? Maybe a no? Maybe a maybe? Or maybe all of the above.
Some places = yes, some places = no.
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
August 11, 2015 at 1:52 pm
Lynn Pettis (8/11/2015)
Ed Wagner (8/11/2015)
Alvin Ramard (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
I'm starting to wonder the same thing.
Would it be ok to suggest he have his boss contact me and I'll do it for a reasonable rate? Now he's asking for an Archive Delete Utility he can purchase.
Weak the force is. 🙁
I don't see why not. I've seen others do the same thing for other posts. Given the level of competence and sense of entitlement displayed thus far, however, I'd be cautious about investing a ton of time when you might not get paid.
BTW, I saw the most recent post, but I'm done.
I posted my suggested code. So far I got a thanks but no word as to whether or not he is using it or it works as he'd like.
Well I guess we now know who has the crystal ball. A simple "thanks" with no more code without questions? I think that means the problem is solved. Well done.
The comment about "missing the transaction" and loop *almost* made me post that the transaction was not what's really missing, but I was done. I had capitulated and let SSS (silver spoon syndrome) prevail. I don't want to take that approach with anyone, but it can be so very frustrating sometimes. Better than I just let it go.
Again, well done, sir.
August 11, 2015 at 1:55 pm
Just curious if anybody knows what a "SPAM DIG" happens to be? Is that like a clam dig?
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
August 11, 2015 at 1:58 pm
SQLRNNR (8/11/2015)
Sean Lange (8/11/2015)
Alvin Ramard (8/11/2015)
SQLRNNR (8/11/2015)
Eirikur Eiriksson (8/11/2015)
Steve Jones - SSC Editor (8/11/2015)
Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.Would have been more if "someone" hadn't whacked it few months back, can't remember who it was but the name starts with............:-D
😎
Oh the restored the thread after it was whacked. The points tied to the thread have yet to be restored.;-)
Actually, makes sense to me that the points from The Thread would not be restored.
Agreed, in fact they probably shouldn't count at all.
While there is a lot of water cooler talk here, we see the same thing in many of the threads.
Then on the other hand, there is a lot of talk about things here that makes sense to have it here and to help each other in various manners.
I am not sure the points have any more or less weight from this thread than the QoTD points or the points from numerous threads where we continue to beg for more information.
In the end, they don't have any monetary value, so there is probably little to no harm counting them.
That said, Steve has a magic query that can help determine points from this thread so it can be excluded from total counts should anybody need to know their point counts.
Personally I don't care about points. If anything I wish they were lower. That would indicate I have spent less time posting and more time working. :-D:-D:-D
_______________________________________________________________
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/
Viewing 15 posts - 50,071 through 50,085 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply