Temp Tables in SQL Server
Temp tables in SQL Server can improve the efficiency and performance of complex queries by breaking them down into smaller pieces, storing intermediate results in memory, and eliminating unnecessary data.
Move Temp DB SQL Server
A common best practice for SQL Server DBA’s is to have Temp DB files stored on a separate drive, especially ensuring that it’s not on the C:\ drive and sharing with the OS.
How to Check SQL Server Version
Checking your SQL Server versions is a common task, as most database administrators will know how important it is to keep the software on the host up to date.
SSMS Silent Install
This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell).SSMS is a tool most people use to administer SQL Server and to run SQL queries.
SSMS Maximum Characters Displayed
By default, the max number of characters displayed in a single column of a query in SSMS when outputting as text is 256 characters.
Add Columns to a Table in SQL Server
Adding new columns to tables in SQL Server is a common task for anyone developing and/or maintaining databases, usually driven by the need for new features on an application/script procedure.
SSMS Show Line Numbers
This post contains a guide on how to show line numbers in the SSMS query window. Useful if you want to see line numbers while you code.
Add a Filegroup to a Database in SQL Server
This post contains a demo on how to add a new Filegroup for a database in SQL Server. Most databases work well with single data/log files and do not need this.
Disabling Change Data Capture in SQL Server
This post contains a demo on how to disable CDC (Change Data Capture) in SQL Server 2022. The sp_cdc_disable_table and sp_cdc_disable_db in-built MSSQL SPs are what we should use to disable CDC in SQL Server which is explained more below.
