Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time. February 2012 Entries
SQL Server... help!
I have two Great Plains databases, let's call them DB1A and DB1B, that are schematically identical and the data is 99% identical but DB1B has a tiny bit more data. I'm trying to optimize a very complex query that uses views nested in views and is way too long to post all of here. The query was averaging 1 min 43 sec before I started. I noticed that all of the tables involved were heaps (Microsoft's fault, not mine) so I started converting them to clustered one by one, checking the plans and parallelism ......

Posted On Wednesday, February 29, 2012 10:43 AM

Copyright © Alex Bransky | Powered by: