This is a first blog post in a very large series of posts about the CLustered Columnstore Indexes: Columnstore Indexes – part 2 (“Internals”) Columnstore Indexes – part 3 (“More Internals”) Columnstore Indexes – part 4 (“Basic T-SQL”) Columnstore Indexes…
Char(1-2) vs Varchar(1-2) to be NULL or to be NOT NULL
Continuing the small research that I have been doing on the matter of the Varchar(1) & Varchar(2) datatypes usage, I am taking this article to consider the situations when the columns are defined as NOT NULL. Following the same scheme…
Varchar(x) where x <= 2 does not make sense... or does it?
While preparing my “Inheriting a database for Developers” session for SQLSaturday#162 in Cambridge, I have had a very interesting finding on the matter of the Varchar datatype usage. There is a more or less common knowledge of the SQL Server…
Presenting at SQLRally 2012 Nordic
Yes, it is true! I have been selected to present at one of the biggest European SQL Server events – at the PASS SQLRally 2012 Nordic Edition! No words can describe the excitement and the honor that I am feeling…
Going to and presenting at SQLSaturday #170 Munich
The first SQLSaturday in Germany is just a couple of weeks away and I am so excited about it. Knowing one of the organizers – Constantin Klein, I am confident that this event will be a great success and generally…