Sites anglophones


How to Find Queries Using an Index From SQL Server Plan Cache? – Interview Question of the Week #195

Publié le 14 octobre 2018 sur journey to sqlauthority
 

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)

Publié le 13 octobre 2018 sur brentozar.com
 

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

Publié le 13 octobre 2018 sur journey to sqlauthority
 

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

Publié le 12 octobre 2018 sur brentozar.com
 

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

Publié le 12 octobre 2018 sur sqlservercentral.com
 

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

Publié le 12 octobre 2018 sur sqlservercentral.com
 

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

Publié le 12 octobre 2018 sur journey to sqlauthority
 

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.”

Publié le 11 octobre 2018 sur brentozar.com
 

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

Publié le 11 octobre 2018 sur sqlservercentral.com
 

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

Publié le 11 octobre 2018 sur sqlservercentral.com
 

Query web APIs directly in SQL Server with its CLR integration

Fifty Different Ways to Enact Data Privacy Laws?

Publié le 11 octobre 2018 sur sqlservercentral.com
 

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

Publié le 11 octobre 2018 sur journey to sqlauthority
 

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

Publié le 10 octobre 2018 sur brentozar.com
 

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

Publié le 10 octobre 2018 sur sqlservercentral.com
 

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

Publié le 10 octobre 2018 sur sqlservercentral.com
 

Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.


Pages :