Also, is the data exactly the same on both servers. Are you passing identical parameters on both servers. Assuming both of the above are yes, are the indexes and structures...

It stays on until you turn it off or turn it on for another table, so did you test the inserts to tableA at some point in the past?

Usually, delete the data in the referring tables first. Alternatively you could set up your foreign key constraints with cascading deletes. This is considered a dangerous approach, so it's not...

Alter the table, add the column as nullable, copy the data over, drop the other column at a later date. That should minimize downtime on the system.

Otherwise, you've outlined the...

Scalability Experts has a free tool called the SQL Server 2008 Upgrade Assistant. I used it a few times and it does most of what you're looking for. I'd check...

Alvin Ramard (9/25/2009)

---

Roy Ernest (9/25/2009)

---

Thanks Grant, Alvin 🙂

Still a long way to go. I am getting lots of positive feed backs from the people who attend. They are coming up...

Alvin Ramard (9/25/2009)

---

Roy Ernest (9/25/2009)

---

Thanks Grant, Alvin 🙂

Still a long way to go. I am getting lots of positive feed backs from the people who attend. They are coming up...

Flat out, it depends. I get something from Jeff, Gail, Lynn, the usual suspects, I will review it and test it, but I'll generally assume it's right. I get something...

Roy Ernest (9/24/2009)

---

Just as an update, we had our second Curacao SQL Server user group meeting. We had 15 members attending. It was pretty good. The presentation was well appreciated...

It can be useful for troubleshooting. You can see the transactions by name if you select sys.dm_tran_active_transactions.

You'll have to walk through the database using some type of cursor and calls to DBCC SHOW_STATISTICS in order to look at the database statistics.

As already stated, unless you put...

Roy Ernest (9/24/2009)

---

You state that you have given these rights to the user.. "db_datareader, db_datawriter, db_ddladmin". That should automatically give permission for executing the user defined stored procs. But are...

I'd strongly suggest taking SilverFox's second suggestion and use sys.dm_index_physical_stats. There's more information to be had in a clearer fashion than from the older showcontig statement.

Silverfox (9/24/2009)

---

Is it just me, or is anyone else noticing we are getting a lot of new registrations, with a single word in the topic body like BI and attached...

Yes