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 |
|
agupta16
Starting Member
3 Posts |
 Posted - 2012-03-27 : 23:33:08
|
| HiAll,We are using SQL server as our DB in the enterprise application. We have a problem at hand currently. We have a table which consists of our events and which grows in millions around 10mn. We have added 2 new columns in this table to improve performance with respect to create few more parameters. During upgrade we use SQL Delta and compare the delta and generate the scripts for schema, since this table is changing we copy this big table to temp table and create a new table with same name with added column and move the data. In this scenario we are getting SQL query time out because of high data.Any resolutions to mitigate this.ThanksAmitAmit Gupta |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2012-03-28 : 00:56:46
|
| Try migrating the data in smaller batches - say 10k rows at a time.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL Query time out