SQL Server Quickie #43 – Recovery Model Bulk Logged
Today I have uploaded SQL Server Quickie #43 to YouTube. This time I’m talking about the Recovery Model Bulk Logged in SQL Server. Thanks for your time, -Klaus
ColumnStore Segment Elimination
ColumnStore Indexes are great! They are a real performance booster for Data Warehousing and Reporting workloads. In combination with Clustered ColumnStore Indexes you get a huge compression benefit over regular RowStore Indexes (Clustered Indexes, Non-Clustered Indexes). And creating a Clustered ColumnStore Index is quite easy: CREATE CLUSTERED COLUMNSTORE INDEX ccsi ON TableName GO But is …
Data Page Restrictions
As you might know, a data page is always 8kb large, and you are able to store 8060 bytes of data on it. And the size of your records dictates how many records you can store on one page. When you deal with fixed-length data types (like CHAR, INT, DATETIME, etc.) you have the restriction …
SQLpassion Web Cast January 2017
Today I have uploaded my 1st Web Cast to YouTube. In this Web Cast I have talked today about SQL Server 2016 Service Pack 1. Make sure to signup for my next Web Cast on February 29 where I will talk about Troubleshooting CXPACKET Waits in SQL Server. Thanks for your time, -Klaus
How I designed my mobile Data Center
Getting serious notebook hardware these days is a quite challenging task. Almost all major hardware vendors only provide quad-core notebooks with up to 16 GB RAM (except Dell, but that is a different story because of their quality and their service…). If I still wrote letters to Santa Claus (hey, is that me?), I would …
