SQL Server - Oracle Architectural comparison

This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...

Auto Shrink of all T-Log File on a SQL Instance - TSQL

This Script will shrink all the T-Log files of SQL instance if there is no active tracsaction on the database. The...

Replace NOT IN with JOIN

Example of how to replace NOT IN clause with JOIN

/*NOT IN query*/
USEAdventureWorks;GOSELECTProductIDFROMProduction.ProductWHEREProductIDNOTIN(SELECTProductIDFROMProduction.WorkOrder);

/*JOIN Query*/:-
SELECTp.ProductIDFROMProduction.ProductpLEFTJOINProduction.WorkOrderwONp.ProductID=w.ProductIDWHEREw.ProductIDISNULL;

SQL database Incremental Shrink TSQL

When we shrink a SQL database through GUI we usually find the database never releases all the free space, It...

SQL security scripting - TSQL

SQL DBA often needs to script SQL Logins,Server roles,database users and Roles. Although its easy to script login,roles and users with...

Set Up SQL Server Mirroring T-SQL Script

T-SQL Script to create a SQL Mirroring:-

The first thing you need to do when setting up Database Mirroring is perform...