HI there, have you tried the usual stuff? Like rebuilding/reorganizing your fragmented indexes or updating your tables statistics? have you check your server counters with sys.dm_os_performance_counters? what kind of waits...

Steve Jones - Editor (10/21/2008)

---

First of all, is the hardware the same? Or how is it different? Check drivers, especially disk drivers, as issues there can really affect performance.

Next, you...

They are on simple recovery mode. When I was doing my tests it was on full recovery mode but then I tried changing it to simple, and continue running my...

no ideas no one?

hi there, do you know if you can use tablediff but to compare data from an sql server 7.0 with a 2k5? is that possible to be accomplished with this...

yeah we are thinking on calling some MS performance expert on this matter, because we don't seem to get a better performance in any of our attempts. But just to...

Hi there, what exactly are you planning to migrate?all your database objects?sp,tables,views,data,dts,users,roles,schemas?just everything?

I had to do a migration and what I did was just to restore a backup on...

Grant Fritchey (10/17/2008)

---

You should just go through and update all the statistics, everywhere. Statistics are pretty different from 7 to 2000 and even more so from 2000 to 2005.

You'll...

TheSQLGuru (10/17/2008)

---

At least 75% of my clients have multi-cpu servers with insufficient RAM or IO capabilities (or both!), and thus suffer from significant CXPACKET waits on largish queries. It...

Thanks for the quick reply, but I have another doubt, do the statistics I 'migrated' from sql 7.0 work the same as sql 2k5?Or should I rebuild all the indexes...

Hi everyone I am having a similar problem here, well on my dev server I have 4 cpu, I dunno why I get so much CXPACKET wait time, well my...

Steve Jones - Editor (10/15/2008)

---

You should never assign permissions to public. Always create another role and assign permissions there.

If you give the user the rights through to the proc, they...

Lynn Pettis (10/15/2008)

---

Giving a user/role access to a stored procedure is a means to allow users/applications to access database tables without giving them direct access to the tables. If...

I am running this on SQL 7.0 on my dev enviroment as on my prod enviroment. We are doing a migration to SQL Server 2005. The thing is that this...

thanks guys for the replies 😀 well, we load data to this physical temporary tables from other physical temporary tables. They are probably over 200 thousand records we have to...