<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[aoyi6589的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/aoyi6589</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; aoyi6589]]></copyright><item><title><![CDATA[SQL Service can not be restarted due to errors of upgrade step]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969536</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969536</guid><author>aoyi6589</author><pubDate>Mon, 10 Dec 2018 14:51:00 +0800</pubDate><description><![CDATA[Errors:
Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 5833, state 1, severity 16. This is a serious error condition whic...]]></description><category></category></item><item><title><![CDATA[SQL Server-errors for exceptions, assertions, and hang conditions]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969534</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969534</guid><author>aoyi6589</author><pubDate>Wed, 12 Sep 2018 14:39:00 +0800</pubDate><description><![CDATA[From:https://support.microsoft.com/en-us/help/2028589/sql-server-reports-errors-for-exceptions-assertions-and-hang-condition



Symptoms




SQL Server records the following events in th...]]></description><category></category></item><item><title><![CDATA[SQL Server-The target principal name is incorrect. Cannot generate SSPI context]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969535</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969535</guid><author>aoyi6589</author><pubDate>Thu, 23 Aug 2018 15:37:00 +0800</pubDate><description><![CDATA[From:
https://blogs.msdn.microsoft.com/meer_alam/2015/05/10/the-target-principal-name-is-incorrect-cannot-generate-sspi-context/
Introducing the problem scenario
Yet another Kerberos authentic...]]></description><category></category></item><item><title><![CDATA[SQL Server-Restore master DB]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969532</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969532</guid><author>aoyi6589</author><pubDate>Tue, 07 Aug 2018 13:41:00 +0800</pubDate><description><![CDATA[转载于:https://www.cnblogs.com/roseHLF/p/9436536.html]]></description><category></category></item><item><title><![CDATA[SQL installation-VS Shell installation has failed with exit code 5]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969533</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969533</guid><author>aoyi6589</author><pubDate>Mon, 06 Aug 2018 13:22:00 +0800</pubDate><description><![CDATA[Background:
During the installation of SQL 2016 STD,there has one error raised,checked the log of installation,found below errors:

 TITLE: Microsoft SQL Server 2016 Setup---------------------...]]></description><category></category></item><item><title><![CDATA[Stop and delete trace session]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969530</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969530</guid><author>aoyi6589</author><pubDate>Thu, 02 Aug 2018 11:56:00 +0800</pubDate><description><![CDATA[转载于:https://www.cnblogs.com/roseHLF/p/9406333.html]]></description><category></category></item><item><title><![CDATA[SQL-replication errors,could not find stored procedure]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969531</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969531</guid><author>aoyi6589</author><pubDate>Thu, 26 Jul 2018 17:11:00 +0800</pubDate><description><![CDATA[Refer tohttps://www.mssqltips.com/sqlservertip/5107/resolve-sql-server-replication-error--could-not-find-stored-procedure-spmsupddbops/
Refer tohttps://docs.microsoft.com/en-us/sql/relational-...]]></description><category></category></item><item><title><![CDATA[数据库空间管理-学习笔记]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969528</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969528</guid><author>aoyi6589</author><pubDate>Thu, 19 Jul 2018 17:22:00 +0800</pubDate><description><![CDATA[来自《SQL Server 2012实施与管理实战指南》
1.数据文件的存储结构：
页：数据存储的基本单位是页，每一个页为8kb，每MB有128页。磁盘的IO操作在页级。每页开头是一个96字节的页头，用于存储页的系统信息，包括页码、页类型、页的可用空间，以及拥有该页的对象的分配单元ID。不同类型的数据存储在不同类型的页面里面。
(1) GAM(Global allocation m...]]></description><category></category></item><item><title><![CDATA[SQL I/O操作学习笔记]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969481</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969481</guid><author>aoyi6589</author><pubDate>Fri, 13 Jul 2018 14:41:00 +0800</pubDate><description><![CDATA[SQL Server在以下情况需要和硬盘进行交互：
1.对于内存当中没有缓存的数据，第一次访问时需要将数据所在的页面从数据文件中读取到内存里。
读取时以页面为最小单位。出于性能考虑，读取的数据可能不仅仅包含所请求的内存页，同时还包含了预读的内存页。读取的数量与用户需要需要访问和数据页面数量和buffer pool里面现有缓存的数量有关系。
2.在任何Insert\Update\De...]]></description><category></category></item><item><title><![CDATA[The process is running and is waiting for response from the server]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969480</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969480</guid><author>aoyi6589</author><pubDate>Thu, 12 Jul 2018 15:42:00 +0800</pubDate><description><![CDATA[Refer tohttp://sqlservercitation.com/2017/03/28/fix-replication-process-is-running-and-waiting-for-a-response-from-the-server/
For this case,sometimes it may caused by anyblocking processthat...]]></description><category></category></item><item><title><![CDATA[Operating system error 995(The I/O operation has been aborted because of either a thread)]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969529</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969529</guid><author>aoyi6589</author><pubDate>Thu, 12 Jul 2018 14:35:00 +0800</pubDate><description><![CDATA[Fromhttps://technet.microsoft.com/en-us/library/aa337272.aspx
MSSQLSERVER_3271



Other Versions






Topic Status:Some information in this topic is preview and subject to change i...]]></description><category></category></item><item><title><![CDATA[Grant permissions to multiple tables in a database]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969526</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969526</guid><author>aoyi6589</author><pubDate>Thu, 28 Jun 2018 10:42:00 +0800</pubDate><description><![CDATA[USE DBGO DECLARE @TableName  AS varchar(max)DECLARE @Script     AS varchar(max) DECLARE CurGrant CURSOR FORSELECT  nameFROM sys.tables WHERE  name LIKE '%Sales_%'OPEN CurGrantFETCH NEXT FROM CurG...]]></description><category></category></item><item><title><![CDATA[MSDB Database]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969527</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969527</guid><author>aoyi6589</author><pubDate>Wed, 27 Jun 2018 10:30:00 +0800</pubDate><description><![CDATA[From:https://docs.microsoft.com/en-us/sql/relational-databases/databases/msdb-database?view=sql-server-2017
Themsdbdatabase is used by SQL Server Agent for scheduling alerts and jobs and by ot...]]></description><category></category></item><item><title><![CDATA[Change Instance\database collation]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969524</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969524</guid><author>aoyi6589</author><pubDate>Tue, 26 Jun 2018 17:27:00 +0800</pubDate><description><![CDATA[Reference from below links:
http://www.itprotoday.com/microsoft-sql-server/seven-step-process-changing-databases-collation
https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collat...]]></description><category></category></item><item><title><![CDATA[Upgrading a Replication Topology to SQL Server 2016]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969525</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969525</guid><author>aoyi6589</author><pubDate>Thu, 07 Jun 2018 10:12:00 +0800</pubDate><description><![CDATA[From link :
https://blogs.msdn.microsoft.com/sql_server_team/upgrading-a-replication-topology-to-sql-server-2016/

SQL Server Replication provides multi-faceted data movement capabilities a...]]></description><category></category></item><item><title><![CDATA[SQL Profile trace run access grant]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969520</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969520</guid><author>aoyi6589</author><pubDate>Wed, 23 May 2018 11:50:00 +0800</pubDate><description><![CDATA[From:https://www.mssqltips.com/sqlservertip/3559/how-to-grant-permissions-to-run-sql-server-profiler-for-a-non-system-admin-user/
Steps to give access to run SQL Server Profiler for a non sa use...]]></description><category></category></item><item><title><![CDATA[Log Reuse Waits Explained: DATABASE_MIRRORING]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969523</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969523</guid><author>aoyi6589</author><pubDate>Wed, 16 May 2018 15:04:00 +0800</pubDate><description><![CDATA[From:http://sqlity.net/en/1843/log-reuse-waits-explained-database_mirroring/
Introduction
There are eight reasons SQL Server might report when it cannot truncate the transaction log. Any one of...]]></description><category></category></item><item><title><![CDATA[Log Reuse Waits Explained: ACTIVE_TRANSACTION]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969518</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969518</guid><author>aoyi6589</author><pubDate>Wed, 16 May 2018 15:02:00 +0800</pubDate><description><![CDATA[From:
http://sqlity.net/en/1839/log-reuse-waits-explained-active_transaction/
Introduction
There are eight reasons SQL Server might report when it cannot truncate the transaction log. Any one ...]]></description><category></category></item><item><title><![CDATA[Log Reuse Waits Explained: ACTIVE_BACKUP_OR_RESTORE]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969521</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969521</guid><author>aoyi6589</author><pubDate>Wed, 16 May 2018 15:00:00 +0800</pubDate><description><![CDATA[From:http://sqlity.net/en/1835/log-reuse-waits-explained-active_backup_or_restore/
Introduction
There are eight reasons SQL Server might report when it cannot truncate the transaction log. Any ...]]></description><category></category></item><item><title><![CDATA[Log Reuse Waits Explained: LOG_BACKUP]]></title><link>https://blog.youkuaiyun.com/aoyi6589/article/details/101969519</link><guid>https://blog.youkuaiyun.com/aoyi6589/article/details/101969519</guid><author>aoyi6589</author><pubDate>Wed, 16 May 2018 15:00:00 +0800</pubDate><description><![CDATA[From:http://sqlity.net/en/1830/log-reuse-waits-explained-log_backup/
Introduction
There are eight reasons SQL Server might report when it cannot truncate the transaction log. Any one of these r...]]></description><category></category></item></channel></rss>