Sites anglophones


How to Use Multiple Hints Together for a Query? – Interview Question of the Week #241

Publié le 8 septembre 2019 sur journey to sqlauthority
 

Question: How to Use Multiple Hints Together for a Query?Answer: This is a very interesting question I have received recently from my client of Comprehensive Database Performance Health Check. Of course, you can use multiple hints for a query. Here is …

SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally

Publié le 7 septembre 2019 sur journey to sqlauthority
 

My favorite part of Comprehensive Database Performance Health Check is to resolve slow issues which are often very complicated to resolve. Recently I was hired for a specific task where my client had a very important query running usually in just subse …

DBA Training Plan 19: The L-Word, Licensing

Publié le 6 septembre 2019 sur brentozar.com
 

You’ve gotten through a lot of this training. You’ve tried fixing the problem with indexes, query tuning, and judicious application of various configuration switches. You’ve been watching webcasts and using free scripts, but… T …

SQL SERVER – Sample Long-Running Query for Demonstrations

Publié le 6 septembre 2019 sur journey to sqlauthority
 

I often travel across the world presenting on SQL Server Performance Tuning Topics. When I am not busy with Comprehensive Database Performance Health Check, I like to train IT professionals with SQL Server Performance Tuning Practical Workshop. I perso …

Managing Data Masking Rules in Larger Teams using Source Control

Publié le 6 septembre 2019 sur sqlservercentral.com
 

The post Managing Data Masking Rules in Larger Teams using Source Control appeared first on SQLServerCentral.

How to Stop a SSIS Package Execution from Code

Publié le 6 septembre 2019 sur sqlservercentral.com
 

The post How to Stop a SSIS Package Execution from Code appeared first on SQLServerCentral.

Pluralsight Free Weekend: September 6-8, 2019

Publié le 5 septembre 2019 sur sqlskills.com - glen berry
 

Pluralsight’s entire course library is FREE for everyone this weekend, from Friday, September 6 at 10:00AM MT to Sunday, September 8th at 11:59PM MT! SQLskills has 62 courses available on Pluralsight. If you don’t have a Pluralsight subscri …

SQL SERVER – Generate In-Memory OLTP Migration Checklists – SSMS

Publié le 5 septembre 2019 sur journey to sqlauthority
 

Recently one of the customers of Comprehensive Database Performance Health Check asked me if I can help them analysis their entire database for In-Memory OLTP Migration. Well, honestly you do not need my help to check the readiness of your database for …

SQL Server 2016 – Always Encrypted

Publié le 5 septembre 2019 sur sqlservercentral.com
 

Always Encrypted is a new security feature which was introduced in SQL Server 2016. Always Encrypted is a technology to ensure the data stored in a database remains encrypted at all times during SQL Server query processing. Always Encrypted allows …

Why you Should Avoid Using the @@IDENTITY Function

Publié le 5 septembre 2019 sur sqlservercentral.com
 

sql The post Why you Should Avoid Using the @@IDENTITY Function appeared first on SQLServerCentral.

Create, Alter, Drop and Execute SQL Server Stored Procedures

Publié le 5 septembre 2019 sur sqlservercentral.com
 

The post Create, Alter, Drop and Execute SQL Server Stored Procedures appeared first on SQLServerCentral.

The Curious Case of… too few log records for an offline index rebuild

Publié le 4 septembre 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

SQL Server Diagnostic Information Queries for September 2019

Publié le 4 septembre 2019 sur sqlskills.com - glen berry
 

This month, I have just done some minor formatting and documentation improvements. I am thinking about just having one version for SQL Server 2016 rather than two. SQL Server 2016 SP2 back-ported a number of useful DMVs from SQL Server 2017, which is w …

DBA Training Plan 18: Managing Concurrency

Publié le 4 septembre 2019 sur brentozar.com
 

Locking isn’t a problem – queries are gonna lock data. As long as nobody else wants the lock, you can take your sweet time locking it, and it won’t show up as a problem. (That’s one of the many reasons queries work so well in de …

SQL SERVER – T-SQL Script to Identify TOP 10 Parallel Running Queries

Publié le 4 septembre 2019 sur journey to sqlauthority
 

Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check yesterday’s engagement. You may read my Read What My Clients Say about my performance services her …


Pages :