<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Bean]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/bean_sql</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; bean_sql]]></copyright><item><title><![CDATA[性能优化-转载篇]]></title><link>https://blog.csdn.net/bean_sql/article/details/50231967</link><guid>https://blog.csdn.net/bean_sql/article/details/50231967</guid><author>bean_sql</author><pubDate>Wed, 09 Dec 2015 09:33:53 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/marvin/p/4123745.html]]></description><category></category></item><item><title><![CDATA[Windows 负载均衡集群]]></title><link>https://blog.csdn.net/bean_sql/article/details/21242349</link><guid>https://blog.csdn.net/bean_sql/article/details/21242349</guid><author>bean_sql</author><pubDate>Fri, 14 Mar 2014 17:01:24 +0800</pubDate><description><![CDATA[http://you.video.sina.com.cn/m/1884475400]]></description><category></category></item><item><title><![CDATA[解决死锁问题]]></title><link>https://blog.csdn.net/bean_sql/article/details/11252081</link><guid>https://blog.csdn.net/bean_sql/article/details/11252081</guid><author>bean_sql</author><pubDate>Fri, 06 Sep 2013 17:34:39 +0800</pubDate><description><![CDATA[http://www.52mvc.com/showtopic-3035.aspx]]></description><category></category></item><item><title><![CDATA[根据表名称找索引及对应列名]]></title><link>https://blog.csdn.net/bean_sql/article/details/8990921</link><guid>https://blog.csdn.net/bean_sql/article/details/8990921</guid><author>bean_sql</author><pubDate>Wed, 29 May 2013 19:40:08 +0800</pubDate><description><![CDATA[--结合sys.indexes和sys.index_columns,sys.objects,sys.columns查询索引所属的表或视图的信息
select
  o.name as 表名,
  i.name as 索引名,
  c.name as 列名,
  i.type_desc as 类型描述,
  is_primary_key as 主键约束,
  is_unique_constraint]]></description><category></category></item><item><title><![CDATA[根据表名 生成Create创建脚本]]></title><link>https://blog.csdn.net/bean_sql/article/details/8961680</link><guid>https://blog.csdn.net/bean_sql/article/details/8961680</guid><author>bean_sql</author><pubDate>Wed, 22 May 2013 17:53:42 +0800</pubDate><description><![CDATA[declare @sql varchar(8000),@tablename varchar(100)
set @tablename ='test'--这里输入表名
set @sql = 'create table ['+@tablename+'] 
(
'
select @sql = @sql + b.name + ' '+
       c.name+
       case when c.co]]></description><category></category></item><item><title><![CDATA[表数据生成 insert 语句]]></title><link>https://blog.csdn.net/bean_sql/article/details/8961464</link><guid>https://blog.csdn.net/bean_sql/article/details/8961464</guid><author>bean_sql</author><pubDate>Wed, 22 May 2013 17:16:48 +0800</pubDate><description><![CDATA[表数据生成 insert 语句]]></description><category></category></item><item><title><![CDATA[数据库对象关系查询]]></title><link>https://blog.csdn.net/bean_sql/article/details/8956721</link><guid>https://blog.csdn.net/bean_sql/article/details/8956721</guid><author>bean_sql</author><pubDate>Tue, 21 May 2013 18:02:54 +0800</pubDate><description><![CDATA[/*
	sql_expression_dependencies 视图记录了该数据库的所有对象和引用对象关系，
	通过调用递归功能，
	可以找到所有对象
