Proportional Fill

Question

Post reply

Proportional Fill

Steve Jones - SSC Editor

SSC Guru

Points: 736183
More actions
August 2, 2016 at 9:47 pm

#320330

Comments posted to this topic are about the item Proportional Fill
August 3, 2016 at 11:39 pm

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

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

Terje Hermanseter SSCarpal Tunnel Points: 4851 More actions · Answer 1

Good question early in the morning. Had to do some math to get the brain going.

BillLudlow SSCertifiable Points: 6553 More actions · Answer 2

BillLudlow

SSCertifiable

Points: 6553

August 3, 2016 at 12:57 am

#1893408

Brain obviously not going yet!

paul s-306273 SSChampion Points: 10730 More actions · Answer 3

Yes, did the maths and assumed 1.4 must be the answer.

Inspired guess really.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Interesting question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

david.gugg SSCertifiable Points: 6096 More actions · Answer 5

That was a good question. I assumed that the algorithm looked at the percentage free by file instead of the percentage of total space free on each file. Good to know I was confused!

Be still, and know that I am God - Psalm 46:10

Mighty SSCrazy Eights Points: 9063 More actions · Answer 6

The title of the question gave a small hint on what the answer had to be... 😀

webrunner SSC-Dedicated Points: 31862 More actions · Answer 7

Great question, thanks.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 8

Interesting question, thanks Steve. 🙂 With the maths I kind of got into a fight,

but at least I learned something new. 😉

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

Thank you for the post, Steve, really good one.

(I had read one blog some time back about adding multiple files to single file group claiming for some performance improvement; apart from that never tried or knew so much about this. This article link you posted 'http://www.sqlservercentral.com/articles/Filegroups/143571/" is really awesome. Now I am going through that practically step by step.)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Carl Landry Hall of Fame Points: 3903 More actions · Answer 10

If I'm not mistaken, does this only apply to auto-growth, right?