CHANGE DATA CAPTURE SQL Errors A value for the parameter @retention cannot be specified when the job type is ‘capture’. Specify NULL for the parameter, or omit the parameter from the statement. By deviprasad
SQLServerPedia Syndication T-SQL Code Examples HOW TO CONVERT TABLE DATA TO XML AND XML TO TABLE By deviprasad
Collations SQL Server Basics When To Use LOWER/UPPER for comparing data in SQL Server – Alternatives By deviprasad
Dead Lock Dead Lock Resolution SQLServerPedia Syndication Deadlock Internals with Real Time Scenario – Explanation and Resolution By deviprasad
SQL Server Issues SSMS ISSUE: Connection information does not change in SSMS when a new Query is created from Dedicated Administrator Connection By deviprasad
SQL Security SQL Server Tricks SQLServerPedia Syndication How To View Data in Hidden System Tables. By deviprasad
Interview Questions SQL Server Collations T-SQL Code Examples Temporary Tables Impact of TEMPDB Collations on Other Databases By deviprasad