- 博客(1)
- 资源 (3)
- 收藏
- 关注
原创 使用Access做为导出数据的中间介质时,时间和长整型字段要特殊处理
Access中的时间字段默认没有毫秒级的数字,从SQL Server导出数据时,毫秒都会变为0,在使用时间字段做为主键时,有可能会出现主键重复的情况。而bigint在导入到Access时会做为Decimal类型,再导回到SQL Server会出现类型转换,其间有可能导致错误。
2009-10-15 09:49:00 1236
DBA best practises
Check OS Event Logs, SQL Server
Logs, and Security Logs for unusual
events.
2. Verify that all scheduled jobs have run
successfully.
3. Confirm that backups have been made
and successfully saved to a secure
location.
4. Monitor disk space to ensure your SQL
Servers won’t run out of disk space.
5. Throughout the day, periodically monitor
performance using both System Monitor
and Profiler.
2010-04-19
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人