I would do the following:

1. Install SQL on temp server

2. Configure SQL server to match prod (mail settings, optimize for ad hoc queries, etc.)

3. Backup and restore databases from prod

4....

Evil Kraig F (5/22/2013)

---

The only person I know around these parts who has gone deep enough into the internals to really understand costing and why a particular number would be...

Not experiencing any extremely high times (under a min). I was able to bring the cost down by taking out the cross apply on the nodes. Cost threshold would be...

Eugene Elutin (5/10/2013)

---

NOLOCK is kind of dice - it may turn any side.

It can read some data which not...

I think you have to ask yourself what you are gaining by using NOLOCK in this case. I see nothing. NOLOCK reads data that has been changed but not committed....

Doh! Didn't read everything... You can't. sysadmin is it.

I believe that TFS actually checks to see if the user is a member of db_owner, if it is not... It will not deploy. Whether or not there are...

SQLRNNR (5/7/2013)

---

Trying to deny permissions to db_owner would effectively invalidate any reason to have the user in db_owner.

The best thing to do would be to ensure there is a review...

Scott Murray-240410 (5/7/2013)

---

I was wondering also about the PII at the cube aggregation level... however, in my organization they seem to want, at times, that level of detail in...

http://technet.microsoft.com/en-us/library/bb934199%28v=sql.105%29.aspx

My current thought is that this information should not be in the cube. If it is, they are not utilizing the cube properly; i.e. addresses, IMHO, have no place...

Jeff Moden (5/6/2013)

---

Eric M Russell (5/6/2013)

---

mah_j (5/4/2013)

---

Hi

I want to archive the data of a 400G table,what is the best way of archiving?

My table has a clustered index on 2 fields...

Changing a table name to make one that does not exist should prevent compiling, period. What errors are you expecting to see that would create this situation? Also, if...

Please provide the query that was used to get this result.

Is your select dependent on the changes from the update statement?