Yesterday's question 'What does the DUMP command do?' is the same question on 3/30/2007.

I remembered I answered that question before.:)

Please read K.Brain Kelley's blog. He is a developer/DBA.

http://blogs.sqlservercentral.com/brian_kelley/archive/2007/10/29/3075.aspx

I sent an email to the webmaster weeks ago and did not get anything.

I agreed, you can just make dash_id as unique cluster index and leave the identity field as the PK.

Remember you can only have one cluster index in one table.

Can you explain a little more how to use dynamic SQL to manage the snapshot and use synonyms to do that? I am new to SQL Server 2005.

Thanks a...

I know a lot of production DBAs only know how to do backup and restore and not much else. I also know a lot of developers only know...

Usually I use the identity field in your case sw_id as primary key and build an index for the other columns - app_id, msn, dash_id, received_from_dashboard.

Also even sw_id as the...

The cleansing routine is done during the ETL process. After the data loaded into the dimension table, it is not guaranteed that no one would delete it. ...

There are many tools to do that. One from RedGate called SQL compare. It is pretty good.

Do I get commission for selling/promoting Redgate software, Steve?:D

I am the developer/DBA plus data modelor and data warehouse experience. Most companies I interviewed for the past year had no DBA so one of their requirements were...

I used to work for a few technical managers. Some listened to people's suggestions but there was one who thought he was a guru and he refused to listen...

I was in those situation before. When no one asked questions after the VP gave the speech, that meant the employees did not care what the VP said and...

First of all, you said you wanted to move dbA to dbB, you meant all tables in dbA or one table in dbA?

If the table you want to transfer is...

What do you mean what type of dimension? It is based on your business, usually there is a Date dimension table, customer, product....

Are you talking about database cloning? There is database mirroring and database snapshot, replication.