Change the Configuration Settings for a Database - SQL Server
Jan 22, 2024 · This topic describes how to change database-level options in SQL Server by using SQL Server Management Studio or Transact-SQL. These options are unique to each database and do not …
SQL Server Best Practices and Configurations - SQLyard
Mar 28, 2025 · To enable LPIM, grant the SQL Server service account permission to ‘Lock Pages in Memory’ in the Local Security Settings. SQL Server Enterprise Edition can utilize large memory …
SQL Server Configuration Settings Query
Jul 10, 2019 · In this tip I’m going to present a query that provides several important values about SQL Server that can give you a rough overview of the server configuration.
How to View your Current SET Options in SQL Server
Sep 5, 2024 · SQL Server provides various SET options that control the behavior of our session. These options can impact query execution and results. Also, some features in SQL Server rely on certain …
How to Document and Configure SQL Server Instance Settings
Jan 30, 2012 · In this article I’ll show you how to easily collect this information, and I am going to explain what each setting does and the best way they typically should be configured. Of course, there is no …
SQL Server Auto-settings: The Good, the Bad, and the Ugly
Jul 9, 2025 · Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL Server database and just left the default settings alone, you’re not alone. Microsoft provides a...
Instance And Database Settings In SQL Server
May 6, 2023 · SQL Server Instance Settings refer to the configurations that are applied at the server level and affect the behavior of all databases running on that instance. These settings include things …
Understanding SQL Server Configuration Settings
Sep 14, 2017 · In this article, we will explore some of the commonly used configuration settings and how they can impact your SQL Server environment. Each session in SQL Server has its own set of …
How to use SQL Server Configuration Manager
SQL Server configuration manager is a tool provided by Microsoft SQL Server. When we install SQL Server, it is installed automatically. It is used for the following purposes. The SQL Server …
View or Change Server Properties (SQL Server) - SQL Server
Aug 26, 2025 · Learn how to use SQL Server Management Studio, Transact-SQL, or SQL Server Configuration Manager to view or change the properties of an instance of SQL Server.