Category Archives: SQL Server

Identity vs SCOPE_IDENTITY vs IDENT_CURRENT

It is a common practice to use IDENTITY value for columns which are simple integer increments. We can also specify what is the initial value and how we want to increment using seed values. In some cases the client applications … Continue reading

Posted in SQL Server | Leave a comment

SQL Server 2008 MERGE will improve performance

One of the new features of SQL Server 2008 is the MERGE statement. Basically MERGE will insert data  to a target table from a source if the data is not there other wise it will update/delete from the target table. Using the MERGE … Continue reading

Posted in SQL Server | Leave a comment

Table valued parameters in SQL Server 2008

In this article I will demonstrate how we can ultilise the new feature called table valued parameters in SQL Server 2008. These are great addition to the SQL sever 2008 that allows us to pass multiple rows of data to the stored procedure. … Continue reading

Posted in SQL Server | Leave a comment

SQL Server Code Name “Kilimanjaro” and “Project Madison” webcast

The new version of SQL server Code named “Kilimanjaro” is going to release in FY2010. Before that microsoft wants to give a brief introduction of the same. So they have created this webcast. You can download the webcast by registering … Continue reading

Posted in SQL Server | 1 Comment

Retrieving BinaryData from SQL Server 2008

Today in  my current project we are supposed to build an image from  Binary data stored in a SQL Server column. AS we know SQL Server allows us to store BLOB (Binary Large Objects) data. Here in our case the situation … Continue reading

Posted in .NET Framework, SQL Server | Leave a comment

New Microsoft SQL Server 2008 Web casts

Hi, Please find the SQL Server 2008 Code named “Katmai” webcast series @http://www.microsoft.com/events/series/msdnsqlserver2008.aspx

Posted in SQL Server | Leave a comment