in
Programming SQL Server (forum)
SQL Server (group)
(Entire Site)
Home
SQL
.NET
SysAdmin
Opinion
Blogs
Forums
Books
Sign in
|
Join
|
Help
Home
Blogs
Forums
Forums Home
>
SQL Server
>
Programming SQL Server
>
Re: Taking lot of time to retrieve the data
Taking lot of time to retrieve the data
Last post 06-18-2010, 10:20 AM by
Arles
. 1 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
06-16-2010, 9:43 PM
Post number
93070
paddy08
Joined on 06-16-2010
Taking lot of time to retrieve the data
Reply
Quote
I am having SQL server 2005 as my database. I am trying to retrieve the records from the DB. I have replaced the cursors with joins. It is taking lot of time to get the records.Plz help
Report abuse
06-18-2010, 10:20 AM
Post number
93107
in reply to post number
93070
Arles
Joined on 10-20-2008
Nashville, TN
Re: Taking lot of time to retrieve the data
Reply
Quote
With very limited information, the only recommendation I can give you is to check and make sure that you have the fields used in the JOIN statement properly indexed.
Report abuse