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
SQLServer
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 …
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 …
Join the SQLBits Disco, and learn about Performance Troubleshooting
I’m delighted to announce that I have been chosen to present my precon about Practical SQL Server Performance Troubleshooting at SQLBits on April 6 in Telford/United Kingdom. As you might know I really enjoy talking about Performance Troubleshooting, because it’s one of my specialities. And I’m also already a veteran (with almost no hair left) …
Join the SQLBits Disco, and learn about Performance Troubleshooting + read more
