Extent

Question

Post reply

Extent

kapfundestanley

SSCertifiable

Points: 5637
More actions
May 19, 2017 at 12:10 am

#323556

Comments posted to this topic are about the item Extent
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

HappyGeek

SSCoach

Points: 18729

May 19, 2017 at 2:04 am

#1943237

Nice easy one to end the week on, thank you.

...

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

Nice straight forward question but there was no reference. It looks like the author was attempting post a link. For anybody who so desires here is a link to BOL on the topic. https://technet.microsoft.com/en-us/library/ms190969.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/

Revenant SSC-Forever Points: 42467 More actions · Answer 3

Nice and straightforward. However, note that this does not apply to Azure which handles blobs and does it differently.

Thanks for the question, Stanley!

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

A simple one to end the week. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 5

Easy to remember:
* 8 bits to a byte
* 8 KB to a page
* 8 pages to an extent
"Crazy Eights"
Hmmm... Where have I heard that before?

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 6

Revenant - Friday, May 19, 2017 8:03 AM
Nice and straightforward. However, note that this does not apply to Azure which handles blobs and does it differently.
Thanks for the question, Stanley!

Thanks,for the insight.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Stewart "Arturius" Campbell SSC Guru Points: 72629 More actions · Answer 7

Nice, easy question, thanks Stanley

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”