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.
Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script
The post Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script appeared first on SQLServerCentral.
Restore SQL Server database using data management provider REST API
The more SQL Server instances we need to manage, the easier it gets relying on third-party tools to complete our daily tasks. However, this brings another problem, that is, integrating with any application through the interfaces they provide. A ve …
Free Fundamentals of Query Tuning Week: Part 3, How Parameters Influence Cached Plans
While you practice physical distancing (words I never thought I’d daisy-chain together), I’m giving away free SQL Server training. So far, we’ve covered building a query plan and how to find the right queries to tune. Make sure to kee …
SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?
Sometimes I see weird issues with SQL Servers, and it helps me in understanding how the software works. In this blog, I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is u …
Never Create Columns with ANSI_PADDING set to OFF
The post Never Create Columns with ANSI_PADDING set to OFF appeared first on SQLServerCentral.