The best precaution is a full backup.

I can't see how detach-attach would have any effect on the database. There must have been some other action that occured either before or after.

Edited

CirquedeSQLeil (5/21/2010)

---

Hmmm, you are short a parameter (this function requires four parameters and you are passing in three parameters). Maybe that is causing the difference (but shouldn't work on...

YES, BOL has a typo, but it passes a syntax check on one server, but not the other.

If I use my own DB and table, same problem. Results on one,...

Here's a quick guide. I typed it in 4 minutes, so it's just the basic idea.

1) A "Change Request" is created, specifying modifications needed

2) Developers make changes in Development area...

You can defragment (rebuild or reorg) the indexes on tables for better performance.

There are lots of posts and articles about this topic you can search for.

It sounds that your logic is correct. Could there be a more recent Full backup ? Maybe a scheduled Maint plan you forgot about.

Does this question mean that you are not taking regular Full SQL backups already ? If not,...

Jeffrey Irish (5/20/2010)

---

So, unless I am mistaken, Rebuilding only would be the best option as that is the same as dropping and recreating the Index. However, there are some Indexes...

I think my performance issue is from another cause.

I'm doing an update to a master table with 80 million rows, based on a join to a work...

They were separated out initially for performance when the database was on a stand alone server with separate internal physical disks. After migrating to VMWare, the setup was unchanged and...

Leonard 40050 (5/20/2010)

---

There was about 5GB of data in the tables that I dropped so I assumed the size of the .mdf file in the 'Data' directory would be reduced.

It...

Do you have replication transactions that have not been published to a subscriber ?

homebrew01 (5/19/2010)

---

Default trace doesn't capture Stored Proc create & drop ... according to my test just now. The default trace never seems to have what I need, so I set...