Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
can not get optimized execution plans in a faster machine
Thanks, Nigelrivett, Setting Maxdop=1 hint does help a lot.- Shude
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
can not get optimized execution plans in a faster machine
I have SQL server 2000(up to SP3) installed in our QA server which is Windows 2000 server with one CPU, 2G RAM, all store procedures in the database run fine. But once we moved the same database to our production machine(up to SQL server 2000 SP3, 2 CPUs, 3.7G RAM), no matter the database is...- Shude
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Data Transformation Services
