Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adnanans78
Starting Member
17 Posts |
 Posted - 2008-11-25 : 05:07:47
|
| Hi,There is a table containing 1.5 million records.It is too much time(appx. 1 hour) when it access.sql profiler tells cup useage from 550 to 600.Any help!Thanks in advance.Mr |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-11-25 : 05:11:01
|
| Please read the FAQ's when looking for assistance....especially the bits about supplying table DDL, sample SQL code, sample input data (+ results)....and maybe an "execution plan"You want us to help you?.....first help us with some useful information. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-25 : 05:52:09
|
| http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-25 : 06:20:56
|
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
query Takes too much time