I have 2 MS SQL Servers running on 2 machines that are identical. I am working with 2 databases - one from each machine. The structures of these databases are also identical however, the number of records are different.. SQL Server A has over 1.5 million records through which I am querying.. SQL Server B has roughly 100,000 records. I wrote a query on Server A that takes about 12 - 16 seconds to run. This same exact query takes over 30 MINUTES to complete on Server B - yes the one with less records by far. What could be causing a problem such as this?Thanks..ET
takizzle 0 Newbie Poster
campkev 0 Posting Pro in Training
I am guessing you are missing an index or something. Without more information, hard to say for sure.
mwedberg 0 Newbie Poster
You might want to check that the indexes are the same on both databases. Don't remember which but when you do an import or copy indexes are not always transfered.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.