Sites anglophones

Filegroup Restoring and Join Elimination

Publié le 10 août 2017 sur

This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.

SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes

Publié le 10 août 2017 sur journey to sqlauthority

During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes. Question: What actually are Query Optimizer Fixes under Database Scoped Configurations? Should we turn Query Op …

Upgrading SQL Server–Day 9

Publié le 9 août 2017 sur - glen berry

Part of the upgrade and migration process is keeping your existing SQL Server instances properly patched. Being on a minimum Service Pack level is often required in order for some types of upgrade and migration operations. It is also required to be in …

Out of Office: Time for the 2017 Brent Ozar Unlimited Retreat

Publié le 9 août 2017 sur

“Now I just need a big enough drink glass” For the next 10 days, we’ll still be publishing scheduled blog posts, but we’ll be responding a little slower than usual, and probably a little more relaxed as well. That’s right …

Stairway to AlwaysOn Level 2: Storage 101

Publié le 9 août 2017 sur

In this new level of the stairway, we examine the storage knowledge you need for an AlwaysOn configuration.

Microsoft IT: A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1

Publié le 9 août 2017 sur

This paper shares the approach used to understand and determine: 1) Using ‘Hekaton’ in SQL Server 2014 against RPM, including performance analysis. 2) Understand the specifics involved while migrating to Hekaton.

SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard

Publié le 9 août 2017 sur journey to sqlauthority

It has been quite a long time since I stopped posting about various SQL downloads available on the interest. The reason was that many users were not interested in learning about it. However the latest release of SQL Server Management Studio (SSMS) …

Playing the Third-Party Recruiter Game (T-SQL Tuesday #093)

Publié le 8 août 2017 sur

Finding a new job can be a long and stressful proposition. This holds true even for skilled candidates. And even for skilled candidates in an atmosphere like we have in 2017—in which everyone who is employable is, for the most part, employed, and …

Upgrading SQL Server–Day 8

Publié le 8 août 2017 sur - glen berry

Back in December of 2012, I wrote a fairly long article called Making the Case for a SQL Server Platform Refresh that made the argument that late 2012 was a good time to make a compelling case for a complete platform refresh, where you would get new se …

Competition: win a free seat in our classes in October!

Publié le 8 août 2017 sur - paul randall

We’re really excited about the classes we’ve got coming up in Chicago and to say ‘thank you’ to the SQL community for all your support of over the years, we’re running a competition. It’s been a while s …

Puzzle Challenge: Graph Matching with T-SQL Part 1-Concepts

Publié le 8 août 2017 sur

A few years ago, I stumbled into a T-SQL puzzle. I didn’t really give much thought to its practical use cases, but it recently occurred to me that there must be interesting practical use cases for this puzzle, as well as a more formal definition …

Five Mistakes Performance Tuners Make

Publié le 8 août 2017 sur

There’s no Top in the title And that’s because a TOP without an ORDER BY is non-deterministic, and you’ll get yelled at on the internet for doing that. This is just a short collection of things that I’ve done in the past, and st …

Removing sensitive data from a database

Publié le 8 août 2017 sur

It’s fairly widely known that just because you delete data from a database, it doesn’t mean it’s gone from the data file itself, but the question is, how should you go about removing it?

Fixing Plan Issues in the Middle of the Night

Publié le 8 août 2017 sur

Do you hate when someone wakes you up in the middle of the night and tells you that some query is slower and you need to investigate it? With SQL Server 2017 you might easily do this, or even let SQL Server do this job for you.

How to Automatically Create and Refresh Development and Test Databases

Publié le 8 août 2017 sur

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database …

Pages :