In this chapter we will cover:
SQL Server provides one system stored procedure, named
SP_Configure, which helps you to manage the SQL Server instance-level configuration. A configuration comes with a default value, but based on the server, load on the server, and your own usage, you can change its default value to something else that can give you benefits from the performance point of view. Apart from the settings given in the
SP_Configure stored procedure, the type of instance (32 bit/64 bit) also affects ...