How to Find Queries Using an Index From SQL Server Plan Cache? – Interview Question of the Week #195
Question: How to Find Queries Using an Index From SQL Server Plan Cache? Answer: During the recent Comprehensive Database Performance Health Check, I had an interesting situation, where I suggested that we will drop an index for a query. I ha …
[Video] Office Hours 2018/10/10 (With Transcriptions)
This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, security auditing solutions, what Brent is currently teaching at the client location, SQL Server in containers, heap index maintenance, contained databases …
SQL SERVER – How to Change Authentication Mode Using T-SQL Query
One of my clients asked an interesting question. It took a while for me to figure out the answer so sharing with my blog readers. In this blog, we would learn how to change authentication mode of SQL Server using T-SQL query instead of SQL Server Manag …
Index Tuning Week: Missed Missing Index Opportunities
A Reminder With a new baby in the house, I often find myself comparing her to various things. Barnacles. Ham. Pugs. No, I swear, I love her. SQL Server Has A Baby, Too That baby is the optimizer, and when it starts crying, it uses missing index request …
Redgate University has opened its doors online
Redgate has established the Redgate University, an online resource where you’ll find self-paced training courses with easy to follow classes to help you and your team learn the fundamentals and best practices, and get top tips from the experts.
Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
SQL SERVER – Always On AG – HADRAG: Did not Find the Instance to Connect in SqlInstToNodeMap Key
During my On Demand (50 Minutes) consultancy, I solve the issue which seems quick to my client. SQL not starting, AlwaysOn not failing over, Cluster not working are few of quick things where my clients engage me. In this blog, I would share a situation …
Index Tuning Week: Getting Blocking? Play “Hot or Not.”
This week, we’re all about tuning indexes. So far, we’ve covered Brent’s 5 and 5 Rule and The D.E.A.T.H. Method. Today, let’s talk about reducing blocking and deadlocking. Normally, when we think about the causes of blockin …
Collecting Data with Elastic Database Jobs in SQL Azure
In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davi …
HTTP Requests Using SQLCLR
Query web APIs directly in SQL Server with its CLR integration
Fifty Different Ways to Enact Data Privacy Laws?
Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer exp …
SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE
One of my clients contacted me to resolve an issue where they were seeing these errors few minutes after restarting SQL Server Service. In this blog, we would learn about how to fix error Timeout occurred while waiting for latch: class FGCB_ADD_REMOVE. …
Index Tuning Week: Fixing Nonaligned Indexes On Partitioned Tables
Unquam Oblite This post will not change your life, but it will help me remember something. When you decide to partition a table to take advantage of data management features, because IT IS NOT A PERFORMANCE FEATURE, or you have an existing partitioned …
Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework
This level of the Stairway to Biml examines how to refactor your Biml into an easier to maintain format.
Get SQL Server Row Count and Space Used with the sp_rows
Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.