SQL Server

[tips]SQL 2005 AND 2008
摘要: SQL tips 阅读全文
posted @ 2010-05-26 08:52 On the road.... 阅读(70) | 评论 (0) 编辑
用SQL语句替代CURSOR
摘要: CURSOR --> SQL阅读全文
posted @ 2009-06-01 00:02 On the road.... 阅读(127) | 评论 (0) 编辑
444.Plan guide
摘要: guide plan阅读全文
posted @ 2009-05-19 10:09 On the road.... 阅读(78) | 评论 (0) 编辑
444.Counters of SQL Server 2005
摘要: SQL Server Counter阅读全文
posted @ 2009-05-04 21:20 On the road.... 阅读(62) | 评论 (0) 编辑
一个权限的设置，你会混淆么
posted @ 2009-04-20 12:28 On the road.... 阅读(169) | 评论 (0) 编辑
443 Chapter9.Database Mirroring
posted @ 2009-04-16 17:27 On the road.... 阅读(136) | 评论 (0) 编辑
443 Chapter8. Failover clustering -- not completed
posted @ 2009-04-16 17:25 On the road.... 阅读(24) | 评论 (0) 编辑
443 Chapter7.Planning for High Availability in the Enterprise
posted @ 2009-04-16 17:22 On the road.... 阅读(71) | 评论 (0) 编辑
443 Chapter6.Designing Database Security
posted @ 2009-04-16 17:17 On the road.... 阅读(142) | 评论 (0) 编辑
443 CHapter5.Designing SQL Server Endpoints
posted @ 2009-04-16 17:16 On the road.... 阅读(151) | 评论 (0) 编辑
443 Chapter4.Designing Database Server Security Policies
posted @ 2009-04-16 17:15 On the road.... 阅读(169) | 评论 (0) 编辑
443.Chapter3
posted @ 2009-04-16 17:12 On the road.... 阅读(96) | 评论 (0) 编辑
443.Chapter2 布署与合并多个数据库实例
posted @ 2009-04-16 17:11 On the road.... 阅读(63) | 评论 (0) 编辑
[Reference]SQL Server tempdb optimization tips
摘要: SQL Server 2005 tempdb optimization阅读全文
posted @ 2009-04-15 22:46 On the road.... 阅读(78) | 评论 (0) 编辑
431.Chapter18.Implementing log shipping
摘要: Log Shipping story阅读全文
posted @ 2009-03-05 18:41 On the road.... 阅读(52) | 评论 (0) 编辑
SQL Server Logins, Database Users, Database Roles and Schemas
摘要: 一直以为自己很明白，其实那时自以为是。今天梳理了一下相关知识，总算是小有收获，赶紧记下，以便日后查阅。 阅读全文
posted @ 2009-03-04 19:51 On the road.... 阅读(169) | 评论 (0) 编辑
SQL.CLR
摘要: User-defined function via CLR阅读全文
posted @ 2009-03-04 15:53 On the road.... 阅读(22) | 评论 (0) 编辑
431.chapter14.working with SQL Server Performance
摘要: SQL server performance阅读全文
posted @ 2009-02-28 19:07 On the road.... 阅读(20) | 评论 (0) 编辑
431.chapter14.working with SQL Server Agent job
摘要: SQL Server Agent detail阅读全文
posted @ 2009-02-28 16:01 On the road.... 阅读(73) | 评论 (0) 编辑
431.chapter12.Working with HTTP Endpoints
摘要: understanding HTTP Endpoint security and create a http endpoint which can be vistion through a client by sending SOAP request阅读全文
posted @ 2009-02-27 12:23 On the road.... 阅读(69) | 评论 (0) 编辑
431.chapter10. working with flat files
摘要: 1 准备工作 2 bcp 3 bulk insert 4 bulk xml 5 ssis import/export阅读全文
posted @ 2009-02-26 16:07 On the road....| 编辑
431.chapter2.configure database recovery model
摘要: SQL Server Recovery Mode阅读全文
posted @ 2009-02-26 14:23 On the road....| 编辑