Skip to content

T-SQL

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

T-SQL

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
SQL SERVER Script
SQL SERVER Script
 
 
SQL Server应用实例
SQL Server应用实例
 
 
T-SQL练习
T-SQL练习
 
 
Appendix A - Logic Puzzles.sql
Appendix A - Logic Puzzles.sql
 
 
Chapter 01 - Logical Query Processing.sql
Chapter 01 - Logical Query Processing.sql
 
 
Chapter 02 - Set Theory and Predicate Logic.sql
Chapter 02 - Set Theory and Predicate Logic.sql
 
 
Chapter 03 - Relational Model.sql
Chapter 03 - Relational Model.sql
 
 
Chapter 04 - Query Tuning.sql
Chapter 04 - Query Tuning.sql
 
 
Chapter 05 - Algorithms and Complexity.sql
Chapter 05 - Algorithms and Complexity.sql
 
 
Chapter 06 - Subqueries, Table Expressions and Ranking Functions.sql
Chapter 06 - Subqueries, Table Expressions and Ranking Functions.sql
 
 
Chapter 07 - Joins and Set Operations.sql
Chapter 07 - Joins and Set Operations.sql
 
 
Chapter 08 - Aggregating and Pivoting Data.sql
Chapter 08 - Aggregating and Pivoting Data.sql
 
 
Chapter 09 - TOP and APPLY.sql
Chapter 09 - TOP and APPLY.sql
 
 
Chapter 10 - Data Modification.sql
Chapter 10 - Data Modification.sql
 
 
Chapter 11 - Querying Partitioned Tables.sql
Chapter 11 - Querying Partitioned Tables.sql
 
 
Chapter 12 - Graphs, Trees, Hierarchies and Recursive Queries.sql
Chapter 12 - Graphs, Trees, Hierarchies and Recursive Queries.sql
 
 
F分灌保管帐_液位仪失败.sql
F分灌保管帐_液位仪失败.sql
 
 
F分灌保管帐_盘点后帐存不对.sql
F分灌保管帐_盘点后帐存不对.sql
 
 
InsideTSQL2008.sql
InsideTSQL2008.sql
 
 
J交班日期修改.sql
J交班日期修改.sql
 
 
MSSQL死锁.sql
MSSQL死锁.sql
 
 
MaintenanceSolution.sql
MaintenanceSolution.sql
 
 
Microsoft SQL Server 2008技术内幕：T-SQL查询.pdf
Microsoft SQL Server 2008技术内幕：T-SQL查询.pdf
 
 
OAsyncAD.sql
OAsyncAD.sql
 
 
OA死锁检查.sql
OA死锁检查.sql
 
 
Readme.txt
Readme.txt
 
 
SQL Server 管理 （常用管理及维护命令）.sql
SQL Server 管理 （常用管理及维护命令）.sql
 
 
SQL 账号锁定.sql
SQL 账号锁定.sql
 
 
SQL开启xp_cmdshell.sql
SQL开启xp_cmdshell.sql
 
 
SQL获取日期函数应用.sql
SQL获取日期函数应用.sql
 
 
V1.4_01.sql
V1.4_01.sql
 
 
WsusDBMaintenance.sql
WsusDBMaintenance.sql
 
 
bcp 导出数据.sql
bcp 导出数据.sql
 
 
c_invoice.sql
c_invoice.sql
 
 
dbcc.sql
dbcc.sql
 
 
diff tables.sql
diff tables.sql
 
 
send datetime.sql
send datetime.sql
 
 
spDeleteUpdate .sql
spDeleteUpdate .sql
 
 
sp_configure 开启AgentXPs.sql
sp_configure 开启AgentXPs.sql
 
 
sql query diff.sql
sql query diff.sql
 
 
sql server阻塞查询语句 .sql
sql server阻塞查询语句 .sql
 
 
t-sql-shrinkfile-log.sql
t-sql-shrinkfile-log.sql
 
 
删除无用有枪_付油信息红叉.sql
删除无用有枪_付油信息红叉.sql
 
 
孤立用户问题.sql
孤立用户问题.sql
 
 
延迟添加索引.sql
延迟添加索引.sql
 
 
收缩日志.sql
收缩日志.sql
 
 
日志收缩.sql
日志收缩.sql
 
 
查tables大小.sql
查tables大小.sql
 
 
查表名称.sql
查表名称.sql
 
 
查表结构.sql
查表结构.sql
 
 
检查数据库状态.sql
检查数据库状态.sql
 
 
死锁进程.sql
死锁进程.sql
 
 
清除 SQL Server 错误日志文件 存档.sql
清除 SQL Server 错误日志文件 存档.sql
 
 
相同表求差异.sql
相同表求差异.sql
 
 
脱敏脚本.sql
脱敏脚本.sql
 
 
表属性.sql
表属性.sql
 
 
表数量.sql
表数量.sql
 
 
设置日志大小.sql
设置日志大小.sql
 
 
谁占用了我的Buffer Pool.sql
谁占用了我的Buffer Pool.sql
 
 
返回最早的活动事务.sql
返回最早的活动事务.sql
 
 

Readme.txt

1. Following files contain source code for corresponding chapters:

Chapter 01 - Logical Query Processing.sql
Chapter 02 - Set Theory and Predicate Logic.sql
Chapter 03 - Relational Model.sql
Chapter 04 - Query Tuning.sql
Chapter 05 - Algorithms and Complexity.sql
Chapter 06 - Subqueries, Table Expressions and Ranking Functions.sql
Chapter 07 - Joins and Set Operations.sql
Chapter 08 - Aggregating and Pivoting Data.sql
Chapter 09 - TOP and APPLY.sql
Chapter 10 - Data Modification.sql
Chapter 11 - Querying Partitioned Tables.sql
Chapter 12 - Graphs, Trees, Hierarchies and Recursive Queries.sql

2. Run the code in file InsideTSQL2008.sql to create the book's sample database InsideTSQL2008.

3. Copy the files from the folder temp to c:\temp.
   Those files are used in some of the code samples in Chapter 10.