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.
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.
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.
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.
How to Enable CDC in SQL Server
This is a post on how to enable Change Data Capture (CDC) in SQL Server. Enabling this on a database and table will allow the recording of activity when tables and rows have been modified.
How to Rename a Computer that Hosts SQL Server
When changing the hostname of a computer that is running SQL Server, we have to update system metadata so that remote connections and applications do not lose connectivity.
Get All Database Sizes in SQL Server
Measuring databases is important for knowing how much disk space a SQL Server requires today, as well as the future growth of the database files.
How to Backup a SQL Server Database
This post contains a demo on how to backup a SQL Server Database and includes some information on the types of backups available in MS SQL.
Get Estimated Backup Restore Time in SQL Server
This post contains a SQL script to get estimated completion times and process information for your currently running database backups &
Drop Table if Exists in SQL Server
The DROP TABLE command in SQL Server will do as it suggests and drops a table. This post is to show an example of using this command, including the IF EXISTS argument.
