资源列表
RR.ZIP
- Studying Microsoft SQL Server, this is the things that I did for the reason that my OJT supervisor wants me to be familiar with the other kind of database management. He allows me to use his book, the “Implementing and Maintaining Microsoft SQL serve
aa
- 基于SQLSERVER的T-SQL源码，用于水情数据处理，入库量还原。-Based on SQLSERVER of T-SQL source code for the water level data processing, storage capacity reduction.
EDAD_YMD
- calculate de number of years, monyh or days betwwen 2 dates
DBcon
- sql server 2000 数据库连接-sql connect
1
- 创建数据库表和插入，如果一条记录存在，则修改，不存在，则添加-Creating database tables and insert, if a record exists, modify, does not exist, then add
onlynomber
- it is code for check user input it allow just number inputs
SQL_Subselects
- Thtas only a first example for test. Please check if you like it.
onlyStringInputs
- it is class named c_CommonControls and contains method for onlyString input -it is class named c_CommonControls and contains method for onlyString input
SQL 2005 重建索引
- 相信很多SQL Server DBA或开发人员在重建或重组大表索引时，都会相当郁闷，不知道索引重建的进度，这个对于DBA完全是一个黑盒子，对于系统负载非常大的系统或维护窗口较短的系统，你会遇到一些挑战。例如，你创建索引的时候，很多会话被阻塞，你只能取消创建索引的任务。查看这些索引维护操作的进度、预估时间对于我们有较大的意义，需要根据这个做一些决策。下面我们来看看看看如何获取CREATE INDEX、ALTER INDEX REBUILD、ALTER INDEX ORGANIZE的进度。