*/
with cte as
(
	SELECT 
		OBJECT_NAME(referencing_id) AS referencing_entity_name, 
		sed.referenced_entity_name,
		xtype]]></description><category></category></item><item><title><![CDATA[SQL Server 2008中SQL应用之－“阻塞(Blocking)”]]></title><link>https://blog.csdn.net/bean_sql/article/details/8924644</link><guid>https://blog.csdn.net/bean_sql/article/details/8924644</guid><author>bean_sql</author><pubDate>Tue, 14 May 2013 11:18:28 +0800</pubDate><description><![CDATA[SQL Server 2008中SQL应用之－“阻塞(Blocking)”]]></description><category></category></item><item><title><![CDATA[将表中数据生成SQL语句]]></title><link>https://blog.csdn.net/bean_sql/article/details/8920861</link><guid>https://blog.csdn.net/bean_sql/article/details/8920861</guid><author>bean_sql</author><pubDate>Mon, 13 May 2013 15:23:14 +0800</pubDate><description><![CDATA[CREATE PROCEDURE dbo.UspOutputData 
 @tablename sysname 
 AS 
 declare @column varchar(1000) 
 declare @columndata varchar(1000) 
 declare @sql varchar(4000) 
 declare @xtype tinyint 
 declare @name s]]></description><category></category></item><item><title><![CDATA[SQL server 服务器性能优化]]></title><link>https://blog.csdn.net/bean_sql/article/details/8909631</link><guid>https://blog.csdn.net/bean_sql/article/details/8909631</guid><author>bean_sql</author><pubDate>Fri, 10 May 2013 10:43:08 +0800</pubDate><description><![CDATA[解决SQL Server性能问题的关键是确定瓶颈在哪里，最容易造成瓶颈的顺序是：
磁盘I/O > CPU >　RAM > 用户连接数 > 网络带宽

对于大的数据库，有些地方要注意一下：
1) 定期 DBCC CHECKDB
 (建议在服务器负荷较少的时候运行 DBCC CHECKDB。如果在负荷高峰期运行 DBCC CHECKDB，那么事务吞吐量性能和 DBCC CHECKDB 完成时]]></description><category></category></item><item><title><![CDATA[Windows 性能监视器的基本指标（CPU,内存,硬盘参数）]]></title><link>https://blog.csdn.net/bean_sql/article/details/8906108</link><guid>https://blog.csdn.net/bean_sql/article/details/8906108</guid><author>bean_sql</author><pubDate>Thu, 09 May 2013 15:48:45 +0800</pubDate><description><![CDATA[作为一个系统工程师来说，要看懂监控的数据至关重要，关系着优化和分析出现的问题，因此，今天给出Windows 性能监视器的一些基本指标（CPU,内存,硬盘参数），希望对大家将来优化和分析问题提供帮忙。
Windows -Processor





指标名称

指标描述

指标范围

指标单位



CPU利用率
（% Processor Time）

% P]]></description><category></category></item><item><title><![CDATA[tempdb数据库简介及优化]]></title><link>https://blog.csdn.net/bean_sql/article/details/8900860</link><guid>https://blog.csdn.net/bean_sql/article/details/8900860</guid><author>bean_sql</author><pubDate>Wed, 08 May 2013 16:05:24 +0800</pubDate><description><![CDATA[ps:msdn摘
 tempdb数据库是一个特殊的数据库,它和其他数据库最大的不同之处在于SQL SERVER每次重启的时候它会被重建(不是恢复).

 

tempdb的特点:
 1.总是使用简单恢复模式.日志不断的被截断,因为需不要备份.它记录的信息只能用来回滚事务(只有最初数据,不包含更新后的新行),担不是恢复事务.

 2.某些数据库选项无法设置,比如OFFLINE REA]]></description><category></category></item><item><title><![CDATA[SQL2008 附加数据库提示 5120错误]]></title><link>https://blog.csdn.net/bean_sql/article/details/8706191</link><guid>https://blog.csdn.net/bean_sql/article/details/8706191</guid><author>bean_sql</author><pubDate>Fri, 22 Mar 2013 14:25:29 +0800</pubDate><description><![CDATA[在win7 x64系统上使用sql2008进行附加数据库（包括在x86系统正在使用的数据库文件，直接拷贝附加在X64系统中）时，提示无法打开文件，5120错误。

是因为没有操作权限，所以附加的时候出错，只要设置这个文件或文件夹安全属性即可。

解决办法：

1.打开该数据库文件存放的目录或数据库文件的属性窗口，选择“属性”菜单－>选择“安全”标签－>选择“编辑”按钮。

2.在选]]></description><category></category></item><item><title><![CDATA[Ad hoc update to system catalogs is not supported. 解决方案]]></title><link>https://blog.csdn.net/bean_sql/article/details/8230371</link><guid>https://blog.csdn.net/bean_sql/article/details/8230371</guid><author>bean_sql</author><pubDate>Tue, 27 Nov 2012 15:34:02 +0800</pubDate><description><![CDATA[执行如下脚本：exec sp_configure 'allow updates',0;

