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 |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2008-11-03 : 15:54:55
|
| Does it effect the users when adding a datastamp on an existing DB where it has millions of records. How wud i shedule this off peak time? |
|
|
shaunc
Starting Member
28 Posts |
Posted - 2008-11-04 : 16:23:06
|
| It depends on how your users' applications construct their queries. If they're not explicitly selecting columns by name, an extra column in the result sets may cause problems. Likewise, an insert will fail if the application makes assumptions about the schema. It's probably a good idea to fire up Profiler and see how the table is being queried - or ask your users, if that's an option. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2008-11-04 : 16:36:36
|
| Yes, it will likely cause a slowdown while that edit process is running. You can either stay up late and do this live, or you can script out the T-SQL commands to accomplish your goal and then put them in a Scheduled Job in order to schedule them off-peak.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
Datestamp