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...

It might help to say what the error is

I think you need to declare @maxno inside the dynamic sql

I would take a FULL backup as a precaution, then use detach/attach. It's probably faster since you bypass the backup & restore steps and only need to do the file...

Not directly relevant, but when converting MySQL to SQLServer, I used SQL_Maestro as an interface to dump out the tables for import into SQL .... FWIW