September 20, 2010 at 12:08 pm
Brandie Tarvin (9/20/2010)
He'll set us all to zero and make himself look like the Answer God!
That's an awesome idea for next April 1.
He should also change all our avatars for the day, Hawaiian shirts all round.
September 20, 2010 at 12:11 pm
Paul White NZ (9/20/2010)
Brandie Tarvin (9/20/2010)
He'll set us all to zero and make himself look like the Answer God!That's an awesome idea for next April 1.
He should also change all our avatars for the day, Hawaiian shirts all round.
Randomized Avatars based on different Hawaiian shirt patterns or beer bottle labels. @=)
September 20, 2010 at 12:17 pm
Paul White NZ (9/20/2010)
Brandie Tarvin (9/20/2010)
He'll set us all to zero and make himself look like the Answer God!That's an awesome idea for next April 1.
He should also change all our avatars for the day, Hawaiian shirts all round.
I could really see everybody suddenly looking like clones of Steve.
When he does that, he could simply display our counts as 0 and then add our points to his for the day.
I wonder what the fallout would be?
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
September 20, 2010 at 12:19 pm
I'm not sure I want to go to the trouble of finding that many Hawaiian images.
September 20, 2010 at 12:19 pm
For a moment, I thought our abused poster found another sock puppet. Given the font mistake and bad grammar...
http://www.sqlservercentral.com/Forums/Topic971846-357-1.aspx
September 20, 2010 at 12:20 pm
BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote connect items.
I have to admit that I'm not sure these are a huge win, or a hugely important add to SQL Server, but I'd like to know more. I think that the article makes a good case in the abstract, but it's hard to read and understand and I'd like to see more practical uses here that make a convincing case. Anyone got a good set of common things that they see, which would be improved with Window functions?
September 20, 2010 at 12:23 pm
Steve Jones - Editor (9/20/2010)
I'm not sure I want to go to the trouble of finding that many Hawaiian images.
My thinking was that all our avatars would be replaced by the same one - the one you had before your current (slightly scary) one.
September 20, 2010 at 1:47 pm
Is it just me, or are some of the misconceptions in this post regarding default values a little unnerving?
http://www.sqlservercentral.com/Forums/Topic989167-391-1.aspx
Log shipping, lock and latch use, proper syntax for setting a variable against an SSIS package at runtime... sure, things I'd expect most folks to not be familiar with... but a column default? *scratches head*
(And, no, I'm NOT talking about Lowell's or Gail's comments. 😉 )
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2010 at 1:55 pm
Not surprising. Defaults can be a touch confusing and I could see why this might be an issue.
September 20, 2010 at 2:08 pm
Steve Jones - Editor (9/20/2010)
Not surprising. Defaults can be a touch confusing and I could see why this might be an issue.
Heh, guess it's just me then. 🙂 Then again, I get a bit lost occassionally on stuff other people think is 'simple' so I probably should watch out for hue discussions between the pot and the kettle.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2010 at 3:06 pm
This misconception is one that I'm getting sick of addressing:
http://www.sqlservercentral.com/Forums/FindPost989783.aspx
Or should I say 'trying to address'
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
September 20, 2010 at 3:25 pm
GilaMonster (9/20/2010)
This misconception is one that I'm getting sick of addressing:http://www.sqlservercentral.com/Forums/FindPost989783.aspx
Or should I say 'trying to address'
groan
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
September 20, 2010 at 4:37 pm
You did a good job, and posted sample code that I was thinking to post as well. Good job, Gail.
September 20, 2010 at 8:53 pm
Steve Jones - Editor (9/20/2010)
BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote connect items.I have to admit that I'm not sure these are a huge win, or a hugely important add to SQL Server, but I'd like to know more. I think that the article makes a good case in the abstract, but it's hard to read and understand and I'd like to see more practical uses here that make a convincing case. Anyone got a good set of common things that they see, which would be improved with Window functions?
I don't know about these additional window function but I have really appreciated the window functions they added in sql 2005. When I first saw this note I thought you meant they were removing what they've already added in. Are the new proposed ones that important? I'm not sure but if you had asked me that about the ones they put in 2005 pre 2005 I probably would of said we don't need them. I'd rather see them further optimize what they currently have put into 2005 like making CTE's run better.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
September 20, 2010 at 8:57 pm
GilaMonster (9/20/2010)
This misconception is one that I'm getting sick of addressing:http://www.sqlservercentral.com/Forums/FindPost989783.aspx
Or should I say 'trying to address'
I've been addressing this and a few other backup strategies/misconceptions with our largest vendor at work for 9 months now. I've come to the conclusion that some people will hold onto misconceptions forever, no matter how logical the argument or how much documentation is presented or especially how wrong the person with the misconception is. I just try and keep a positive attitude and hope one day they'll finally get it.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Viewing 15 posts - 19,021 through 19,035 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply