General Articles
How to Reindex SQL Server Databases Using a PowerShell Script
When your SQL Server database becomes slow, one reason might be that its indexes are fragmented. To improve performance, you…
Tag: mssql
SQL Server
How to Backup SQL Server Database
SQL Server is a relational database management system developed by Microsoft. It provides a powerful graphical interface called SQL Server…
SQL Server
How to Rename a Column in SQL Server
Database design is the organization of data. A good database design makes it successful. Its recommended to follow a good…
SQL Server
FIXED MSSQL Error 3154 – The backup set holds a backup of a database other than the existing database
Using SQL Query Window: Use WITH REPLACE option with the RESTORE command on MSSQL query window. Change database name and…
SQL Server
How To Create ASPState Database in SQL Server
The ASPState database is used by Microsoft’s ASP.NET Session State Service to store session data. By default, session state service…
SQL Server
How to Shrink SQL Server Transaction Log Files using DBCC SHRINKFILE
Sometimes SQL Server logs files acquire a large space on the disk. In that case, we need to reduce the…