Friday, 30 January 2009

SQL Server 2008 – Inline variable initialization

›
Microsoft has extended the support of inline variable initialization feature from the programming languages in to T-SQL in SQL Server 2008. ...
3 comments:
Sunday, 25 January 2009

Turn Off - Prevent saving changes in SQL Server 2008

›
I was working with SQL Server 2008 for quite some time and noticed a strange behavior (which is not in previous versions of SQL Server) when...
5 comments:
Sunday, 14 December 2008

How to upgrade database from SQL Server 2005 to SQL Server 2008

›
The following steps should be carried out upgrade a database from SQL Server 2005 to SQL Server 2008 Step 1: Detach the database files from ...
2 comments:
Sunday, 26 October 2008

Paging using LINQ

›
SQL Server supports many ways of implementing paging in the applications. With the introduction of LINQ (Language Integrated Query) support ...
7 comments:
Friday, 26 September 2008

How to generate ROWNUM in SQL Server SELECT

›
It is often required to create unique values for every row in a result set query in SQL Server. But SQL Server doesn’t have any built in fun...
25 comments:
Monday, 28 July 2008

Script to RESEED Database in SQL Server 2005

›
It is often required to RESEED the database tables with new range of identifiers especially when the table’s Primary Key column is designed ...
2 comments:
Saturday, 19 July 2008

Index maintenance using DMV’s in SQL Server 2005

›
SQL Server 2005 provides more flexible ways handling index maintenance activities using DMV (Dynamic Management View’s). The DMV’s can be ef...
3 comments: