随笔分类 -  sqlserver

sqlserver
max of bigint sql server
摘要：select cast(0x7fffffffffffffff as bigint) =9223372036854775807 阅读全文

posted @ 2019-05-21 16:11 5w 阅读(94) 评论(0) 推荐(0)

Database last Accessed
摘要：P.S when restart sql server, it will reset all data select d.name, x1 = (select X1 = max(bb.xx) from ( select xx = max(last_user_seek) where max(last_ 阅读全文

posted @ 2019-01-25 17:44 5w 阅读(93) 评论(0) 推荐(0)

Batch update table use MERGE and MAXDOP
只有注册用户登录后才能阅读该文。

posted @ 2018-07-20 10:51 5w 阅读(3) 评论(0) 推荐(0)

Find busy tables
摘要：Find busy tables 阅读全文

posted @ 2018-07-19 16:00 5w 阅读(104) 评论(0) 推荐(0)

shrink log size for large size db
摘要：shrink log size for large size db 阅读全文

posted @ 2018-07-19 14:42 5w 阅读(120) 评论(0) 推荐(0)

Create in-memory database by BAT
只有注册用户登录后才能阅读该文。

posted @ 2018-07-19 10:58 5w 阅读(4) 评论(0) 推荐(0)

Update table statistics and recompile all stored procedures
只有注册用户登录后才能阅读该文。

posted @ 2018-07-19 10:29 5w 阅读(2) 评论(0) 推荐(0)

Drop all DB objects
摘要：删除所有数据库对象 阅读全文

posted @ 2018-07-17 16:14 5w 阅读(113) 评论(0) 推荐(0)

Default trace log
摘要：Default Trace 阅读全文

posted @ 2018-07-17 11:30 5w 阅读(141) 评论(0) 推荐(0)

导航