February 5, 2014 at 10:44 pm
SQLRNNR (2/5/2014)
Jeff Moden (2/5/2014)
SQLRNNR (2/5/2014)
dwain.c (2/5/2014)
Jeff Moden (2/5/2014)
ChrisM@Work (2/4/2014)
He's calling summer on one sighting of a swallow.He should come to Michigan. It was snowing to beat the band a couple of days ago and I had a Robin stop by the heated bird bath. Robins are normally the first sign of spring in Michigan. I guess that one didn't read BOL. π
A heated bird bath? Guess you'll be featured prominently in the next edition of Lifestyles of the Rich and Famous!
The Rich and Famous Santa Claus
BWAA-HAAA!!!! Too funny! Nah... it does't cost that much. Debbie has one of those ceeeement birdbaths and I bought one of those small electric heaters that farmers put in cow watering troughs to keep the water from freezing in the winter. They keep the water at about 40oF. It's real overkill for a bird bath (designed for 100 gallon cow troughs) but it works and it doesn't cost much to run. It has a thermostat built into it. It's designed to be fully submersible.
Hmmm... maybe I should buy a cow trough and 4 of those heaters to make a poor man's hot tub. With as fat as I've gotten, there wouldn't be much water left in a 100 gallon trough so they wouldn't have to work very hard. π
Hmmm hot tub. Hillbilly style.
Now what about the bubbles? Alka seltzer?
Nah. Too expensive. Beans for breakfast will do it. π Just don't wanna ever smoke while the agitator is in action. BOOM! :hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.
February 6, 2014 at 1:14 am
Nah. Too expensive. Beans for breakfast will do it. π Just don't wanna ever smoke while the agitator is in action. BOOM! :hehe:
February 6, 2014 at 1:22 am
Revenant (2/5/2014)
Sean Lange (2/5/2014)
SQLRNNR (2/5/2014)
Those are the days we will forget when our children grow up. π
And they grow up so fast... π
They certainly age fast, but grow up - I'm not so sure. And I know my parents think the same thing. Our eldest is 30 this year and I still the teenager that he was when we met (I'm his step-father). My wife still occasionally sees the toddler.
February 6, 2014 at 2:20 pm
A good friend used to regularly have a little moan about how little sex he was having with his girlfriend. "Once a fortnight - it's doing my head in!" Then one afternoon he called me up for a pint after work. "I know it's not good form, but I overheard her on the phone with one of her mates" he said. This is what he overheard his girlfriend telling her mate: "I have sex with him and he's happy and affectionate, like a puppy - and it's lovely. If I have sex with him again the same week, everybody notices he's happy and affectionate and suddenly he's the life and soul of the party and I'm left in the corner. I hate it! It puts me off sex for a whole month!"
Could anything be simpler, more black and white, than a tick in a box? Heh - could anything be more complicated...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
February 6, 2014 at 2:26 pm
There seems to be a new feature in the forums to mark answers that worked for the OP.
What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
February 6, 2014 at 2:40 pm
Luis Cazares (2/6/2014)
There seems to be a new feature in the forums to mark answers that worked for the OP.What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
Let's find out. I created us a test question here. http://www.sqlservercentral.com/Forums/Topic1538872-61-1.aspx
_______________________________________________________________
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/
February 6, 2014 at 2:40 pm
Luis Cazares (2/6/2014)
There seems to be a new feature in the forums to mark answers that worked for the OP.What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
Haven't seen it yet. Can you only do this if you started the topic? (and if yes, who is ever going to mark this thread as answered???)
I think it is a nice feature. I just hope we don't get parrots like in the MSDn forums who are just hoping to get their post marked as the answer.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 6, 2014 at 2:42 pm
Now that an answer or post can be marked as useful and accurate by the OP, I hope that it catches on and people start using it more. I have seen only one thread today with an answer accepted.
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
February 6, 2014 at 2:46 pm
Sean Lange (2/6/2014)
Luis Cazares (2/6/2014)
There seems to be a new feature in the forums to mark answers that worked for the OP.What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
Let's find out. I created us a test question here. http://www.sqlservercentral.com/Forums/Topic1538872-61-1.aspx
Apparently, yes. You can only mark it if you started it.
--------------------------------------
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
February 6, 2014 at 2:46 pm
GilaMonster (2/4/2014)
Evil Kraig F (2/4/2014)
The Oracle mechanism of the physical addressing is a signficant improvement because it removes all translation structures for row recovery from the non-clustered lookup upon finding the correct values. With a RID, you still need to do a lookup form because you have to locate where the File/Page/Slot is on the drive, and then you can perform your I/O. Clustered index or RID, you still lose that optimization path, so it's moot... no?I have no idea how Oracle works.
With a physical RID, SQL has to just ask the OS for an 8k read at offset 8192*PageNumber in the file identified by File ID (assuming it's not in memory)
With a clustered index key, it has to query the metadata to locate the root page for that index, read that page, crack the page, read the rows to identify which page is needed in the level below. Fetch that page, Repeat until the leaf page is read.
From a bit of reading, it seems like Oracle has the ability to make block requests from attached block devices (local or network) with its "Automatic Storage Management", whereas Microsoft SQL Server uses regular old ntfs file system access through the api. Oracle then has the opportunity to skip a level of indirection here.
Happy to be corrected however!
February 6, 2014 at 2:46 pm
Koen Verbeeck (2/6/2014)
Luis Cazares (2/6/2014)
There seems to be a new feature in the forums to mark answers that worked for the OP.What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
Haven't seen it yet. Can you only do this if you started the topic? (and if yes, who is ever going to mark this thread as answered???)
I think it is a nice feature. I just hope we don't get parrots like in the MSDn forums who are just hoping to get their post marked as the answer.
I'd have to ask more questions myself in order to use this new feature more.
In all of my time on this site, I think I asked less than 10 questions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 6, 2014 at 2:47 pm
Stefan Krzywicki (2/6/2014)
Sean Lange (2/6/2014)
Luis Cazares (2/6/2014)
There seems to be a new feature in the forums to mark answers that worked for the OP.What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
Let's find out. I created us a test question here. http://www.sqlservercentral.com/Forums/Topic1538872-61-1.aspx
Apparently, yes. You can only mark it if you started it.
i wonder if that means we will start seeing forum moderators here beyond the crew at RG.
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
February 6, 2014 at 2:48 pm
Koen Verbeeck (2/6/2014)
Koen Verbeeck (2/6/2014)
Luis Cazares (2/6/2014)
There seems to be a new feature in the forums to mark answers that worked for the OP.What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
Haven't seen it yet. Can you only do this if you started the topic? (and if yes, who is ever going to mark this thread as answered???)
I think it is a nice feature. I just hope we don't get parrots like in the MSDn forums who are just hoping to get their post marked as the answer.
I'd have to ask more questions myself in order to use this new feature more.
In all of my time on this site, I think I asked less than 10 questions.
I think I have asked less than 5 questions.
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
February 6, 2014 at 2:50 pm
SQLRNNR (2/6/2014)
Koen Verbeeck (2/6/2014)
Koen Verbeeck (2/6/2014)
Luis Cazares (2/6/2014)
There seems to be a new feature in the forums to mark answers that worked for the OP.What do you think about this? I'm not sure if it's only possible to mark one answer or multiple answers. This seems to be common practice in other forums as I've been asked in the past about this feature.
Haven't seen it yet. Can you only do this if you started the topic? (and if yes, who is ever going to mark this thread as answered???)
I think it is a nice feature. I just hope we don't get parrots like in the MSDn forums who are just hoping to get their post marked as the answer.
I'd have to ask more questions myself in order to use this new feature more.
In all of my time on this site, I think I asked less than 10 questions.
I think I have asked less than 5 questions.
Showoff π
edit: it's not because we are smarter, but because we know this site called "google" π :hehe:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 6, 2014 at 2:50 pm
SQLRNNR (2/6/2014)
Now that an answer or post can be marked as useful and accurate by the OP, I hope that it catches on and people start using it more. I have seen only one thread today with an answer accepted.
Here is one...and it even has two posts marked. π
http://www.sqlservercentral.com/Forums/Topic1538410-392-1.aspx
_______________________________________________________________
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 - 42,811 through 42,825 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply