Category: General
-
SQL Server 2008 R2 New Features
On April 22nd 2010 SQL Server 2008 R2 is released to production. I tried to get the list of new features added to R2 however I couldnt find all the new features in a single thread so Im writing this article to populate the list of new features added to SQL Server 2008 R2. There…
-
All about Bulk Logged
This document is relevant to bulk operations on SQL Server. The bulk-logged recovery model is a special-purpose model that works in a similar manner to the full recovery model. The only difference is in the way it handles bulk data modification operations. The bulk-logged model records these operations in the transaction log using a technical…
-
Backup SQL Database to Remote location
Does the title sounds crazy? You might think that this topic is very simple? Yes you are right however some folks still raise this question in forums. Im seeing this question for for a long time in forums and thought of sharing the solution here, so that the folks can give a search to get…
-
SQL Server Joins
SQL Server joins are required to retrieve data from one or more tables to get a single result set. Joins are needed when Normalization enforced in design. When you normalize the data you be reducing redundancy in data by placing data in different tables and also you will be creating relationship between the tables. With…
-
Merge Drop Slipstream Setup
In my previous article we have discussed about Basic slipstream setup, now Im going to write a article on Merged Drop slipstream setup. In this method you will be merging the service pack with the base setup prior to the installation there by altering the source or base setup files. The merged setup package can…