Question: Which is Faster – INSERT INTO SELECT or SELECT INTO?
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.
Question: What is Lock Pages In Memory?
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.
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.
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.
Question: How to Find Cardinality or Uniqueness for any Column?