How to resolve disk IO performance problems that are a very important point for SQL Server troubleshooting. Find Average read […]

Tempdb is a system database inside SQL Server, used primarily for internal and temporary operations. In the case of troubleshooting […]

Here are the scripts for find missing index in SQL Server database: SELECT s.last_user_seek, d.object_id, d.equality_columns, d.included_columns, d.statement, s.avg_user_impact FROM […]

Here is the simple script to backup SQL Server database: DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — […]

Let’s learn how to shrink database in SQL Server Step 1 : Right click on database => properties => options […]

Problem: SQL Server: Database stuck in “Restoring” state Solution: You need to use the WITH RECOVERY option, with your database […]

Problems: How to convert Visual Foxpro database into SQL Server database? How to Import dBase Database into SQL Server? Import […]

Problem: How to generate script from sdf database? How to Convert .sdf database to .mdf database? How to migrate from […]

Problem: How to Reset Identity Seed after deleting records in SQL Server? Solution: The DBCC CHECKIDENT management command is used […]

Problem: How to copying a huge table data into another table in sql server? Copying Data Between Servers How to […]