<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cs9088的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cs9088</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cs9088]]></copyright><item><title><![CDATA[HANA密码策略更改]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197058</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197058</guid><author>cs9088</author><pubDate>Tue, 19 Sep 2017 10:35:44 +0800</pubDate><description><![CDATA[近些日子hana数据库出现密码要过期的情况，修订之后将配置发出来，供以后参考


                                                            
        ...]]></description><category></category></item><item><title><![CDATA[sqlserver数据规范二： 数据库级代码规范]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197056</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197056</guid><author>cs9088</author><pubDate>Thu, 20 Apr 2017 14:15:05 +0800</pubDate><description><![CDATA[需求：翻译Pinal Dave pinal@sqlauthortiy.com大师的代码规范，借鉴并规范公司数据库开发。

1： 为sqlserver的数据库对象使用pascal 标准，表，视图 应该使用字母s结尾。...]]></description><category></category></item><item><title><![CDATA[SQLSERVER2008 errorlog 过大导致数据库无法启动]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197031</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197031</guid><author>cs9088</author><pubDate>Thu, 20 Apr 2017 14:13:07 +0800</pubDate><description><![CDATA[今天早上应用发现数据库无法连接，


	重启了主机之后，发现数据库服务无法启动，启动服务 报17058 错误


	查看权限都正常。


	


	进入：C:\Program Files\Micr...]]></description><category></category></item><item><title><![CDATA[check约束字段只存字母]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197034</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197034</guid><author>cs9088</author><pubDate>Tue, 10 Jan 2017 22:10:41 +0800</pubDate><description><![CDATA[check constrint 只存字母的约束：

	
		
			
				
					createtablet(idint,enamevarchar2(30)
check(replace...]]></description><category></category></item><item><title><![CDATA[查看用户连接到特定数据库]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197063</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197063</guid><author>cs9088</author><pubDate>Tue, 10 Jan 2017 15:17:32 +0800</pubDate><description><![CDATA[平时运维中，要发现用户连接到哪个数据库，使用dmv 视图达不到需要的 关键信息：
比如主机名，进程号等。

使用如下sql，可以查到主机名和应用程序和本地进程号，如果确认该连接是非法的，可以进行kill。

	
		...]]></description><category></category></item><item><title><![CDATA[sqlserver 查看备份日志脚本]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197035</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197035</guid><author>cs9088</author><pubDate>Wed, 04 Jan 2017 15:13:35 +0800</pubDate><description><![CDATA[sqlserver 查看备份日志脚本
----------------------------------------------
SELECT CONVERT(CHAR(100), Serverproperty('Serv...]]></description><category></category></item><item><title><![CDATA[sqlserver 用户初始化]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197033</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197033</guid><author>cs9088</author><pubDate>Wed, 28 Dec 2016 08:59:43 +0800</pubDate><description><![CDATA[use dbname;
go
exec sp_addlogin '登录名','密码','数据库名'                      
exec sp_grantdbac...]]></description><category></category></item><item><title><![CDATA[sqlserver查询当前运行的sql]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197029</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197029</guid><author>cs9088</author><pubDate>Mon, 26 Dec 2016 16:34:59 +0800</pubDate><description><![CDATA[sqlserver查询当前运行的sql
	
		
			
				
					WITH sess AS
(
  SELECT
    es.session_id,
    databa...]]></description><category></category></item><item><title><![CDATA[删除sqlserver 错误日志。]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197025</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197025</guid><author>cs9088</author><pubDate>Mon, 19 Dec 2016 12:10:51 +0800</pubDate><description><![CDATA[由于默认情况下，SQL Server 保存 7 个 ErrorLog 文件，名为：

ErrorLog
ErrorLog.1
ErrorLog.2
ErrorLog.3
ErrorLog.4
ErrorLog.5...]]></description><category></category></item><item><title><![CDATA[删除系统账号导致sqlserver无法操作系统验证的解决办法]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197057</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197057</guid><author>cs9088</author><pubDate>Mon, 19 Dec 2016 12:06:49 +0800</pubDate><description><![CDATA[SQLSERVER2008：
1: 主机名A ，修改为B ,未重启
2：安装数据库
3：select @@servername 为 A
4: sp_dropserver 'A'
 sp_addserver 'B',...]]></description><category></category></item><item><title><![CDATA[[SQL Server]镜像监视器的使用和配置]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197024</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197024</guid><author>cs9088</author><pubDate>Mon, 19 Dec 2016 10:58:25 +0800</pubDate><description><![CDATA[在两台机器上配好sql server 镜像
发现在 “数据库镜像监视器”中，另一台服务器的状态始终为“未连接”.


解决方法为： 将“未连接”的那个数据库服务器，在这个“镜像监视器”中注册一下，(另外也要在两台服...]]></description><category></category></item><item><title><![CDATA[sqlserverSMSS登录 18456 错误]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197030</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197030</guid><author>cs9088</author><pubDate>Fri, 16 Dec 2016 14:36:38 +0800</pubDate><description><![CDATA[SQLSERVER2008：
1: 主机名A ，修改为B ,未重启
2：安装数据库
3：select @@servername 为 A
4: sp_dropserver 'A'
 sp_addserver 'B',...]]></description><category></category></item><item><title><![CDATA[sqlserver数据规范一：  表添加注释信息]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197026</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197026</guid><author>cs9088</author><pubDate>Wed, 07 Dec 2016 12:43:31 +0800</pubDate><description><![CDATA[数据规范一：sqlserver 表添加注释信息
添加注释：

方法1：建表之后添加注释信息
调用系统存储过程sp_addextendedproperty来添加注释，
例子：
表Employee 加注释"雇员信...]]></description><category></category></item><item><title><![CDATA[hana体系结构（二）]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197022</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197022</guid><author>cs9088</author><pubDate>Mon, 31 Oct 2016 15:59:08 +0800</pubDate><description><![CDATA[上一篇了解了hana组件名称，但是每个组件具体用于什么，只是用了几句话描述。
下面我们来看看hana database各个组件是怎么协调工作的

Server Architecture of Multiple-Conta...]]></description><category></category></item><item><title><![CDATA[HANA 体系结构（一）]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197028</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197028</guid><author>cs9088</author><pubDate>Mon, 31 Oct 2016 14:36:15 +0800</pubDate><description><![CDATA[An SAP HANA system comprises all the server components of an installation of SAP HANA.
An SAP HANA system consist...]]></description><category></category></item><item><title><![CDATA[实现某schema下类似TEST_UNION(01-0n)的聚合统计]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197027</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197027</guid><author>cs9088</author><pubDate>Thu, 28 Jul 2016 15:35:49 +0800</pubDate><description><![CDATA[####################################################################################################
#desc : 实现某s...]]></description><category></category></item><item><title><![CDATA[LINUX内核参数FOR oracle]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197059</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197059</guid><author>cs9088</author><pubDate>Tue, 24 May 2016 08:57:06 +0800</pubDate><description><![CDATA[Oracle 不同平台的数据库安装指导为我们部署Oracle提供了一些系统参数设置的建议值，然而建议值是在通用的情况下得出的结论，并非能完全满足不同的需求。使用不同的操作系统内核参数将使得数据库性能相差甚远。本文描述了linu...]]></description><category></category></item><item><title><![CDATA[sysaux tablespace清理 in oracle11.2.0.3]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197023</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197023</guid><author>cs9088</author><pubDate>Mon, 18 Jan 2016 15:19:09 +0800</pubDate><description><![CDATA[sysaux 表空间使用率异常，到底是什么数据导致呢？请查询如下sql：

set line 150
col Schema for a30
col Item for a30
col "Move Proc...]]></description><category></category></item><item><title><![CDATA[BUG: Minact-Scn Master-Status: Grec-Scn Messages In Trace File (ID 1361567.1)]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197018</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197018</guid><author>cs9088</author><pubDate>Fri, 15 Jan 2016 11:12:06 +0800</pubDate><description><![CDATA[1* select * from DBA_REGISTRY_HISTORY
SQL&gt; /


ACTION_TIME          ACTION   NAMESPACE VERSI...]]></description><category></category></item><item><title><![CDATA[oracle备份恢复系列2--不完全恢复]]></title><link>https://blog.youkuaiyun.com/cs9088/article/details/100197019</link><guid>https://blog.youkuaiyun.com/cs9088/article/details/100197019</guid><author>cs9088</author><pubDate>Fri, 08 Jan 2016 17:46:49 +0800</pubDate><description><![CDATA[[oracle@HQ-VRW-Linux6 backup]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 8 17:24...]]></description><category></category></item></channel></rss>