A forum for sharing what I have learned about SQL Server over many years of thought, contemplation and practice
Translate This Page
Translate this page
Browse by Tags
Tagged Content List
Procedure Execution with Table-Valued Parameters Involved Cannot be Replicated
Somebody approached me with this error, asking whether this is by design or caused by certain conditions. Msg 25023, Level 16, State 1, Server <removed name>, Procedure sp_MSaddexecarticle, Line 192 Stored procedures containing table-value parameters cannot be published as '[serializable...
18 Apr 2013
Finding Large Transactions that Bloat Your Transaction Log
I know this is a fairly common problem and there might be multiple solutions out there, but I figured adding another one may not hurt. An application I was supporting recently, was leading to 100s of GB of transaction log growth in spurts and we needed to discover what was causing the growth. I built...
15 Apr 2013
Dealing with Unique Columns when Using Table Partitioning
Recently, I had the opportunity to present table and index partitioning and a follow up question came up regarding partitioning a table with unique constraint/index. The Special Guidelines for Partitioned Indexes article describes the right approach "Partitioning Unique Indexes When partitioning...
2 Apr 2013
Page 1 of 1 (3 items)
© 2014 Microsoft Corporation.
Privacy & Cookies