March 9, 2009 at 1:50 pm
Jack Corbett (3/9/2009)
K. Brian Kelley (3/9/2009)
"If you do not understand what this code is doing. DO NOT run it! You may end up locking yourself out of your own SQL Server."If everyone put disclaimers like that on their articles and scripts that would only leave the people who do not have backups to complain about?
Jack, remind me to send them your way.
K. Brian Kelley
@kbriankelley
March 9, 2009 at 1:56 pm
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSC
Top 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are sure to be the one to ask.
It's not a case of whether I know or not. Why do people assume that I'm willing to do personal, one-on-one consulting. Hell, I had someone ask me to walk them through installing a security fix today
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
March 9, 2009 at 2:00 pm
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSCTop 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are sure to be the one to ask.
It's not a case of whether I know or not. Why do people assume that I'm willing to do personal, one-on-one consulting. Hell, I had someone ask me to walk them through installing a security fix today
That's ok. Lynn volunteers to do that stuff anyway. Send them his way. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 2:05 pm
Bob Hovious (3/9/2009)
Gail, weren't you the person who observed that GROUP BY produces the same execution planas DISTINCT?
Yup. A group by on all columns in a resultset has the same exec plan as the query expressed without GROUP BY but with DISTINCT, with one exception, when there's a scalar UDF in the select clause
Could a guru weigh in on how a Group By could possibly produce non-distinct results with respect to the columns contained in the Group By clause?
As far as I'm aware, that's not possible. Group by means aggregate the result set with respect to the columns specified in the GROUP BY. In fact, Books Online states
Books Online
Groups a selected set of rows into a set of summary rows by the values of one or more columns or expressions. One row is returned for each group. Aggregate functions in the SELECT clause list provide information about each group instead of individual rows.
Does the person who posted that have an example? Would he perhaps like to give a reason why he is right and the product docs are wrong?
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
March 9, 2009 at 2:10 pm
Lynn Pettis (3/9/2009)
GSquared (3/9/2009)
Grant Fritchey (3/9/2009)
All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.That is too funny! Nearly choked on my sprite when I read that!
I'm glad I wasn't trying to take a drink as i read this either. :w00t:
I'm trying to eat supper while reading through this lot. Emphasis trying.
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
March 9, 2009 at 2:10 pm
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSCTop 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are sure to be the one to ask.
It's not a case of whether I know or not. Why do people assume that I'm willing to do personal, one-on-one consulting. Hell, I had someone ask me to walk them through installing a security fix today
I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.
March 9, 2009 at 2:14 pm
K. Brian Kelley (3/9/2009)
Speaking of jedi masters and padawans.... I think I'm going to add the following disclaimer to all my future security articles:"If you do not understand what this code is doing. DO NOT run it! You may end up locking yourself out of your own SQL Server.
Similar to the section I put in my recent corruption article. "If you're not sure what to do, get help."
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
March 9, 2009 at 2:20 pm
DavidB (3/9/2009)
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSCTop 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are sure to be the one to ask.
It's not a case of whether I know or not. Why do people assume that I'm willing to do personal, one-on-one consulting. Hell, I had someone ask me to walk them through installing a security fix today
That's ok. Lynn volunteers to do that stuff anyway. Send them his way. 🙂
Just remember that I charge $250.00(USD)/hr or part there of, including travel time to and from their site. Open to negotiation depending on the individual.
March 9, 2009 at 2:22 pm
Lynn Pettis (3/9/2009)
DavidB (3/9/2009)
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSCTop 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are sure to be the one to ask.
It's not a case of whether I know or not. Why do people assume that I'm willing to do personal, one-on-one consulting. Hell, I had someone ask me to walk them through installing a security fix today
That's ok. Lynn volunteers to do that stuff anyway. Send them his way. 🙂
Just remember that I charge $250.00(USD)/hr or part there of, including travel time to and from their site. Open to negotiation depending on the individual.
Do you accept payments via Paypal if it's online help?
😀
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]
March 9, 2009 at 2:23 pm
GilaMonster (3/9/2009)
Bob Hovious (3/9/2009)
Gail, weren't you the person who observed that GROUP BY produces the same execution planas DISTINCT?
Yup. A group by on all columns in a resultset has the same exec plan as the query expressed without GROUP BY but with DISTINCT, with one exception, when there's a scalar UDF in the select clause.
....
Does the person who posted that have an example? Would he perhaps like to give a reason why he is right and the product docs are wrong?
Had to group by something that wasn't appearing in the Select list. It's Brandi Tarvin who made that claim, and she actually backed it up with some examples. Not the usual stuff, but looked valid to me.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2009 at 2:32 pm
Lynn Pettis (3/9/2009)
I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.
Perhaps you should send back that your rates are $500/hour, payment in advance (bank wire or cashier's check accepted, no credit cards), a minimum of 10 hours (not to be refunded even if time spent is less), all work to be done outside of normal business hours when not involved with extra-curricular activites which include, but are not limited to, eating, sleeping, watching movies, coaching soccer, martial arts, reading, driving (can't have any accidents because you're doing SQL while driving), family time, walking the dog and/or other activities as defined by She Who Must Be Obeyed.
On second thought, someone might take you seriously if you did that.
-- Kit
March 9, 2009 at 2:35 pm
GSquared (3/9/2009)
Had to group by something that wasn't appearing in the Select list. It's Brandi Tarvin who made that claim, and she actually backed it up with some examples. Not the usual stuff, but looked valid to me.
Yeah, just read through it now. It's not that the group by was returning duplicate rows, it wasn't, but with only part of the group by clause being returned that wasn't obvious.
Definitely not a normal case.
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
March 9, 2009 at 2:35 pm
Alvin Ramard (3/9/2009)
Lynn Pettis (3/9/2009)
DavidB (3/9/2009)
GilaMonster (3/9/2009)
Lynn Pettis (3/9/2009)
You are one of the top 3 people on SSCTop 4 actually. Steve, Jeff and Remi are ahead
so they figure if anyone knows the answer you are sure to be the one to ask.
It's not a case of whether I know or not. Why do people assume that I'm willing to do personal, one-on-one consulting. Hell, I had someone ask me to walk them through installing a security fix today
That's ok. Lynn volunteers to do that stuff anyway. Send them his way. 🙂
Just remember that I charge $250.00(USD)/hr or part there of, including travel time to and from their site. Open to negotiation depending on the individual.
Do you accept payments via Paypal if it's online help?
😀
No. I WANT to travel to exotic locations. Plus, if I'm right, Mike is in England, and I'd love to go there again for a short trip. I had been stationed there years ago and would welcome a business reason to go back again.
Plus, charging for my time while going there and back is where I'll make my money. Based on some of the things we have all seen here, it wouldn't take long once on site. 😉
March 9, 2009 at 2:37 pm
Kit G (3/9/2009)
Lynn Pettis (3/9/2009)
I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.
Perhaps you should send back that your rates are $500/hour, payment in advance (bank wire or cashier's check accepted, no credit cards), a minimum of 10 hours (not to be refunded even if time spent is less), all work to be done outside of normal business hours when not involved with extra-curricular activites which include, but are not limited to, eating, sleeping, watching movies, coaching soccer, martial arts, reading, driving (can't have any accidents because you're doing SQL while driving), family time, walking the dog and/or other activities as defined by She Who Must Be Obeyed.
On second thought, someone might take you seriously if you did that.
I like!! :w00t:
March 9, 2009 at 2:38 pm
GSquared (3/9/2009)
GilaMonster (3/9/2009)
Bob Hovious (3/9/2009)
Gail, weren't you the person who observed that GROUP BY produces the same execution planas DISTINCT?
Yup. A group by on all columns in a resultset has the same exec plan as the query expressed without GROUP BY but with DISTINCT, with one exception, when there's a scalar UDF in the select clause.
....
Does the person who posted that have an example? Would he perhaps like to give a reason why he is right and the product docs are wrong?
Had to group by something that wasn't appearing in the Select list. It's Brandi Tarvin who made that claim, and she actually backed it up with some examples. Not the usual stuff, but looked valid to me.
As was said in that thread, the result IS distinct based on the Group By which is all SQL Server is going to do in the situation where your Group By has extra columns.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 15 posts - 2,431 through 2,445 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply