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:
Friday, 22 February 2008

SQL Server TempDB useful tips

›
Moving Temp Database Files Step 1: Move the tempdb files to a new physical location (mostly on disk drive in RAID protection 1, 1 + 0 or 5 )...
3 comments:
Wednesday, 14 November 2007

Scripts to Drop and ReCreate Indexes in SQL Server 2005

›
SQL Server 2005 “GENERATE SCRIPTS” wizard does not have the option to generate the Index scripts alone from the database. The below script c...
248 comments: