- 博客(1)
- 资源 (6)
- 收藏
- 关注
原创 快速查找字段名称所在的用户表
有时,我们需要增加某个字段的长度,但该字段出现在多个表中,如何快速且一个不漏的找出哪些用户表用到该字段呢?有如下几种方式都可以实现:1.select tab.name table_name, col.name column_name,length from sysobjects tableft join syscolumns col on tab.id = col.id and tab
2012-12-05 12:58:13 1543
transaction-log-management
This covers performing transaction log backup and restore, monitoring and managing log growth, including quick diagnosis of the causes of rapid growth, and optimizing log architecture to maximize log throughput and availability.
2013-06-06
How to boost DB server's performance
From this file,you can learn some tips of SQL scricp,useful DBCC commands etc. Besides, you can learn how to use SQL Server Profiler,DTA and so forth.
2008-09-25
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人