How to create a system object (Table, Stored Procedure, View…)
It is really easy. You just need to add the object name as a parameter to “SYS.SP_MS_MARKSYSTEMOBJECT”. In the following…
How to query extended properties
If you are working in a company that your managers are getting database documentation seriously, thumbs up! One of the…
How to create schema dynamically using dynamic SQL
In this short post I’ll show you how to create database schema using dynamic SQL. It’s easy, just take a…
Digging into SQL Server 2012 columnstore index
The SQL Server 11.0 release (code named “Denali”) introduces a new data warehouse query acceleration feature based on a new…