SQL Server Recovery Models

There are three different recovery models of SQL Server, you should select SQL Server recovery model to manage log files and prepare for the SQL recovery in case of disaster…. Read more »

Index Scripts

List all indexes for all tables in a SQL Server Database. USE AdventureWorks2012 GO SELECT DB_NAME() AS Database_Name , sc.name AS Schema_Name , o.name AS Table_Name , i.name AS Index_Name… Read more »

SQL Server DB Refresh

SQL Server DB Refresh from SQL Server 2008 to SQL Server 2008 – Article Note: For SQL Server 2005 to SQL Server 2008/2012, Post DB Refresh, Please change DB Compatibility… Read more »

Installation

1) What are the various Editions available in SQL Server 2012 version? Below are the various editions available in Microsoft SQL Server 2012 SQL Server 2012 Standard Edition SQL Server… Read more »