Feeds:
Posts
Comments

Posts Tagged ‘SQL Server’

Multiple NULL values in a Unique index in SQL Server/DB2 LUW

Posted in DB2, Oracle, tagged , , , , on May 3, 2008 | Leave a Comment »

By decipherinfosysThis project needed to support having multiple NULL values in the column and still have a UNIQUE constraint. That is allowed by Oracle but not in SQL Server and DB2 LUW. There is a way to make this work in SQL Server and DB2 LUW also but that requires a work-around. Consider this table:
CREATE [...]

Read Full Post »

Significant of Oracle Password File in Login

Posted in DBA, Oracle, tagged , , , on April 8, 2008 | Leave a Comment »

Password file is required to start the database up. There is no mandate to configure manually; the database can take care of that and only changes it when a user is granted SYSDBA or database startup privileges. The password file is used when starting the instance and controls access to the control files (startup mount) [...]

Read Full Post »

Database server consolidation

Posted in SQL Server, tagged , , , , , , , on April 8, 2008 | Leave a Comment »

A Nice article about database server consolidation
The best bet is to start by completing a Server Consolidation Worksheet like the sheet provided by Microsoft to get a better idea of the consolidation opportunities. Microsoft has provided a SQL Server consolidation Worksheet to assist with the process of consolidating SQL Servers and it can be found [...]

Read Full Post »

Way to find the SID of the database

Posted in SQL Server, tagged , , , on April 8, 2008 | Leave a Comment »

In $ORACLE_HOME\NET80 or NETWORK\ADMIN,  
   Open the file tnsnames.ora and it can show some entries as mentioned
    below:
    SIDSAMPLE (DESCRIPTION (ADDRESS = (PROTOCOL = TCP)(HOST =  
                             193.156.145.121)(PORT = 1521)) (CONNECT_DATA = (SID =          
                              XYZ)) )
Here    SIDSAMPLE is the SID you have to provide while connecting forms to db.

Read Full Post »

MS-SQL’s built-in replication capabilities

Posted in SQL Server, tagged , , , , on April 8, 2008 | Leave a Comment »

MS-SQL’s built-in replication feature is designed to publish periodically updated, read-only copies of selected data. It is not designed to provide data protection or application availability to the entire database.
The built-in disaster recovery capability provided by MS-SQL is called ‘log shipping’. This technique assumes that a recent copy of the database exists, possibly on tape, [...]

Read Full Post »