Sites anglophones


SQL SERVER – 10 Questions Where YES May Be a Wrong Answer – Performance Health Check

Publié le 22 mars 2017 sur journey to sqlauthority
 

Today’s blog post created from a recent conversation with one of my customers. They asked me a very interesting question – “When should they hire me for my famous Comprehensive Database Performance Health Check?“. I send them fo …

SQL Server 2016 Service Pack 1 CU2 Released

Publié le 21 mars 2017 sur sqlskills.com - glen berry
 

On March 20, 2017, Microsoft released SQL Server 2016 Service Pack 1 CU2, which is Build 13.0.4422.0. This CU has 101 fixes in the public fix list, by my count. This is a pretty large CU, and if you look at the fix list in more detail, many of them are …

First Responder Kit Release: We hired Brent back because he promised to fix his code

Publié le 21 mars 2017 sur brentozar.com
 

March comes in like a 40 of Steel Reserve and leaves like your memory of the night after drinking a 40 of Steel Reserve. Get it here! sp_Blitz Improvements — #758 and #756 We made it less scary to run on Express Edition. Why? Because running Expr …

Unexpected side effects of table filters in #dax

Publié le 21 mars 2017 sur sqlblog.com
 

One of the side effects that you might not expect from a table filter in a CALCULATE statement is the removal of an existing filter. In reality, this is a condition that happens when you write an explicit CALCULATE in a row context, because the table f …

TODAY: extending DevOps practices to SQL Server databases

Publié le 21 mars 2017 sur sqlservercentral.com
 

In this free webinar later today, Steve Jones and Arneh Eskandari show how to use migration scripts as part of an automated database deployment. For the demo, they’ll be plugging Redgate’s Database DevOps solution into Git, TeamCity and Oct …

Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

Publié le 21 mars 2017 sur sqlservercentral.com
 

This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.

SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files

Publié le 21 mars 2017 sur journey to sqlauthority
 

This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the initial size itself was huge and when they tried to shr …

Registration is Open for GroupBy.org’s April Free Conference

Publié le 20 mars 2017 sur brentozar.com
 

GroupBy.org is our community training initiative where your votes pick the session lineup. Here’s the lineup you chose for GroupBy April: Friday, April 21: 8AM Eastern – How to Use Parameters Like a Pro and Boost Performance by Guy Gla …

[Video] Office Hours 2017/03/15 (With Transcriptions)

Publié le 20 mars 2017 sur brentozar.com
 

This week, Brent, Richie, and Erik discuss the requirements for getting a Senior DBA or Database Architect job, data migration, encryption, fragmentation, differences between SQL Server 2016 and 2014, update stats strategies for large tables vs small o …

Backups in Azure SQL Data Warehouse

Publié le 20 mars 2017 sur sqlservercentral.com
 

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.

SQL SERVER – sp_readrequest – Long Running Process

Publié le 20 mars 2017 sur journey to sqlauthority
 

Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest  is continuously listed as long running SP. Well, the good part was that it was not taking to …

Performance and Stability Related Fixes in Post-SQL Server 2014 SP2 Builds

Publié le 19 mars 2017 sur sqlskills.com - glen berry
 

As of February 21, 2017, there have been four Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2014. There have been a large number of hotfixes in each of these cumulative updates. If you are running on the SQL Server 2014 SP2 branch …

How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #114

Publié le 19 mars 2017 sur journey to sqlauthority
 

Question: How to Find How Many Rows Each Query Returned Along with Execution Plan? Answer: During my performance tuning consultancy engagement, this is one of the most asked questions. Everyone wants to know how many row any query returned and what is …

Connect Item: Query Plan Hash in sys.dm_exec_query_stats vs Query Plan Hash in the query plan

Publié le 18 mars 2017 sur brentozar.com
 

Shifty Henry said to Bugs You know those moments when you’re looking at something for so long, and it’s still not working, and you’re pretty sure you’re losing that final grip on your sanity? Well, that feeling was multiplied th …

SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request

Publié le 18 mars 2017 sur journey to sqlauthority
 

If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is very helpful and can help in pointing the exact issue r …


Pages :