Minimal Config Restrictions

Question

Minimal Config Restrictions

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
April 12, 2017 at 10:58 pm

#77454

Comments posted to this topic are about the item Minimal Config Restrictions

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

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

TimCarrett Default port Points: 1484 More actions · Answer 1

Happy Easter Steve,

I would just like to say that you and all the guys at SQL Server Central do a great job. I look forward to the question of the day each morning and normally learn something new.

Have a great Easter

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 2

That is really intersting
learned something today, thanks Steve

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

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 3

About the "tempdb", here says that it is configured at the smallest possible size.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-with-minimal-configuration

George Vobr SSCrazy Eights Points: 9997 More actions · Answer 4

Carlo Romagnano - Thursday, April 13, 2017 2:19 AM
About the "tempdb", here says that it is configured at the smallest possible size.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-with-minimal-configuration

Interesting question. I found that when the SQL Server starts with a minimal configuration has a tempdb size of 1 MB for the data file and 0.5 MB for the log file.
See in "How to shrink the tempdb database in SQL Server".

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

Thanks for QOTD Steve.

When I suggested setting a DB to single user mode for applying a fix our DBAs refused, saying it would be too dangerous...

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 6

TimCarrett - Thursday, April 13, 2017 12:51 AM
Happy Easter Steve,
I would just like to say that you and all the guys at SQL Server Central do a great job. I look forward to the question of the day each morning and normally learn something new.
Have a great Easter

Thanks, Happy Easter

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

Revenant

SSC-Forever

Points: 42467

April 13, 2017 at 12:28 pm

#1938113

Interesting and straightforward - thanks, Steve!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

TimCarrett - Thursday, April 13, 2017 12:51 AM
Happy Easter Steve,
I would just like to say that you and all the guys at SQL Server Central do a great job. I look forward to the question of the day each morning and normally learn something new.
Have a great Easter

+1

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