SQL Server Quickie #34 – Statistics
Today I have uploaded SQL Server Quickie #34 to YouTube. This time I’m talking about Statistics in SQL Server. Thanks for your time, -Klaus
Linus Torvalds joins Microsoft!
Now the cat is out of the bag: Linus Torvalds – the father of the Linux Kernel – will join Microsoft! Wooohooo! As we have seen over the last weeks, Microsoft is currently going through a huge transformation, and is now more open to other technologies, like Linux. A few weeks ago, Microsoft announced SQL …
Clustered Indexes – Advantages & Disadvantages
Every time you create a Primary Key constraint in SQL Server, the constraint is (by default) enforced through a Unique Clustered Index. This means that you need to have in that column (or these columns, if you have defined a composite Primary Key) unique values. And as a side effect your table data is physically …
Clustered ColumnStore Indexes – Space Savings
Over the last weeks I have done a lot of work with Clustered ColumnStore Indexes in SQL Server 2014/2016, and it is really amazing what you can achieve with this technology. In today’s blog post I want to talk a little bit more about the space savings that you can make by using a Clustered …
Database Scoped Configuration in SQL Server 2016
SQL Server 2016 will be really impressive. Since a few days ago Microsoft has made the RC0 version available for download. I have already done a quick tour through the RC0 version, and one of the nicest new features is the Database Scoped Configuration which I want to cover in today’s blog post. Database Scoped …
Database Scoped Configuration in SQL Server 2016 + read more
