sql | SQL Server >
sqlsrv | SQL Server Reference
| idx | cat | desc | url |
|---|---|---|---|
| sqlsrvref0013 | Cluster | Create a New SQL Server Failover Cluster (Setup) | 兩種SQL Cluser安裝方式 |
| WSFCref0012 | Cluster | Before Installing Failover Clustering | |
| WSFCref0021 | Cluster | Clustering: What exactly is a File Share Witness and when should I use one? | http://blogs.technet.com/b/askpfeplat/archive/2012/06/27/clustering-what-exactly-is-a-file-share-witness-and-when-should-i-use-one.aspx |
| WSFCref0022 | Cluster | New Features of Windows Server 2012 Failover Clustering | http://www.windowsitpro.com/article/what-would-microsoft-support-do/features-windows-server-2012-failover-clustering-143764 |
| sqlsrvref0006 | DBA | SQL Server DBA三十问 | http://my.oschina.net/u/187928/blog/37311 |
| sqlsrvref0024 | DBA | hidden-features-of-sql-server | http://stackoverflow.com/questions/121243/hidden-features-of-sql-server |
| sqlsrvref0031 | DBA | Reading SQL Server's Transaction Log | |
| sqlsrvref0034 | DBA | Partitioning truth / myth | http://www.mssqltips.com/sqlservertip/1914/sql-server-database-partitioning-myths-and-truths/ |
| sqlsrvref0035 | DBA | Overcoming storage speed limitations with Memory-Optimized Tables for SQL Server | MEMORY_OPTIMIZED_DATA |
| sqlsrvref.note0028 | DBA | Execution Plan | http://www.simple-talk.com/sql/performance/execution-plan-basics/ |
| sqlsrvref.note0029 | DBA | Optimization | http://etutorials.org/SQL/Sql+tuning/Chapter+4.+Controlling+Execution+Plans/4.4+Controlling+Plans+on+SQL+Server/ |
| sqlsrvref0027 | DBD | SQL split | |
| sqlsrv.note0023 | HA & SYNC | The insert failed. It conflicted with an identity range check constraint in database 'muchnewdb', replicated table 'dbo.before_mdreceiver_log', column 'bem_sn'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent. | 可更新訂閱，identity issue。 DBCC CHECKIDENT('[dbo].[table_name]', RESEED, 1000000) |
| sqlsrvref0003 | HA & SYNC | Log Shipping vs. Replication | http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/ |
| sqlsrvref0004 | HA & SYNC | SQL Server Replication(复制) 的类别及区别 | http://liweibird.blog.51cto.com/631764/939637 |
| sqlsrvref0005 | HA & SYNC | Conflict Detection in Peer-to-Peer Replication | http://technet.microsoft.com/en-us/library/bb934199.aspx |
| sqlsrvref0007 | HA & SYNC | Log Shipping and Replication (SQL Server) | http://msdn.microsoft.com/zh-tw/library/ms151224(v=sql.110).aspx |
| sqlsrvref0008 | HA & SYNC | 在複寫拓撲中使用多個 SQL Server 版本 | http://msdn.microsoft.com/zh-tw/library/ms143241(v=sql.105).aspx |
| sqlsrvref0009 | HA & SYNC | In defense of transactional replication as an HA technology | http://www.sqlskills.com/blogs/paul/post/In-defense-of-transactional-replication-as-an-HA-technology.aspx |
| sqlsrvref0010 | HA & SYNC | 較詳細的tran repl說明(略提及log shipping) | Transactional Database Replication |
| sqlsrvref0011 | HA & SYNC | 資料庫鏡像作業模式 | |
| sqlsrvref0014 | HA & SYNC | SQL Server 2012 複寫中已被取代的功能 | |
| sqlsrvref0015 | HA & SYNC | SQL Server 2012 複寫中的重大變更 | |
| sqlsrvref0016 | HA & SYNC | Massive P2P replication | |
| sqlsrvref0017 | HA & SYNC | https://sites.google.com/a/aisowhat.com/data2info/sql/document-ref/Using%20Service%20Broker%20instead%20of%20Replication.7z?attredirects=0&d=1 | Using Service Broker instead of Replication |
| sqlsrvref0018 | HA & SYNC | Strategies for Backing Up and Restoring Snapshot and Transactional Replication | 啟用複寫時之備份還原 |
| sqlsrvref0019 | HA & SYNC | Why do you need Sync with Backup in Transactional Replication? | http://sqlserverpedia.com/blog/sql-server-bloggers/why-do-you-need-sync-with-backup-in-transactional-replication/ |
| sqlsrvref0020 | HA & SYNC | Introduction to Database Mirroring in SQL Server | http://www.extremeexperts.com/sql/articles/DBMirroring1.aspx |
| sqlsrvref0026 | HA & SYNC | 可讓您設定 Windows Server 2008 及 2008 R2 中不具備仲裁投票叢集節點的修補程序 | A hotfix is available to let you configure a cluster node that does not have quorum votes in Windows Server 2008 and in Windows Server 2008 R2 |
| sqlsrvref0030 | HA & SYNC | Details behind an AlwaysOn Availability Group | |
| security | http://haacked.com/archive/2007/11/04/a-library-for-executing-sql-scripts-with-go-separators-and.aspx | ||
| security | http://www.mssqltips.com/sqlservertip/2882/move-all-sql-server-indexed-views-to-a-new-filegroup/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=201325 | ||
| sqlsrvref0001 | security | Checking permissions for different logins in SQL Server 2005 | http://decipherinfosys.wordpress.com/2008/12/29/checking-permissions-for-different-logins-in-sql-server-2005/ |
| sqlsrvref0032 | security | Working Your SOX Off | |
| sqlsrvref0033 | security | SQL Server Logins and Users | |
| sqlsrvref0025 | tuning | Identifying the input buffer in SQL Server 2000 vs SQL Server 2005 | http://www.mssqltips.com/sqlservertip/1363/identifying-the-input-buffer-in-sql-server-2000-vs-sql-server-2005/ |
| sqlsrvref0034 | tuning | SQL Server 2012新performance counter：非常实用的Batch Resp Statistics | Batch Resp Statistics |
| sqlsrv.ref0035 | tuning | Performance Counters | http://blog.extreme-advice.com/2012/10/09/performance-counter-in-sql-server/ |
| sqlsrvref.0036 | tuning | all counters in MSDN | |
| sqlsrvref0002 | version compare | sys object compare 2000 - 2008 | http://www.mssqltips.com/sqlservertip/1037/system-information-in-sql-server-2000-vs-sql-server-2005/ |
Showing 40 items