Power BI Dashboard vs Report vs Workbook
The post Power BI Dashboard vs Report vs Workbook appeared first on SQLServerCentral.
Avoid using constants in an ORDER BY clause
The post Avoid using constants in an ORDER BY clause appeared first on SQLServerCentral.
How was a plan forced?
If you use Automatic Plan Correction, and thus also Query Store, you may wonder how was a plan forced: manually or automatically with APC? The type of forced plan is tracked in sys.query_store_plan, and you can use this simple query to determine …
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’
Recently one of my clients contacted me to provide them assistance in finding and fixing the cause of a huge transaction log file. There are many caused to get error 9002 in SQL Server ERRORLOG. In this blog, I would explain the cause and fix of error: …
Collections: Crossing intervals computed gaps
Problem Combining overlapping intervals in order to compute the missing intervals could be a complex task for advanced programmers. This article presents a new solution based on usage of geometry data type and on a unknown function (if not, maybe less …
What is the Difference Between sql_handle and plan_handle?- Interview Question of the Week #269
Question: What is the Difference Between sql_handle and plan_handle?Answer: I was recently asked this question during the Comprehensive Database Performance Health Check. Before we see the answer to this question, let us see where actually you can find …
SQL SERVER – Free Performance Tuning Videos
Yesterday I wrote a blog post about COVID-19, Working From Home and Performance Tuning and I have received a lot of email responses to this blog post. Also on twitter, lots of people also reached out to me for further conversation. It is indeed interes …
DevOps is Essential for Analytics
The term DevOps was coined in the early 2000s to improve the speed and resiliency of the delivery of features and applications and providing more value to customers. It’s not about any particular technology, methodology, or toolset, but automatio …
Free Fundamentals of Query Tuning Week: Part 5, Common T-SQL Anti-Patterns
While you play Chopped with the ingredients in your cupboard (“Today’s ingredients are rice, beans, and hand sanitizer”), I’m giving away free training. So far, we’ve covered building a query plan, how to find the right qu …
COVID-19, Working From Home and Performance Tuning
I am sure you have enough information about Covid-19 (Coronavirus disease) already by this time after reading various newspapers, watching TV, and engaging in the social media, so I will not bother you more talking about it. However, I would like to qu …
Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins
The post Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins appeared first on SQLServerCentral.
What’s New in SQL Monitor 10?
The post What’s New in SQL Monitor 10? appeared first on SQLServerCentral.
Free Fundamentals of Query Tuning Week: Part 4, Improving Cardinality Estimation Accuracy
Before we get to the training in today’s episode, I wanna stop for a second to say thank you. We’re donating 10% of all sales this month to Doctors Without Borders. This morning, I sent in the first donation: so far, you’ve raised $4, …
SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size
One of my clients contacted me for assistance with whom I worked earlier to perform a Comprehensive Database Performance Health Check. They were running a job in SQL Agent and it was failing with error – Could not allocate space for object …
Verifying Object Exists and Dropping Object with One Statement
The post Verifying Object Exists and Dropping Object with One Statement appeared first on SQLServerCentral.