Archive for October, 2012
Snapshot and Synonyms
Posted by Simon Cho on 10/26/2012
Posted in Common | Tagged: Snapshot, Synonym | Leave a Comment »
Dedicated Administrator Connection
Posted by Simon Cho on 10/26/2012
http://msdn.microsoft.com/en-us/library/ms178068%28v=sql.105%29.aspx
To use in SSMS please follow up those steps.
1. Enable SQL Server Browser.
Many of case for Network-Related error message is due to this reason.
2. Please use “Database Engine Query“, File>New> Database Engine query
This is keyword.
Do not open using object explorer since DAC does NOT support multiple sessions.
3. Add “ADMIN:” in front of server name
ADMIN:localhost
Posted in Common | Tagged: ADMIN:, DAC, Dedicated Administrator Connection | Leave a Comment »
DeadLock handling
Posted by Simon Cho on 10/09/2012
http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/
http://blogs.msdn.com/b/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx
http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/ea1a28eb-1ff3-41ca-af22-7110347627bf
Posted in Common | Tagged: DeadLock, Deadlock exchange event | Leave a Comment »
Simon's SQL 