As a part of my SQL Server Performance Tuning and Optimization consultancy, I face interesting situations and every time I am able to resolve them. This was one of the more interesting ones where I was not getting any hint from the internet. Since it was a new thing to me, I am sharing it via this blog. In this blog, we would learn about the cause of WorkFileGroup_fake_worktable and Workfile.
Which is Faster – INSERT INTO SELECT or SELECT INTO? – Interview Question of the Week #187
Question: Which is Faster – INSERT INTO SELECT or SELECT INTO?
SQL SERVER – DBA Disruptors eCourse
Performance tuning is indeed very simple in the real world but many experts often project it as a very complex task. I often think it is because that expert would love to project that they are master of some complex art, which is not easily mastered. However, I personally believe everyone who wants to learn performance tuning, can learn it quickly and easily. I am very happy to discuss my latest DBA Disruptors eCourse.
What is Lock Pages In Memory? – Interview Question of the Week #186
Question: What is Lock Pages In Memory?
Fun Video – Real World Performance Solutions by Bert
Today, I am very happy to share a fun video about class Real World Performance Solutions. I was very fortunate that I got the opportunity to build this video with Bert Wagner. He is truly a talented SQL Server expert and amazingly creative with the videos. I have never seen in my life anyone so versatile with creative with educational videos.
Free Video – SQL Server Performance Tuning Made Easy
SQL Server Performance Tuning is not as difficult as most of the people think. Actually, SQL Server performance tuning is very easy and simple, if you exactly know what to do and when to do. Well, that is what is the theme of the free webinar which I have done for 24 Hours of PASS.
Practical Real World Performance Tuning – Before the Class Announced
I recently completed delivering Practical Real World Performance Tuning for Brent Ozar Unlimited and it was great 3 days of delivery. Here are my thoughts about my entire experience and how everything worked out. Let us go on the journey to Behind the Scenes for Teaching Online Class.