Skip to main content

tommy Qin's Library tagged sql → View Popular

Filter:
All
Annotated

24 Jan 09

SQL Server 2008 Videos, Virtual Labs, and Online Training

www.microsoft.com/...technetsqlserver2008.aspx - Preview

sql Webcasts bi

12 Sep 07

启用对 4 GB 以上物理内存的支持

msdn2.microsoft.com/...ms179301.aspx - Preview

sql vmware win2k

如何配置 awe enabled 选项
必须授予“锁定内存页”权限
1 more annotations...
- awe enabled 选项设置为 1

30 Jun 07

TRY...CATCH (Transact-SQL)

msdn2.microsoft.com/...ms175976.aspx - Preview

不能跨越多个批处理

27 Mar 07

可缩放共享数据库 Scalable Shared Databases

msdn2.microsoft.com/...ms345584.aspx - Preview

可缩放共享数据库

17 Jan 07

创建索引视图

msdn2.microsoft.com/...ms191432.aspx - Preview

UNIQUE CLUSTERED INDEX IDX_V1
ON Sales.vOrders

Index with Included Columns

msdn2.microsoft.com/...ms190806.aspx - Preview

INCLUDE (FileName);
adding nonkey columns to the leaf level of the nonclustered index

创建聚集索引

msdn2.microsoft.com/...ms186342.aspx - Preview

Preparation Guide for Exam 70-431: TS: Microsoft SQL Server 2005—Implementation and Maintenance

www.microsoft.com/...70-431.mspx - Preview

partitions
full-text search
35 more annotations...
- user-defined types
- indexes
- constraints
- stored procedures
- functions
- triggers
- a view.
- table
- using DMVs
- Agent job history
- server errors
- blocks and deadlocks
- Database Engine Tuning Advisor
- Profiler
- performance and optimization
- Move a database
- Restore
- Back up
- Transact-SQL.
- Agent jobs.
- replication
- Import and export
- HTTP endpoint
- linked servers
- Management Studio
- security
- Configure
- Install
- mirroring.
- log shipping.
- snapshots
- queries
- Manipulate
- XML data
- Service Broker

全文搜索查询

msdn2.microsoft.com/...ms142583.aspx - Preview

SQL Server 会从搜索词中去掉干扰词。
（加权词）。
6 more annotations...
- （邻近词）。
- （前缀词）。
- （同义词库）
- （派生词）。
- （简单词条
- CONTAINS 谓词

比较全文函数与全文谓词

msdn2.microsoft.com/...ms142494.aspx - Preview

全文谓词 CONTAINS 和 FREETEXT
CONTAINSTABLE 和 FREETEXTTABLE 函数

如何查看日志传送报告 (SQL Server Management Studio)

msdn2.microsoft.com/...ms181149.aspx - Preview

“摘要”页中，单击“报告”按钮旁边的箭头

16 Jan 07

检测和处理媒体错误

msdn2.microsoft.com/...ms189055.aspx - Preview

备份校验和

Understanding Non-uniform Memory Access

msdn2.microsoft.com/...ms178144.aspx - Preview

non-uniform memory access (NUMA) aware

配置高可用性

msdn2.microsoft.com/...ms190202.aspx - Preview

数据库镜像相对于日志传送的优势

SQL Server: Upgrade Your Skills To 2005

www.microsoft.com/...technetsqlserver2005.mspx - Preview

New in the Database Storage Engine
CLR Integration
55 more annotations...
- Performance Problems
- Supportability Features
- Tuning Advisor
- Performance Diagnosis
- Upgrade Process
- Choosing the SQL Server 2005 Edition
- Ad-Hoc Reporting
- Preparing to Migrate
- Strategies and Tools
- Transparent Benefits
- Query Optimizer Statistics
- SQL Server Agent
- Tempdb
- Windows Server 2003 R2 Enterprise Edition
- Storage Area Networks
- Business Intelligence Solutions
- for SAP Applications
- Replicating Data Between Oracle
- Existing Information in IBM DB2
- Microsoft IT Runs SAP
- Oracle Data
- Data in Mainframe VSAM
- Non-Standard Data Sources
- Heterogeneous Data
- Data Quality and Compliance
- New Application Design Patterns
- Snapshot Isolation and Row Level Versioning
- Database Mirroring
- : Data Recovery
- Clustering
- Peer-to-Peer Replication
- High Availability Features
- Data Protection Manager
- Express Edition
- Financial Services
- Moving Data
- High Availability
- Data Recovery
- Monitoring
- Partitioning
- Protecting
- Concurrency
- Securing
- Indexing
- Best Practices
- Mirroring
- Availability
- Recovering
- Service Broker (Level 200)
- Overview
- Security
- Installation Options
- Upgrade Considerations
- Management Tools
- for CRM

Memory Architecture

msdn2.microsoft.com/...ms187499.aspx - Preview

Address Windowing Extensions

15 Jan 07

第 1 课：使用合并复制发布数据

msdn2.microsoft.com/...aa337473.aspx - Preview

“发布类型”页

如何配置发布以允许使用 Web 同步 (SQL Server Management Studio)

msdn2.microsoft.com/...ms345211.aspx - Preview

如何为 Web 同步配置 IIS。
服务器名称必须与为 IIS 创建安全套接字层 (SSL) 证书时所使用的名称相同
5 more annotations...
- https://server.domain.com:PortNumber/directory/replisapi.dll
- 订阅服务器应连接的 Web 服务器的地址
- 允许订阅服务器通过连接到 Web 服务器进行同步
- <发布>”对话框的“FTP 快照和 Internet”页
- 如何创建发布和定义项目

配置 Web 同步

msdn2.microsoft.com/...ms151255.aspx - Preview

合并复制的 Web 同步

msdn2.microsoft.com/...ms151763.aspx - Preview

合并复制协调器
将上载更改应用
3 more annotations...
- 复制侦听器
- 合并代理在订阅服务器上
- 不适于大容量服务器对服务器应用程序

1 - 20 of 93 Next › Last »

Showing 20▼ items per page

Selected Tags

sql

Related Tags

Sponsored Links

Ads by Google

Top Contributors

Click in to find related links.

See more »

Groups interested in sql

Coders

Members (325)

bookmarks (1622)
SQL Server

Members (18)

bookmarks (26)
City of Mankato .NET

Members (2)

bookmarks (86)

See more »

Related Lists on Diigo

OracleDBA

List for all things related...

Items: 31 | Visits: 68

Created by: Jason Williams
eBooks Space for download FREE!!

Many eBooks files Space for...

Items: 1 | Visits: 72

Created by: Kim So Hee
SQL Injection Cheat Sheets

SQL Injection Cheat Sheets

Items: 13 | Visits: 77

Created by: F M

See more »

Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »

Join Diigo