April 7, 2011 at 12:27 pm
jcrawf02 (4/7/2011)
Stefan Krzywicki (4/7/2011)
jcrawf02 (4/7/2011)
Brandie Tarvin (4/7/2011)
I got my parents copies of The Shadow radio show for their anniversary many years back. They loved it. It was one of those things they'd listen to when they were kids.Apparently a lot of that stuff is available in CD collections if you know where to look.
www.signals.com has a lot of them through PBS, or ask my dad 😛 he trolls the library of congress a lot too.
Me, I've actually PLAYED with the Jimmy Dorsey band. (I'm ignoring the fact that Jimmy wasn't leading it, but the guy taking the lead actually did tour with him)
Now I have to go listen to some Dizzy...
What do you play?
It annoys me sometimes that the Glenn Miller Orchestra and the Jimmy Dorsey band still tour even though the bandleaders are long dead. But I suppose taking the name of the actual bandleader would cut attendance, or at least they think it would, and if they aren't creating any new tunes or arrangements then I guess there's no point in renaming the band.
Trombone, although I'm out of practice now.
Popped in my Dizzy CD, remembered that I got to play with Clark Terry when I was in school, that was amazing. And then some scumbag stole his flugel! luckily we found it in a pawn shop down the street a week or so later, but he lost his case.
Awesome that you got to play with the Jimmy Dorsey Orchestra and Clark Terry. When I was in school I was given a choice between trumpet and math (band and math were at the same time) and I chose math. Ah well. I sing, but don't play any instruments.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 7, 2011 at 12:30 pm
GSquared (4/7/2011)
Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).San's making the classical mistake of thinking that guards/audits are automatically self-monitoring if the thing they monitor is guarded/audited. Or he's got his ego tied up in the answer he gave. Either case is possible.
I suspect the latter. Like http://www.sqlservercentral.com/Forums/FindPost1048785.aspx
Oh the logical fallacies in the latest reply. But am not getting into that. I have no desire to start a fight that isn't winnable.
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 7, 2011 at 12:47 pm
GilaMonster (4/7/2011)
GSquared (4/7/2011)
Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).San's making the classical mistake of thinking that guards/audits are automatically self-monitoring if the thing they monitor is guarded/audited. Or he's got his ego tied up in the answer he gave. Either case is possible.
I suspect the latter. Like http://www.sqlservercentral.com/Forums/FindPost1048785.aspx
Oh the logical fallacies in the latest reply. But am not getting into that. I have no desire to start a fight that isn't winnable.
I like Hugo's latest reply.
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 7, 2011 at 12:53 pm
CirquedeSQLeil (4/7/2011)
GilaMonster (4/7/2011)
GSquared (4/7/2011)
Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).San's making the classical mistake of thinking that guards/audits are automatically self-monitoring if the thing they monitor is guarded/audited. Or he's got his ego tied up in the answer he gave. Either case is possible.
I suspect the latter. Like http://www.sqlservercentral.com/Forums/FindPost1048785.aspx
Oh the logical fallacies in the latest reply. But am not getting into that. I have no desire to start a fight that isn't winnable.
I like Hugo's latest reply.
What's the bet that he'll go and show that the original operation in the user database (the one that resulted in rows needing to go into the version store) are logged?
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 7, 2011 at 1:08 pm
GilaMonster (4/7/2011)
CirquedeSQLeil (4/7/2011)
GilaMonster (4/7/2011)
GSquared (4/7/2011)
Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).San's making the classical mistake of thinking that guards/audits are automatically self-monitoring if the thing they monitor is guarded/audited. Or he's got his ego tied up in the answer he gave. Either case is possible.
I suspect the latter. Like http://www.sqlservercentral.com/Forums/FindPost1048785.aspx
Oh the logical fallacies in the latest reply. But am not getting into that. I have no desire to start a fight that isn't winnable.
I like Hugo's latest reply.
What's the bet that he'll go and show that the original operation in the user database (the one that resulted in rows needing to go into the version store) are logged?
Odds are in your favor on that one - couldn't bet against it right now.
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 7, 2011 at 2:59 pm
Craig Farrell (4/5/2011)
SQLDCH (4/5/2011)
CirquedeSQLeil (4/5/2011)
Can anybody else lend a hand here?Aye, we're doing our best =)
Going for sainthood, you two? I'm not sure there's much I could add to that, except for "Let me repeat this until you understand it."
I'm rather glad Jeffrey Williams stepped in. He has described what goes on much better than I could, and maybe she has now got it.
Tom
April 7, 2011 at 3:10 pm
Tom.Thomson (4/7/2011)
Craig Farrell (4/5/2011)
SQLDCH (4/5/2011)
CirquedeSQLeil (4/5/2011)
Can anybody else lend a hand here?Aye, we're doing our best =)
Going for sainthood, you two? I'm not sure there's much I could add to that, except for "Let me repeat this until you understand it."
I'm rather glad Jeffrey Williams stepped in. He has described what goes on much better than I could, and maybe she has now got it.
Yes it seems that way.
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 7, 2011 at 3:11 pm
Craig Farrell (4/5/2011)
On another topic. Anyone out there know of a site or something that will help me compute what the storage length is for different numeric/decimal combinations? I'm having an argument with FLOAT right now.This is the best I've found so far but I'd like to see some corroboration. This seems too easy:
Length: The specified precision plus 2. For example,
the length of DECIMAL(12, 3) is 14 bytes. The two
additional bytes are used for the sign and the
decimal points because functions return this data type
as a character string.
Looks like total gibberish to me. I guess if you have a function that returns a numeric or decimal as a character string that's how long the string is (provided it's varchar, not nvarchar) but that's nothing to do with the storage length for those types.
The storage length for decimal and nummeric depends on the precision, as follows
Precision Length(bytes)
up to 9 5
10 to 19 9
20 to 28 13
29 to 38 17
For FLOAT(N) the storage length is 4 bytes for N less than 25, 8 bytes for N greater than 24. REAL is just a name for FLOAT(24).
Tom
April 7, 2011 at 3:16 pm
Brandie Tarvin (4/6/2011)
Scooby Doo is almost as old as I am. No cheating and looking it up now. Take a wild guess how long this property has been around.
YGLF! You're almost quarter of a century younger than I am.
Tom
April 7, 2011 at 3:33 pm
Tom.Thomson (4/7/2011)
Brandie Tarvin (4/6/2011)
Scooby Doo is almost as old as I am. No cheating and looking it up now. Take a wild guess how long this property has been around.YGLF! You're almost quarter of a century younger than I am.
Ye Gads Learned Female?
Or is that Gaelic again?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 7, 2011 at 4:54 pm
WayneS (4/7/2011)
So, what did you'll think of the QotD? I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to be coming from those looking to bash the QotD, but there are some that will rip a QotD apart that are saying it was good (like Hugo). Just ignoring the griping...
I think it was a great question.
I screwed up on it - ought to have got it right, but went for the "everything is logged" option - I should have known better, I was designing lock managers and transactional recovery systems for my living a long time ago, including optimistic locking schemes.
Tom
April 7, 2011 at 5:03 pm
GilaMonster (4/7/2011)
CirquedeSQLeil (4/7/2011)
GilaMonster (4/7/2011)
GSquared (4/7/2011)
Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).San's making the classical mistake of thinking that guards/audits are automatically self-monitoring if the thing they monitor is guarded/audited. Or he's got his ego tied up in the answer he gave. Either case is possible.
I suspect the latter. Like http://www.sqlservercentral.com/Forums/FindPost1048785.aspx
Oh the logical fallacies in the latest reply. But am not getting into that. I have no desire to start a fight that isn't winnable.
I like Hugo's latest reply.
What's the bet that he'll go and show that the original operation in the user database (the one that resulted in rows needing to go into the version store) are logged?
That's exactly what he's been saying all along, while trying to pretend it means that data affecting the version store is logged.
Tom
April 7, 2011 at 5:08 pm
jcrawf02 (4/7/2011)
Tom.Thomson (4/7/2011)
Brandie Tarvin (4/6/2011)
Scooby Doo is almost as old as I am. No cheating and looking it up now. Take a wild guess how long this property has been around.YGLF! You're almost quarter of a century younger than I am.
Ye Gads Learned Female?
Or is that Gaelic again?
Neither. The acronym for something that used to be a common English exclamation of surprise: "Ye Gods and Little Fishes". (The surprise was that I had to write "almost" insted of "much more than".)
Tom
April 8, 2011 at 5:46 am
WayneS (4/7/2011)
So, what did you'll think of the QotD? I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to be coming from those looking to bash the QotD, but there are some that will rip a QotD apart that are saying it was good (like Hugo). Just ignoring the griping...
I thought it was well done. I had it down to 2 possibilities from the beginning - the version store or None. And then I started to overthink the question. I didn't know much about the version store before that question (I know just a bit more now!), but even though I couldn't find anything that said there was logging involved, and even though logging operations on it would seem counter-intuitive, I decided that I probably just wasn't doing enough research and that there was probably some odd log entry that got made - solely because of the 'truncate table' answer (that one I *knew* was there to trip people up!)
So I guessed, and hit the 50% chance of being wrong. Doesn't matter - I learned a lot about something I really hadn't dug into before in the process, and that's the entire point of the QotD.
Frankly, I learn more when I get a QotD wrong than when I get it right. The points are meaningless - the knowledge, on the other hand, is priceless.
Thanks for making us think.
-Ki
April 8, 2011 at 6:41 am
Kiara (4/8/2011)
Frankly, I learn more when I get a QotD wrong than when I get it right. The points are meaningless - the knowledge, on the other hand, is priceless.
Awesome - I love that attitude. 😀
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 15 posts - 25,516 through 25,530 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply