Sites anglophones


sp_spacedused2

Publié le 23 février 2018 sur sqlblog.com
 

— sp_spaceused2 USE master GO IF EXISTS ( SELECT * FROM sys . procedures WHERE object_id = OBJECT_ID ( ‘sp_spaceused2’ ) ) DROP procedure [dbo] . sp_spaceused2 GO CREATE PROCEDURE [dbo] . [sp_spaceused2] @objname nvarchar ( 776 ) = NULL, @minrow int = …

sp_spaceused2

Publié le 23 février 2018 sur sqlblog.com
 

this is my version of sp_spaceused. Instead of just overall spaceusage, all tables are shown with extended information. — sp_spaceused2 USE master GO IF EXISTS ( SELECT * FROM sys . procedures WHERE object_id = OBJECT_ID ( ‘sp_spaceused2’ ) ) DROP pro …

New Pluralsight course: Building Multi-instance Asynchronous Applications

Publié le 23 février 2018 sur sqlskills.com - paul randall
 

Jonathan’s latest Pluralsight course has been published – SQL Server: Building Multi-instance Asynchronous Applications. It’s 2.5 hours long, and from the course description: The Service Broker feature of SQL Server is trans …

New Pluralsight course: Understanding, Configuring, and Troubleshooting Database Mirroring

Publié le 23 février 2018 sur sqlskills.com - paul randall
 

Glenn’s latest Pluralsight course has been published – SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring. It’s 2.5 hours long, and from the course description: SQL Server database mirroring is a v …

SQL Server 2017 Cumulative Update 4

Publié le 23 février 2018 sur sqlskills.com - glen berry
 

On February 20, 2018, Microsoft released SQL Server 2017 Cumulative Update 4, which is Build 14.0.3022.28. I count 55 hotfixes in the public fix list. There is a special T-SQL script in the release notes that you need to run if you are using Query Stor …

Computed Columns and Cardinality Estimates

Publié le 23 février 2018 sur brentozar.com
 

:thinking_face: When most people think about computed columns, they don’t think about cardinality estimates. Heck, I’m not sure most people think about cardinality estimates. At all. Ever. One of the few people who has ever responded to my …

Avoid T-SQL Technical Debt using SQL Prompt Code Analysis

Publié le 23 février 2018 sur sqlservercentral.com
 

SQL Prompt’s new Code Analysis feature helps you discover code issues and hidden pitfalls during code development, as you type. In this article, Catherine shows how the Code Analysis feature works, and illustrates how to use the feature to improv …

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

Publié le 23 février 2018 sur sqlservercentral.com
 

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 brentozar.com
 

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 sqlservercentral.com
 

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 sqlservercentral.com
 

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 sqlskills.com - 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 …


Pages :