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:
Saturday, 12 July 2008

Parallel Data Loading using SQL Server 2005 partition techniques (BCP)

›
It is common in Enterprise scale projects to simulate the test environment with very large-scale databases. The preparation of real time dat...
7 comments:
Thursday, 28 February 2008

Restrict SQL Server Login –SQL Server 2005

›
There is always a need to restrict the user logins into the SQL Server databases. Many DBA’s face this difficulty, as the restriction of log...
3 comments: