1.SQL Server - 文章分类 - 查祝兆

Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues

摘要：sql server,RESOURCE_SEMAPHORE 阅读全文

posted @ 2017-06-14 17:24 查祝兆阅读(222) 评论(0) 推荐(0)

摘要：Lock compatibility controls whether multiple transactions can acquire locks on the same resource at the same time. If a resource is already locked by 阅读全文

posted @ 2016-03-16 18:23 查祝兆阅读(353) 评论(0) 推荐(0)

Reading the SQL Server log files using TSQL

posted @ 2015-09-08 12:20 查祝兆阅读(217) 评论(0) 推荐(0)

Using Change Data Capture (CDC) in SQL Server 2008

摘要：Link:http://www.mssqltips.com/sqlservertip/1474/using-change-data-capture-cdc-in-sql-server-2008/ProblemAs we are looking through the new features in ... 阅读全文

posted @ 2015-01-27 22:22 查祝兆阅读(257) 评论(0) 推荐(0)

Fix SQL Server Agent on Windows Failover Cluster

摘要：原文链接ProblemI was trying to install SQL Server 2008 R2 on a Windows Server 2008 R2 Failover Cluster, but the setup did not complete successfully. Upon ... 阅读全文

posted @ 2014-12-24 17:23 查祝兆阅读(742) 评论(1) 推荐(0)

Solution : Cannot add new node – Rule "SQL Server Database Services feature state" failed.

摘要：原文链接已测试，如果在主节点中都修复了的话，直接改注册表可以搞定。While deploying SQL Server 2014 cluster in my lab I ran into this problem when I was trying to add second node (Node ... 阅读全文

posted @ 2014-12-24 16:09 查祝兆阅读(338) 评论(0) 推荐(0)

SQL Server Failover Cluster (FCI) installations is the failure of the Network Name

摘要：Orignal Link :CSS SQL Server EngineersThis is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provid... 阅读全文

posted @ 2014-12-24 16:06 查祝兆阅读(212) 评论(0) 推荐(0)

SQL Server install SkipRules Cluster_VerifyForErrors or RebootRequiredCheck

摘要：官方地址若要解决此问题，您必须解决导致验证失败的问题。如果可以确定可以稍后修正导致验证失败的问题，您可能需要使用命令行安装选项，本文中忽略该错误消息，并尝试安装 SQL Server 2008年故障转移群集实例。如果您这样做，请使用系统之前再次您仍然必须解决导致验证失败的基础问题。注意如果您尝试使... 阅读全文

posted @ 2014-12-16 17:17 查祝兆阅读(772) 评论(0) 推荐(0)

删除SQL Server的邮件队列。

摘要：英文源地址：Remove unsent database email from SQL Server如果一不小心，在SQL Server中发送了上千个邮件，那么可以用如下语句清除未发送到邮件项目。SELECT * FROM msdb.dbo.sysmail_event_log;-- To get n... 阅读全文

posted @ 2014-10-28 18:51 查祝兆阅读(1102) 评论(0) 推荐(0)

数据库中使用正则表达式

摘要：数据库中使用正则表达式代码--打开高级选项 sp_configure 'show advanced options',1 reconfigure --设置选项打开 sp_configure 'Ole Automation Procedures',1 reconfigure 阅读全文

posted @ 2011-01-27 11:25 查祝兆阅读(5500) 评论(0) 推荐(1)

查询有一个服务器几个数据库

摘要：查询有一个服务器几个数据库： declare @a varchar(8000) set @a='' select @a=@a+','+name from sysdatabases where dbid=6 order by name print substring(@a,2,len(@a)-1) select * from master.dbo.sysdatabases where dbid=6 order by name dbid用来选择非系统库。阅读全文

posted @ 2011-01-27 11:19 查祝兆阅读(338) 评论(0) 推荐(0)

Select语句的处理顺序

摘要：阅读全文

posted @ 2011-01-27 10:22 查祝兆阅读(201) 评论(0) 推荐(0)

文章分类 - 1.SQL Server