We have many ways to obtain the size of all tables using SQL Server. This is a nice solution but we do not really need to use temporary table. http://therightstuff.de/2007/11/19/How-To-Obtain-The-Size-Of-All-Tables-In-A-SQL-Server-Database.aspx If we run the script twice, we have an error. Well, this version uses a...

We have a lot of articles about how to do but most of the time it is too much information. This article tries to answer 2 questions! How can we create XML column from a SQL query? How can we create a table from XML column? This example use NorthWind database: https://northwinddatabase.codeplex.com/releases/view/71634 1...