Restore transaction log SQL Server
Backup and Restore are the common tasks that a DBA needs to perform almost daily. In this blog I’ll talk about how to restore a transaction log in SQL Server. A …
Restore transaction log SQL Server Read MoreSQL Server Accidental DBA Series
SQL Server Accidental/Involuntary/Junior DBAs Series
Restore database SQL Server command with replace
Restore database SQL Server command with replace option is used when we need overwrite an existing database from a backup. The T-SQL command for same is shown below. RESTORE DATABASE [AdventureWorks2014] …
Restore database SQL Server command with replace Read MoreT-SQL script to delete files
Many a times need arises to access/modify windows folder structures from SQL server. Though SQL Server is not meant for this purpose, however here is a T-SQL script to delete files …
T-SQL script to delete files Read MoreRestore transaction log point in time
This is an awesome feature where in one can restore transaction log point in time. A database can be restored to a specified using STOPAT option in restore command. Let’s look …
Restore transaction log point in time Read MoreT-SQL script to find the cd key from registry of SQL Server
Many a times we need to find details about SQL server installation when inheriting a new environment or a setup. One way to figure it out is by reading a registry. …
T-SQL script to find the cd key from registry of SQL Server Read MoreT-SQL script to find column in database
Many a times we need to find all tables having a particular column in a database. Here is a T-SQL script to find column in database. SELECT DB_NAME(DB_ID()) As DatabaseName, OBJECT_SCHEMA_NAME(objects.object_id,db_id()) …
T-SQL script to find column in database Read MoreT-SQL find constraints on table
Many a times need arises to find all constraints on a table. A common use case is when dropping columns from a table we need to know the dependent objects so …
T-SQL find constraints on table Read MoreSimple cursor in SQL Server to insert records
This blog briefs about using a simple cursor in SQL Server to insert records. This is not a real world complex example; however it will help you to understand to use …
Simple cursor in SQL Server to insert records Read MoreT-SQL script to find duplicates
A common task for DBAs/Developers is to find duplicates in tables to avoid redundancy and storage misuse. Here is a T-SQL script to find duplicates. Create table tblDup(Sno int identity, Col1 …
T-SQL script to find duplicates Read MoreFind dependencies of stored procedure in SQL Server
Many a times need arises to find objects a stored procedure depends on. The blogs describes a way to find dependencies of stored procedure in SQL server. The below query creates …
Find dependencies of stored procedure in SQL Server Read More