sql | SQL Server‎ > ‎

sqlsrv | SQL Server Reference

Showing 40 items
idxcatdescurl
Sort 
 
Sort 
 
Sort 
 
Sort 
 
idxcatdescurl
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
Comments