Today we are going to discuss the performance comparison of table variables and temp tables when we are running SELECT queries.
SQL SERVER – Check for Update in SSMS
How to check for an update in SSMS depends on the installed generation. My fintech-customer walkthrough showed SSMS 18 settings.
Lock Pages in Memory: When to Enable It and How to Check
Lock Pages in Memory is a Windows right that stops Windows from paging out the SQL Server buffer pool. This post explains what it does and what it doesn’t, how to grant it to the service account and how to check the result with T-SQL. It also covers the max server memory setting that must go with it.
SQL SERVER Management Studio 18 – Enable Dark Theme
We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio.
Database Mail Health Check: Unsent Items and the Event Log
The alert job succeeded, yet nobody got the email. Here are three read-only checks that show whether Database Mail is really working.
SQL SERVER Management Studio – Completion Time in Messages
When the queries end, we know how long the query ran from the duration of the query but we never know their completion time.
Tables Containing a Column: Search by Name in SQL Server
To find tables containing a column, search sys.columns by name instead of opening tables one by one. This post searches one database, then every database on the server, and shows why an underscore in the pattern needs brackets. It also compares the data types of related columns.