April 14, 2009 at 3:14 pm
Bruce W Cassidy (4/14/2009)
[font="Verdana"]I took a lesson from St Lynn. Not sure it will help, but worth a shot.[/font]
I'm not even sure what the question is any longer.
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, 2009 at 3:22 pm
GilaMonster (4/14/2009)
Bruce W Cassidy (4/14/2009)
[font="Verdana"]I took a lesson from St Lynn. Not sure it will help, but worth a shot.[/font]I'm not even sure what the question is any longer.
Not what it started as from what I can tell. Almost seems like the OP wants us to provide a hammer to tell someone else they aren't qualified to manage their own server and that they need to let a "real DBA" manage the system. When it would be better, as you and several others tried pointing out, to work with them and assist in the management of the system. Would build a better working relationship in my opinion.
April 14, 2009 at 3:35 pm
[font="Verdana"]Didn't RBarryYoung's article start a little bun fight! It will be fun to watch. Brave, brave man.[/font]
April 14, 2009 at 3:42 pm
Bruce W Cassidy (4/14/2009)
[font="Verdana"]Didn't RBarryYoung's article start a little bun fight! It will be fun to watch. Brave, brave man.[/font]
Looks like another "cursor man" out there if you ask me ( and I know you didn't 😉 ). Looks like a really good discussion developing in my opinion. Only one person really came out swinging hard at the beginning. The others seemed willing to see what may becoming in future installments, and a couple are willing to see if a set based solution can be built to replace a current cursor based solution.
April 14, 2009 at 3:53 pm
Lynn Pettis (4/14/2009)
Looks like a really good discussion developing in my opinion. Only one person really came out swinging hard at the beginning. The others seemed willing to see what may becoming in future installments, and a couple are willing to see if a set based solution can be built to replace a current cursor based solution.
[font="Verdana"]I just loved the people popping up and saying "yep, post your cursor code, we'll have a look at it!" Great to see that sort of support. :w00t:[/font]
April 14, 2009 at 9:17 pm
Bruce W Cassidy (4/14/2009)
Lynn Pettis (4/14/2009)
Looks like a really good discussion developing in my opinion. Only one person really came out swinging hard at the beginning. The others seemed willing to see what may becoming in future installments, and a couple are willing to see if a set based solution can be built to replace a current cursor based solution.[font="Verdana"]I just loved the people popping up and saying "yep, post your cursor code, we'll have a look at it!" Great to see that sort of support. :w00t:[/font]
I was really glad to see it! I was ready for a challenge, but I sure didn't want to be left alone with that much challenge!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 14, 2009 at 9:20 pm
Bruce W Cassidy (4/14/2009)
[font="Verdana"]Didn't RBarryYoung's article start a little bun fight! It will be fun to watch. Brave, brave man.[/font]
Brave. Stupid. It's a fine line. :w00t:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 15, 2009 at 1:06 am
Anyone feel up to this?
http://www.sqlservercentral.com/Forums/Topic696402-146-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 15, 2009 at 1:51 am
Anyone feel up to this?
I was thinking of "Neither, it's Microsoft Standard" 😛
But then thats just the cynic in me 😉
Honestly, I'd like to, and state it's close to ANSI but not sure what sort of dialogue it would produce.
I think I will leave it up to you experts :blush:
Far away is close at hand in the images of elsewhere.
Anon.
April 15, 2009 at 2:06 am
Well, SQL does support the ASCII standard for storing character data (char and varchar) and it supports some of the ANSI SQL standards (of multiple different years), so you could argue for "both" or "both, partially" as answers
I suspect the problem's a bit deeper though and that the OP there doesn't know what the ASCII standard (or even ANSI standards) is. So it probably needs more than a yes or no type answer.
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 15, 2009 at 2:21 am
So it probably needs more than a yes or no type answer.
That is why I was hesitant to answer
Maybe it's of of those Jeff answers 'It Depends' :w00t:
Far away is close at hand in the images of elsewhere.
Anon.
April 15, 2009 at 5:29 am
GilaMonster (4/15/2009)
Well, SQL does support the ASCII standard for storing character data (char and varchar) and it supports some of the ANSI SQL standards (of multiple different years), so you could argue for "both" or "both, partially" as answersI suspect the problem's a bit deeper though and that the OP there doesn't know what the ASCII standard (or even ANSI standards) is. So it probably needs more than a yes or no type answer.
And yet, I just gave him one. What the hell.
"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
April 15, 2009 at 6:07 am
Grant Fritchey (4/15/2009)
GilaMonster (4/15/2009)
Well, SQL does support the ASCII standard for storing character data (char and varchar) and it supports some of the ANSI SQL standards (of multiple different years), so you could argue for "both" or "both, partially" as answersI suspect the problem's a bit deeper though and that the OP there doesn't know what the ASCII standard (or even ANSI standards) is. So it probably needs more than a yes or no type answer.
And yet, I just gave him one. What the hell.
You left out one of the I's on ASCII. Normally I wouldn't nitpick something so small, but I suspect that it'll confuse the OP even more than he already is.
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 15, 2009 at 6:55 am
GilaMonster (4/15/2009)
You left out one of the I's on ASCII.
Story of my life.
"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
April 15, 2009 at 6:58 am
I posted a simplified explanation of each. Hopefully it's neither too simplified nor not simplified enough. Hard to judge that sometimes in these cases.
- 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
Viewing 15 posts - 3,391 through 3,405 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply