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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Slow Query
Terry, I found the reason the query is so slow. (Query analyser grid is very very slow) I tried a database having 52 periods with 5 million records each. (260 million records) A select * INTO #xxx from _tablename where period=X gave us 0:29 seconds for getting 5 million records, and around...- spyrosc
- Post #11
- Forum: Microsoft SQL Server: Programming
-
Slow Query
Thank you all for your answers. toetag PERIOD is indexed. (It is a clustered index) SQLSister the statistics are updated. tlbroadbent, The select statement is executed on the SQL server-Query Analyzer to a grid.(It uses the clustered index) The reason we are using the period(field1) field is...- spyrosc
- Post #9
- Forum: Microsoft SQL Server: Programming
-
Slow Query
The situation is the following. The server configuration is: 4x 2.0GHz/2M iL3, 2 ultra scsi 3 36GB Raid 1 (Drive C, D) 3 ultra scsi 3 72GB Raid 5 (Drive E) 1.5 GB Ram. Windows 2000 Server, SQL 2000 Enterprise The database size is 10GB and is located on Drive E. The logfile is 5GB and is...- spyrosc
- Thread
- Replies: 10
- Forum: Microsoft SQL Server: Programming
-
Sql 2000 questions
Dear Experts, We have the following scenario: We will create a system that will perform many functions. Database SQL 2000 Client Visual Foxpro Function A: Import and export data from-to text files. Data import will consist of 20,000,000 records per week.(Every week is treated as one...- spyrosc
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
