05 2018 档案

SQL Profile trace run access grant
摘要：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 阅读全文
posted @ 2018-05-23 11:50 rosewong 阅读(168) 评论(0) 推荐(0)
Log Reuse Waits Explained: DATABASE_MIRRORING
摘要：From:http://sqlity.net/en/1843/log-reuse-waits-explained-database_mirroring/ Introduction There are eight reasons SQL Server might report when it cann 阅读全文
posted @ 2018-05-16 15:04 rosewong 阅读(189) 评论(0) 推荐(0)
Log Reuse Waits Explained: ACTIVE_TRANSACTION
摘要：From: http://sqlity.net/en/1839/log-reuse-waits-explained-active_transaction/ Introduction There are eight reasons SQL Server might report when it can 阅读全文
posted @ 2018-05-16 15:02 rosewong 阅读(215) 评论(0) 推荐(0)
Log Reuse Waits Explained: ACTIVE_BACKUP_OR_RESTORE
摘要：From:http://sqlity.net/en/1835/log-reuse-waits-explained-active_backup_or_restore/ Introduction There are eight reasons SQL Server might report when i 阅读全文
posted @ 2018-05-16 15:00 rosewong 阅读(336) 评论(0) 推荐(0)
Log Reuse Waits Explained: LOG_BACKUP
摘要：From:http://sqlity.net/en/1830/log-reuse-waits-explained-log_backup/ Introduction There are eight reasons SQL Server might report when it cannot trunc 阅读全文
posted @ 2018-05-16 15:00 rosewong 阅读(409) 评论(0) 推荐(0)
Log Reuse Waits Explained: CHECKPOINT
摘要：From:http://sqlity.net/en/1819/log-reuse-waits-explained-checkpoint/ Introduction There are eight reasons SQL Server might report when it cannot trunc 阅读全文
posted @ 2018-05-16 14:59 rosewong 阅读(198) 评论(0) 推荐(0)
Transaction Log Reuse Wait
摘要：From link as below: http://sqlity.net/en/556/t-sql-tuesday-25-%E2%80%93-sql-server-tips-tricks/ One question that keeps coming up in forums, at user g 阅读全文
posted @ 2018-05-16 14:58 rosewong 阅读(304) 评论(0) 推荐(0)
enable non-sysadmin accounts to execute the "xp_cmdshell
摘要：Document from :https://support.microsoft.com/en-us/help/890775/how-to-enable-non-sysadmin-accounts-to-execute-the-xp-cmdshell-extende Summary This art 阅读全文
posted @ 2018-05-15 10:36 rosewong 阅读(416) 评论(0) 推荐(0)