On my development server I delete all data from two tables then pull fresh data from the production server via Delete From then Select Into. It's only about 100,000 rows total. On dev I run a routine that inserts and updates many rows within a transaction. The transaction seems to never end so I click the stop button in SSMS then execute just the word Rollback. Now I re-run the same insert/update code and it finishes in a split second. How can I avoid the first run from being so slow? Why is this happening? I'm concerned that I'll encounter the same problem when I run the code live. As you may guess I'm a developer and have no DBA to discuss this with. Thanks in advance.
Asked
Active
Viewed 246 times
0
DeveloperDan
- 109
- 2