SQL Server Quickie #40 – ColumnStore Indexes
Today I have uploaded SQL Server Quickie #40 to YouTube. This time I’m talking about ColumnStore Indexes in SQL Server. Thanks for your time, -Klaus
How to move data between File Groups in SQL Server
I don’t know how often I have been asked this question in my life: “How can I move data between File Groups in SQL Server?”. You know the problem: you have a default configuration of a database with only a PRIMARY file group, and at some point in time you learn that a custom file …
How to move data between File Groups in SQL Server + read more
How much RAM do I need for SQL Server?
A classic question that I get asked very often during my various SQL Server consulting engagements is how much RAM do I need for SQL Server? This question has again a typical “It depends” answer. In today’s blog post let’s have a more detailed look into the various aspects on which “it depends”. New SQL …
SQLBits 2016 Liverpool – my Attendee Feedback
A few days ago I received my attendee feedback from the SQLBits 2016 conference, which was held this time in lovely Liverpool. I had done a whole day precon about Locking, Blocking, and Deadlocking and a 1 hour long session about Joins in SQL Server. As easy as ABC? So let’s take a few minutes …
SQL Server Quickie #39 – Semi Joins
Today I have uploaded SQL Server Quickie #39 to YouTube. This time I’m talking about Semi Joins in SQL Server. Thanks for your time, -Klaus
