Sites anglophones


Simple SQL: Random Thoughts

Publié le 11 août 2017 sur simple-talk.com
 

“Anyone who considers arithmetical methods of producing random digits is, of course, in a state of sin.” – John von Neumann John von Neumann was not against the use of pseudo-random numbers, but he thought that you will be very, very …

SQL Server R Services: Working with ggplot2 Statistical Graphics

Publié le 11 août 2017 sur simple-talk.com
 

The series so far: SQL Server R Services: The Basics SQL Server R Services: Digging into the R Language SQL Server R Services: Working with ggplot2 Statistical Graphics SQL Server 2016 ships with SQL Server R Services, a new component that incorporates …

How to Drop All Your Indexes – Fast

Publié le 11 août 2017 sur brentozar.com
 

Sometimes I need to reset stuff during performance training classes. I know some of you teach classes, too, and some of you just like doing crazy stuff. So here you go, a stored procedure to lose weight fast: CREATE PROCEDURE [dbo].[DropIndexes] AS SET …

Introduction to Azure SQL Data Sync

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

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Pre …

SQL SERVER – Difference Between spid, kpid and ecid in sysprocesses

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

Question: What is the difference between spid, kpid and ecid in sysprocesses? Answer: When I received this question, I actually went and checked SQLAuthority.com blog as I thought I have blogged about it, but the reality was that I had not blogged abou …

Upgrading SQL Server–Day 10

Publié le 10 août 2017 sur sqlskills.com - glen berry
 

One crucial part of doing a complete data platform upgrade is proper hardware and processor selection. Because of how SQL Server 2012 and newer core-based licensing works, processor selection is extremely important from a performance/scalability perspe …

sp_AllNightLog: Creating Jobs Like I’m The President

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

Look, we need these things The setup for sp_AllNightLog creates jobs for four separate activities 1 job to poll for new databases to back up (primary) 1 job to poll for new databases to restore (secondary) 10 jobs to poll for backups to take (primary) …

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 …

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.

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.

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 …


Pages :