Split into drives then you have separate LUN number for each drive to increase the performance

For In Raid 10

==========

Drive 1 : Data-Files

Drive 2 : Log - Files

Drive 3 : Temdb...

Transation volume = Production database ?

Transaction Volume is high then what you want to do with it ? explain your question clearly ?

Attaching a database is actually performing CREATE DATABASE FOR ATTACH statement so,its not possible to come back at recovery stage

do you have index on these columns

A.Col1

B.Col1

create the nonclustered index as

Cobdate asc

domainname asc

row_number asc

including BookName

Total Records ?

Using simple Delete statement like

Delete from tab1 ? or some other procedure to delete the data ? I am asking the T-SQL in the SP ?

write here your full update statement

Do you have restriction on database files growth?

try this

sp_spaceused @updateusage = 'TRUE'

for the specific database

that might be an SPN issue,you have required SetSPN.exe tool to set this problem

http://msdn.microsoft.com/en-us/library/ms677949(v=vs.85).aspx

as mentioned on the above link

Before the Kerberos authentication service can use an SPN to...

where did you get this msg out of disk space ?

1-Open the SSMS(Sql Server Management Studio)

2-Right click on the desire database and then click properties

3-In the General TAB on the left side pane then check the Size and Space Available...

create procedure DeleteOlddata_SP

as

Begin

Delete top(10000)

from SC_SampledNumericDataFact_Table

where DatetimeAdded<getdate()-180

End

And schedule this Store Procedure on the SQL Server Agent job with minimum interval of 15 mins,when you perform the DML,SQL Server generate...

Are you using Named Instance ?

How you connect SQL Server on SSMS(SQL Server Studio Management) ?

ServerName\InstanceName,port

or simply with default instance just

ServerName

All Protocols are enabled for the instance and the client...

DBCC SHRINKDATABASE

Visit this link

http://support.microsoft.com/kb/307487

its depend on hardware and available resources for the Instance,you can do this but tempdb must be enough because READ_COMMITTED_SNAPSHOP_ON use the tempdb because row-versioning is going on ,you should...