exec sp_configure 'show advanced options', 1;

reconfigure

exec sp_configure]]></description><category></category></item><item><title><![CDATA[SQL Server 如何启用CLR函数]]></title><link>https://blog.csdn.net/bean_sql/article/details/8211354</link><guid>https://blog.csdn.net/bean_sql/article/details/8211354</guid><author>bean_sql</author><pubDate>Thu, 22 Nov 2012 11:09:59 +0800</pubDate><description><![CDATA[exec sp_configure 'clr enabled'--查看状态
exec sp_configure 'clr enabled',1--1,启用clr,禁用clr  
reconfigure with override--按提示(配置选项 'clr enabled' 已从 0 更改为 1。请运行 RECONFIGURE 语句进行安装。)运行此句  
exec sp_configure ']]></description><category></category></item><item><title><![CDATA[启用 SQL Server 2008 R2 Service Broker]]></title><link>https://blog.csdn.net/bean_sql/article/details/8200428</link><guid>https://blog.csdn.net/bean_sql/article/details/8200428</guid><author>bean_sql</author><pubDate>Mon, 19 Nov 2012 17:19:34 +0800</pubDate><description><![CDATA[--------------------------------------------------
USE master;
GO
IF EXISTS (SELECT * FROM master.sys.endpoints
           WHERE name = N'InstTargetEndpoint')
     DROP ENDPOINT InstTargetEndpoint;
GO]]></description><category></category></item><item><title><![CDATA[（3期）传递字符，查找数据库相关表及字段值]]></title><link>https://blog.csdn.net/bean_sql/article/details/8076378</link><guid>https://blog.csdn.net/bean_sql/article/details/8076378</guid><author>bean_sql</author><pubDate>Tue, 16 Oct 2012 11:38:35 +0800</pubDate><description><![CDATA[if OBJECT_ID('sp_queryCharacter','P') is not null drop proc sp_queryCharacter
go
create proc sp_queryCharacter(@what varchar(800))
as
begin
	DECLARE @sql varchar(8000) 
	DECLARE TableCursor CURSOR LOC]]></description><category></category></item><item><title><![CDATA[（3期）计算两个时间差（*天*小时*分*秒）]]></title><link>https://blog.csdn.net/bean_sql/article/details/8076226</link><guid>https://blog.csdn.net/bean_sql/article/details/8076226</guid><author>bean_sql</author><pubDate>Tue, 16 Oct 2012 11:13:46 +0800</pubDate><description><![CDATA[if OBJECT_ID('fn_calcTime','fn') is not null drop function fn_calcTime
go
create function fn_calcTime(@dateStart datetime,@dateEnd Datetime)
returns varchar(128)
as
Begin
	declare @day int
	declare @h]]></description><category></category></item><item><title><![CDATA[SQL 如何强行更新 Identity列]]></title><link>https://blog.csdn.net/bean_sql/article/details/8048508</link><guid>https://blog.csdn.net/bean_sql/article/details/8048508</guid><author>bean_sql</author><pubDate>Mon, 08 Oct 2012 15:08:14 +0800</pubDate><description><![CDATA[--创建测试表
CREATE TABLE t1(ID int IDENTITY,A int)
GO
--插入记录
INSERT t1 VALUES(1)
GO

--1. 将IDENTITY(标识)列变为普通列
ALTER TABLE t1 ADD ID_temp int
GO

UPDATE t1 SET ID_temp=ID
ALTER TABLE t1 DROP COLUMN ID
EXEC]]></description><category></category></item><item><title><![CDATA[（2期）数据库还原（支持自动创建路径）]]></title><link>https://blog.csdn.net/bean_sql/article/details/8013769</link><guid>https://blog.csdn.net/bean_sql/article/details/8013769</guid><author>bean_sql</author><pubDate>Mon, 24 Sep 2012 17:35:16 +0800</pubDate><description><![CDATA[/*********************************************************************************************
Function：数据库备份（支持自动创建路径）
Author：Bean
Date:2012-09-24
****************************************************]]></description><category></category></item></channel></rss>