SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reserved Space


Reserved Space

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)

Group: Administrators
Points: 651181 Visits: 21472
Comments posted to this topic are about the item Reserved Space

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (936K reputation)SSC Guru (936K reputation)SSC Guru (936K reputation)SSC Guru (936K reputation)SSC Guru (936K reputation)SSC Guru (936K reputation)SSC Guru (936K reputation)SSC Guru (936K reputation)

Group: General Forum Members
Points: 936039 Visits: 49079
Heh... but "diskspace is cheap", right? (One of my least favorite justifications for not fixing bad code or process).

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

When you put the right degree of spin on it, the number 318 is also a glyph that describes the nature of a DBAs job. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
dsor
dsor
Mr or Mrs. 500
Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)

Group: General Forum Members
Points: 559 Visits: 778
I don't have an issue with reserving space for updates. Provided the space consumed remains constant(not counting user data) over the lifetime of the product no matter how many mandatory updates you install.
VeritableHero
VeritableHero
SSC Veteran
SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)

Group: General Forum Members
Points: 252 Visits: 271
Regarding the last paragraph of the post:
I know modern Android helps me when I'm low on space, and would like to see that in Windows.

Just this weekend I used the Free up space now option under Storage settings in Windows 10. That's a step in the right direction.

Here is a link that talks about it. Link to HowToGeek

I haven't heard of reserving space with dummy files before today. (Granted, I'm still new at this.) That's an interesting idea if admin that handles storage isn't around to assist.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)

Group: Administrators
Points: 651181 Visits: 21472
VeritableHero - Wednesday, January 30, 2019 6:20 AM
I haven't heard of reserving space with dummy files before today. (Granted, I'm still new at this.) That's an interesting idea if admin that handles storage isn't around to assist.

Thanks for the link, and often the admin might be around, but adding storage or changing this isn't simple or allowed. It's also a place to quickly make a mistake under pressure.

I used to keep 4-5GB around. Now I keep 10-20, just in case.


Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
jay-h
jay-h
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17163 Visits: 2830
the phrase 'junk grows to fill the available space' applies as much to computer resources as it does to basements. And as the amount of junk gets larger, so does the amount of stuff we don't even remember what it's for. Then cleaning up gets even harder.

...

-- FORTRAN manual for Xerox Computers --
Eric M Russell
Eric M Russell
SSC Guru
SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)

Group: General Forum Members
Points: 117275 Visits: 15446
... My other hope is that we get quantum, PB sized storage devices that can fit in our phone. I can't ever remember anyone on Star Trek running out of storage space on their drives. I look forward to the day in my life when that won't happen to me...


Steve,
I'm curious about how you would use that PB of storage on your phone. I'm not sure if using our phones to archive every photo album, email, and download is a good idea. If someone steals my phone, I'd like them to be limited to only the last few weeks worth of cached data. Apple and Microsoft cloud storage is fairly inexpensive with virtually no limit on scalability, and I assume we're all backing up to the cloud anyhow.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Eric M Russell
Eric M Russell
SSC Guru
SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)

Group: General Forum Members
Points: 117275 Visits: 15446
Regarding mssql storage, if there is only one large database on the server, then managing space is relatively simple, just give it plenty of space and then initialize the data and log files to fill what's available. But what's really problematic is when there are several large databases sharing the same log and data drives, and because of end user patterns, each can grow unexpectedly. That is perhaps the scenario where creating a stub file can come in handy.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Ralph Hightower
Ralph Hightower
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2468 Visits: 1498

My wife bought me a new PC last year. It came with a 256 GB SSD as the system disk. With Microsoft Office and Adobe Lightroom and Photoshop and some other useful utilities, there was not enough room to Microsoft Visual Studio 2017. During Christmas week 2018, I upgraded the drive to a 1 TB SSD. It may be overkill, but it was fairly inexpensive. I'm enjoying the speed of using an SSD.
Hopefully, my work computer will be upgraded to one with an SSD.


Steve Jones
Steve Jones
SSC Guru
SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)SSC Guru (651K reputation)

Group: Administrators
Points: 651181 Visits: 21472
Eric M Russell - Thursday, January 31, 2019 6:54 AM
... My other hope is that we get quantum, PB sized storage devices that can fit in our phone. I can't ever remember anyone on Star Trek running out of storage space on their drives. I look forward to the day in my life when that won't happen to me...


Steve,
I'm curious about how you would use that PB of storage on your phone. I'm not sure if using our phones to archive every photo album, email, and download is a good idea. If someone steals my phone, I'd like them to be limited to only the last few weeks worth of cached data. Apple and Microsoft cloud storage is fairly inexpensive with virtually no limit on scalability, and I assume we're all backing up to the cloud anyhow.


For me, having pictures and video of life are what I want. Is this a potential issue? Sure. I'm hoping security keeps getting better. I have remote wipe available, so I can do that if I know the phone is gone. I don't consider most pictures to be security issues, at least, not how I use my phone.

I'm often without connectivity in places. So I'd like to have stuff available at times, but more importantly, not have issues recording new stuff.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search