In Part 1 I covered how much data your SQL Server should be processing and the effects if it isn’t. Here we check to make sure that you’re achieving that speed. Let us continue learning about data starvation in this blog post.
Learn PowerBI and Advanced Analytics – Instructor-Led and Self Paced Training
If you are reading this blog, you must be aware that I focus on relational database and also in particular for SQL Server Performance Tuning. I always believed that any system in the world can use more performance. Well, while I focused on relational database, I accept that I have focused very little on the subject of PowerBI and Advanced Analytics.
SQL SERVER – Compatibility Level 80 and Table Hint Behavior
It has been a while since I worked with SQL Server 2000. However, as an independent consultant, SQL Server never stops to surprise us. Recently, during one Comprehensive Database Performance Health Check, I found a very interesting situation which is about compatibility level 80. If you are not familiar with compatibility level, it sets database behaviors to be compatible with the specified version of SQL Server.
SQL SERVER – Error Due to Database Context – Error 208 – Invalid Object Name
Today, we are going to talk about one of the most popular errors which user see every day. There are many users who often get stuck at this error and have no clue how to move forward with this error in SSMS. It is quite possible you may say this is a very simple error and you knew about it, well good for you. Remember this blog post is for everyone who have faced error 208 – Invalid Object Name and have no idea how to move forward from this point.
What are Forwarded Records in SQL Server? – Interview Question of the Week #145
Question: What are Forwarded Records in SQL Server?
Answer: It is interesting to see this question keeps on coming up in the interview questions. Even though this is very old concept, I hardly see new DBAs know about this subject.
Let us see the answer the question about the forwarded records.
SQL SERVER – How to Create A Global Temporary Table?
Two days ago, I wrote an article SQL SERVER – How to Create Table Variable and Temporary Table? It was a very basic article for beginners. However, to my surprise, I have got tremendous response to that blog post and also got quite a lot of feedback about the it. Out of all these one feedback which stood out was that I did not include discussion about Global Temporary Table. I agree that when I was writing this blog post I did not think of this, but it is never too late to write about any topic. Let us see in this blog post how to create a global temporary table?
SQL SERVER – When to Turn On Optimize for Ad Hoc Workloads?
Today, I have very interesting scenario to share with all of you. This is a true story which I encountered in my recent Comprehensive Database Performance Health Check. It is about a very popular SQL Server setting Optimize for Ad Hoc Workloads.