Posted in SQL Server on June 11, 2009 | Leave a Comment »
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 statement will actually improves the performance a lot.
1. To further illustrate I have created a [...]
Posted in SQL Server on May 7, 2009 | Leave a Comment »
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. In earlier versions we acheived this functionality by converting the data into XML or calling [...]
Posted in SQL Server on May 1, 2009 | 1 Comment »
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 here. This session will provide you with an sneak preview into the next release of [...]
Posted in .NET Framework, SQL Server on April 24, 2009 | Leave a Comment »
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 is as below.
In Source System data (read as Images,Videos or documents(.xls,.ppt,.pptx,.xlsx,.doc,.docx) )is stored in a [...]
Posted in SQL Server on October 17, 2007 | Leave a Comment »
Hi,
Please find the SQL Server 2008 Code named “Katmai” webcast series @http://www.microsoft.com/events/series/msdnsqlserver2008.aspx
