Sites anglophones


Filegroup Restoring and Join Elimination

Publié le 10 août 2017 sur sqlservercentral.com
 

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

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

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

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

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 sqlskills.com - 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 sqlskills.com - 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 SQLskills.com 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 sqlmag.com
 

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

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

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

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

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 :