Thursday, 11 January 2007

Changing Database Collation

›
The existing Database connection can be changed using the ALTER Database command provided in SQL Server. To change the collation settings R...
27 comments:
Wednesday, 3 January 2007

SQL Server Locking Modes

›
SQL Server supports acquires different locking modes depends on the type of operation we perform on the Data. The list of locking modes acqu...
3 comments:
Tuesday, 2 January 2007

SQL Server Locking Tips

›
SQL Server uses locking to support concurrency of data in Multi user environment .The locking can be applied to the Database resources such ...
Tuesday, 26 December 2006

ALTER TABLE SWITCH PARTITION FAILURE

›
Problem The SWITCH TO Partition fails when we perform a swith from non-partitioned table to partitioned table even though the same constrain...
17 comments:
Tuesday, 12 December 2006

Easy Steps for Upgrading to SQL Server 2005

›
Detach the Database from SQL Server 2000 server and attach to SQL Server 2005 server/Back Up and restore. Once the Database is restored perf...
2 comments:
Monday, 11 December 2006

SQL Server Index Creation Guide Line

›
Index creation guide Indexes should be considered on all columns that are frequently accessed by the WHERE, ORDER BY, GROUP BY, TOP, and DIS...
6 comments:
Thursday, 7 December 2006

SQL Server Fill Factor Recommendations

›
SQL Server Query performance can be improved by creating indexes with the appropriate Fill Factor values. The following steps should be done...
5 comments: