Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How to improve table(15Lacs records) in Sqlserver2008R2 ?
s kumar
Jan 27 2014 1:19 AM
836
Reply
Hi,
I have one table named "tblSeacrch" in Sqlserver2008R2. In that table have 15Lacs records. When fetch all records then It Takes 10mins to display.
Another one When display 15Lac records in RDLC Report then Page is loading.
How to improve performance in table? I don't know anything. Please Let me know.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
aggregate function in sql
How To convert case into packs in case statement mssql2000