A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we go into the details of this approach and if it could work, I want to give you an overview about the requirements, and why the customer wanted to have Nested Partitioned Views. The main idea …
Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I’m talking about Allocation Units in SQL Server. Thanks for reading & watching -Klaus
The summer goes by and in a few weeks the conference season starts over again. The last weeks were a little bit stressful, but now I had finally some time to prepare my sessions for upcoming SQL Server conferences, where I’m speaking over the next months. 24 Hours of PASS, September 12 At this online …
During the last days I’m working on Replication – especially with Transactional Replication. The main idea of Transactional Replication is that you have a so-called Log Reader Agent on your Publisher SQL Server database running, that is analyzing the Transaction Log File and synchronize changes on so-called Articles through a Distribution database down to your …
Initialize a Transactional Replication from a Database Backup + read more
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I’m talking about Extents, and how SQL Server manages those through GAM and SGAM pages. Thanks for reading & watching! -Klaus
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
