I have better solution here instead of going with complex steps-

Create the the empty target database as per the files/filegroup design you want. (Spreading files across multiple drives)

Copy all...

This is detailed link from SQL Server 2008 microsoft website-

http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

I have simple solution for you.

Copy 5 Million records to another dummy or staging table.

Truncate the original table.

And then copy 5 Million rows from Dummy table to original table.

If...

This is very common issue. But no out box solution for this.

You can have another database created from full back up. Then restore log backups on that up to particular...

Hi GilaMonster,

Can you please give some references more information on how differential backup size increases because of Index Rebuilding process?

I am not able to find any information on this.

I...

If your database is critical. It is recommanded to have database in full/bulked log recovery model. And plan for log backups. here you recover up to last point of failure...

sp_spaceused - index size give you total size of all indexes.

It seems that you have many indexes with more than one columns in each index (Composite Index) or the...

Hi,

You can check these duplicates using queries

select name,dob,count(*) from candidate_details group by name,dob

select name,email,count(*) from candidate_details group by name,email

select dob,email,count(*) from candidate_details group by dob,email

if count is more than 1...

Yes N' makes the string Unicode.

Text from BOL:

Unicode strings have a format similar to character strings but are preceded by an N identifier (N stands for National Language...

I think you should take help of some OS/Computer guy who can help you in knowing whether files can be obtained back.

Hi

If the transaction is open, It wont allow you to even select records (Which requires shared lock only)from that table from another session. Update is out of question.

create table tabb1...

I do not think procedure call is allowed in the condition or the result expression of the case statement.

If somebody can provide the information, it would be great.

If it is for particular table simplest way is-

1. Generate the script of the table which includes all keys and constraints. also include DROP statements while generating the script.

2....

Second option is better, this will make things simpler.

But still you need to work on issue addresses history. You can soft delete old records by adding auditing fields to the...

Unique key can have one Null value in it. Primary key can not have. This is the only difference in this scenario.

I guess u should go with Primary key.