What is Lock Pages in Memory? It keeps data in physical RAM instead of paging it to disk, and here is the gotcha and how to enable it step by step.
How to Identify Process ID for SQL Server Services? – Interview Question of the Week #185
How do you find the Process ID for SQL Server services? One quick query on sys.dm_server_services returns the process id, status, last startup time and account.
How to Check Status of Instant File Initialization? – Interview Question of the Week #184
Here are two quick ways to check status of Instant File Initialization: read the error log, or query sys.dm_server_services on SQL Server 2016 and later.
How Old Version of SQL Server Running on Server? – Interview Question of the Week #183
Is your server on an old version of SQL Server? Run SELECT @@VERSION to see the build and the date the patch was created, a check I often run during a Health Check.
How to Convert Hex Windows Error Codes to the Meaningful Error Message – 0x80040002 and 0x80040005 and others? – Interview Question of the Week #182
Seen hex error codes like 0x80070070 in the ERRORLOG? Here are the simple steps I use to convert hex Windows error codes into meaningful error messages.
How to Generate Random Password in SQL Server? – Interview Question of the Week #181
Question: How to Generate Random Password in SQL Server?
Answer: This is a fantastic question and here is the script to generate a random password in SQL Server
How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180
Moving databases to another edition? Here is a simple script for SQL Server 2008 and later that lists the Edition specific features each database uses.