Sites anglophones

« But It Worked in Development! » – 3 Hard SQL Server Performance Problems

Publié le 23 février 2018 sur

You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heav …

SQL SERVER – Unable to Start SQL Server Agent. Error – Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed

Publié le 23 février 2018 sur journey to sqlauthority

If someone tells me any situation, the first question which I always ask is “What is the error message?”. Now to get the right error message, it is important to look at the right log file. In this blog, we would learn about SQL Server Agent …

Using WITH (NOEXPAND) to Get Parallelism with Scalar UDFs in Indexed Views

Publié le 22 février 2018 sur

Scalar functions are the butt of everybody’s jokes: their costs are wrong, their STATS IO results are wrong, they stop parallelism when they’re in check constraints, their stats are wrong in 2017 CU3, they stop parallelism in index rebuilds …

Database Master Keys and Availability Groups

Publié le 22 février 2018 sur sqlskills - jonathan kehayas

Recently I received an email from a client experimenting with Availability Groups for the first time in a development environment that had run into an issue with adding one database out of fifteen to the Availability Group in the UI.  The database …

Performance Comparison Between SQL Server 2014 and 2016

Publié le 22 février 2018 sur

This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.

Introducing a DevOps culture

Publié le 22 février 2018 sur

Your organization’s culture of DevOps will often be the defining factor on whether you have a successful organizational change, or whether the changes that you implement impact pockets of your organization.

SQL SERVER – Unable to Start Jobs – Error: Enumerate Target Servers Failed for Job

Publié le 22 février 2018 sur journey to sqlauthority

One of my clients contacted me for quick On-Demand consulting. When I joined GoToMeeting with them they showed me below error when they were trying to run a job. Let us see how we can fix the error Enumerate Target Servers Failed for Job. Cannot p …

SQL Server Diagnostic Information Queries for February 2018

Publié le 21 février 2018 sur - glen berry

This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I have developed a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate …

Let’s Give The Optimizer A Name

Publié le 21 février 2018 sur

Clunky As my favorite monkey likes to say, the hardest things do with computers are: 1. Naming things 4. Asynchronous processing 2. Cache invalidation 5. Off by one errors Things are tough for Microsoft, too. Take “the optimizer” for instan …

Stairway to Database Design Level 9: Normalization

Publié le 21 février 2018 sur

In the final step of Database Design, Joe Celko gives a simple but effective explanation of the normalization process and why it is important.

SQL Server Reporting Services 2017 Tutorial

Publié le 21 février 2018 sur

SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice. How to fix SQL Server disk I/O bottlene …

SQL SERVER – Puzzle – Get the First Name From Full Name Without CHARINDEX

Publié le 21 février 2018 sur journey to sqlauthority

Recently I have been engaged with a customer where they were having a performance issue. They have engaged me via my offering Comprehensive Database Performance Health Check. While doing that, they asked me to write a better way to write a query. …

Asymmetric Processor Cores

Publié le 20 février 2018 sur

Most Intel processors use one of two cores, the main-line core and the Atom core. Desktop processors might use the newer Kaby Lake or Coffee Lake micro-architecture cores, while the Xeon SP lines uses the previous generation Skylake micro-architecture. …

How to Throttle Logins to SQL Server

Publié le 20 février 2018 sur

So, uh, you can use WAITFOR in a logon trigger:CREATE OR ALTER TRIGGER SorryNorm ON ALL SERVER FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= ‘NormTheNewGuy’ WAITFOR DELAY ’00:00:15′; END; GO You probably don’t want it to be TOO long, lest their app rep …

Validating naming conventions in Oracle

Publié le 20 février 2018 sur

This article was originally published on Nick’s site, APEXPLAINED. We are republishing it here with his permission. Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension …

Pages :