Post removed.

I could not find a work around but you can change it in SSMS.

Visio has come a long way and it is relatively inexpensive.

I purchased ErWin a few times but I'm not aware that it has the functionality that you are looking for.

After you purge the data you can shrink and rebuild the indexes, Be careful as to what size you shrink to or you will have fragmentation.

If you move data from...

Basically:

sp_RENAME '[OldTableName]' , '[NewTableName]'

http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/

Please specify the exact object names, old table name, new table name and the exact syntax that you are using.

Do yo mean will it not be fragmented or compressed.

In...

Ivan Mohapatra (9/8/2011)

well i have a db of 20gb i want to archive some data into a archive db.

So,kindly guide me how to create a archive db in sql server...

Are you going to perform an archive and purge?

The answer to your question is no.

Usually a Candidate Key is obvious.

I have queried individual columns to identify what columns or combination of column make a record unique. It is...

Is there anything in common between the files that load and the files that fail?

http://sqlknowledge.com/2010/12/how-to-monitor-sql-server-cpu-usage-and-get-auto-alerts/

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/be93e3d7-5ac5-4a96-b131-a5ea275b72fb

Depending upon what you are doing you could partition the table(s) are perform a Merge Split.

http://blogs.msdn.com/b/felixmar/archive/2011/02/14/partitioning-amp-archiving-tables-in-sql-server-part-1-the-basics.aspx

http://blogs.msdn.com/b/felixmar/archive/2011/08/29/partitioning-amp-archiving-tables-in-sql-server-part-2-split-merge-and-switch-partitions.aspx

I did this a few times when this was not an option but I don't...

The following is not specifically for Interview questions but it may help.

http://www.sqlservercentral.com/articles/Administration/commonclusterproblems/470/

The following article has additional information on the BCP Utility:

http://www.simple-talk.com/sql/database-administration/working-with-the-bcp-command-line-utility/