Monthly Archives: December 2011

SQL Script to find Expected Finish TIME for current running BACKUP / RESTORE

When SQL Server backup / Restore will be finished ? How long it will take to complete this backup or Restore ? What is expected time when SQL Server BACKUP / RESTORE will be finished? This question is asked by lot of time by DBA’s and we always answer them either based on past history [...]

TOP SQL Server Posts for 2011

This is a quick review of top posts for year 2011 How to Setup Replication with SQL Server 2008 ? How to install SQL Server 2008 R2 Express Edition Installation ? How to Setup Mirroring in SQL Server ? Difference between TRUNCATE & DELETE statement in SQL Server How to setup LOG Shipping using SQL [...]

SQL Server Licensing – Core Based Licensing

Microsoft SQL Server will no longer be licensed by the CPU socket and will instead be licensed by the CORE CPU’s. Does SQL Server 2012 cost more ? Do I need to spend more cost to higher number of CPU’s with compare to previous versions ? YES, In some case definitely yes, SQL Server 2012 [...]

SQL WHERE – Video Tutorial

Prior to understand Where clause, lets do a quick recap of SQL and then we will focus of WHERE clause. What is SQL Queries ? With SQL, we can query inside a database and have a result set returned. A query like this: SELECT FirstName, LastName FROM Person.Contact this query will return result set like [...]

Installing SQL Server 2008 R2 SP1

I was rebuilding my machine this week and I installed three Instances of SQL Server 2008 R2 on my Machine for testing purpose. I try to keep my version upto date, so I need to apply SQL Server 2008 R2 Service Pack 1 and Cumulative Update 4 for  SP1, which all together will bring my [...]