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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-19 : 07:37:42
|
| Vishwa writes "I am deleting records from different tables in a database thru my .Net application.But, the size of the records are to high in some of the tables which results in "Time out Expired" Error.Therefore, do I have any query optimization technique Or I heard Using Set rowcount technique will overcome this problem?can you please help me out?ThanksVishwa" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-19 : 09:03:59
|
| Yes, you can use SET ROWCOUNT to specify no. of records to be deleted.Also check:* whether you have any DELETE trigger written on the table which may be causing excessive time.* Whether deleting process is blocked by some other process* Any CASCADE DELETE option is specified on the tableHarsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
SQL Query