Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,2804,2814,2824,2834,284»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Wednesday, February 5, 2014 10:44 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:25 PM
Points: 35,372, Visits: 31,925
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!


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1538472
Posted Thursday, February 6, 2014 1:14 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 8:45 AM
Points: 1,470, Visits: 8,373


Nah. Too expensive. Beans for breakfast will do it. Just don't wanna ever smoke while the agitator is in action. BOOM!

http://www.bbc.co.uk/news/world-europe-25922514


BrainDonor
Linkedin
Blog Site
Post #1538504
Posted Thursday, February 6, 2014 1:22 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 8:45 AM
Points: 1,470, Visits: 8,373
Revenant (2/5/2014)
Sean Lange (2/5/2014)
[quote]SQLRNNR (2/5/2014)
[quote]

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.


BrainDonor
Linkedin
Blog Site
Post #1538505
Posted Thursday, February 6, 2014 2:20 PM This worked for the OP Answer marked as solution
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:13 AM
Points: 1,034, Visits: 6,813
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...



Low-hanging fruit picker and defender of the moggies





For better assistance in answering your questions, please read this.




Understanding and using APPLY, (I) and (II) Paul White

Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Post #1538864
Posted Thursday, February 6, 2014 2:26 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:24 PM
Points: 3,784, Visits: 8,489
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.



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1538867
Posted Thursday, February 6, 2014 2:40 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 1:04 PM
Points: 13,086, Visits: 12,553
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1538875
Posted Thursday, February 6, 2014 2:40 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:42 AM
Points: 13,295, Visits: 11,086
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1538876
Posted Thursday, February 6, 2014 2:42 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 6:00 PM
Points: 17,825, Visits: 15,758
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
Post #1538878
Posted Thursday, February 6, 2014 2:46 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 11:18 AM
Points: 843, Visits: 7,381
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
Post #1538885
Posted Thursday, February 6, 2014 2:46 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 3:20 PM
Points: 363, Visits: 2,528
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!
Post #1538886
« Prev Topic | Next Topic »

Add to briefcase «««4,2804,2814,2824,2834,284»»»

Permissions Expand / Collapse