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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need Help Analyzing 2 Tables
Does it seem reasonable that the query processing time can be reduced down to a few seconds (versus the current 2-3 minutes)? I'm open to any ideas... including drastic ones!- jackmenus
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Need Help Analyzing 2 Tables
Hi Everyone, I'm having a really tough time getting a query to run quickly. There are two tables invovled: Table 1 is a temporary table that's created by the program, and will contain anywhere between 1,000 and 100,000 rows. The only field is a unique identifier code. Table 2 has...- jackmenus
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
Help: Indexing / Speeding Up Query?
Hi Everyone, I'm having a really tough time getting a query to run quickly. There are two tables invovled: Table 1 is a temporary table that's created by the program, and will contain anywhere between 1,000 and 100,000 rows. The only field is a unique identifier code. Table 2 has...- jackmenus
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Setup and Administration
