Codingsight is a community platform created and maintained by Devart. The main purpose of Codingsight is to share knowledge with the wide professional audience. Readers at all levels, from novice to advanced, will learn practical information straight from.

Advanced tips and codes for Microsoft SQL server, SQL language and database technologies. Online utilities and much more.

SQL Servers highly anticipated upcoming release will bring with it a new XML datatype that can directly store XML documents to, and extract from, the relational database. In addition to the query functions of Microsoft SQL Server, Yukon supports a number of native XQuery functions designed specifically for the XML data type.

This blog is about a frequent problem that one can face while using SQL servers. Often SQL servers go in recovery mode even after a reboot. In this blog, you will get to know about what causes this and best fic to the problem.