Columns per base table 1,024

Bytes per short string column 8,000

Bytes per row8 8,060

Take out list of tables and check for fragmentation.

If the fragmentation is low go for dbcc index defrag.

It will definately increase performance.

You can use profile same way u are using...

You Can use Case which equal to Decode of Oracle

Is there any data in the table?

If there is any data check for there is any non-numeric value existing the table

It is not possible.

Create a maintance plan and put it as job Schedule

What is datatype you have created?

Check the following example where in i am getting correct insert

Create table #1(d1 datetime DEFAULT getdate() )

insert into #1 values('')

insert into #1 values('2008-01-09')

select *...

SELECT

*

FROM

sys.sysdatabases where version is null

Is it in SQL Server 2000 or 2005?

Check the following link may help u

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=70&threadid=45658&enterthread=y

http://www.microsoft.com/sql/prodinf...alability.mspx

http://www.microsoft.com/technet/pro...y/harag03.mspx

http://www.microsoft.com/technet/pro.../spltmirr.mspx

http://www.microsoft.com/technet/pro...sqlwriter.mspx

Check following link

http://msdn2.microsoft.com/en-us/sqlserver/aa336346.aspx

Second one is the best

Check the following link.

http://www.databasejournal.com/features/mssql/article.php/3339681

Statistics determine the selectivity of the indexes. If an indexed column has unique values then the selectivity of that index is more, as opposed to an index with non-unique values....