Sites anglophones


How much should you worry about CXPACKET?

Publié le 11 septembre 2017 sur simple-talk.com
 

Several experts already wrote about CXPACKET before, there are plenty of articles about this subject on the internet, so, why one more? I think I can add my two cents to this subject with an example to emphasize an important sentence that several autho …

How to Insert Line Break in SQL Server String? – Interview Question of the Week #138

Publié le 10 septembre 2017 sur journey to sqlauthority
 

Question: How to Insert Line Break in SQL Server String? Answer: I personally prefer that SQL Server does not deal with string operations, as SQL language is honestly made for relational operations. However, now as we have this question presented …

SQL SERVER – Unable to Get Listener Properties Using PowerShell – An Error Occurred Opening Resource

Publié le 9 septembre 2017 sur journey to sqlauthority
 

I was engaged with a client for an AlwaysOn project and they had some follow-up questions. I took some time to find the answers and encountered an interesting error. I am sharing them here so that others can get benefited. They informed me that they ar …

Missing Data

Publié le 8 septembre 2017 sur simple-talk.com
 

The textbooks always show beautiful, perfect data. It’s always completely there, it never has to be scrubbed: Then you get to your first job. In the real world, bad data is one problem, but you also have to deal with the fact that sometimes you j …

How Much Can One Column Change A Query Plan? Part 2

Publié le 8 septembre 2017 sur brentozar.com
 

What happened in Part 1? Join Elimination, naturally. Until the end. My copy of the Stack Overflow database doesn’t have a single foreign key in it, anywhere. If we go down the rabbit hole a couple steps, we end up at a very quotable place, with …

Creatures of habit, snowflakes, and integration tax

Publié le 8 septembre 2017 sur sqlservercentral.com
 

Why are practices like version control, continuous integration and automated deployment being introduced to application development but left on the shelf when it comes to the database? In search of some answers, Redgate spoke to Donovan Brown, Principa …

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

Publié le 8 septembre 2017 sur sqlservercentral.com
 

SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.

SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns customers

Publié le 8 septembre 2017 sur journey to sqlauthority
 

Unique key on a column is used to identify a particular row easily. It is created either by explicitly mentioning it either part of the definition or when defined as Primary key (By default it is unique and not null). Let us learn about special stored …

Creating Basic Indexes on the Stack Overflow Public Database

Publié le 7 septembre 2017 sur brentozar.com
 

My public SQL Server database copy of the Stack Overflow data dump only includes clustered indexes by default. I want to keep your database size as small as possible for quick downloading. But like any database – when you create it, should you ad …

Why don’t you unit test SQL Server code?

Publié le 7 septembre 2017 sur sqlservercentral.com
 

This post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. Even if you have a large code base and no existing unit tests, you can start introducing tests now to make your da …

The Shortcomings of Predictive Accuracy

Publié le 7 septembre 2017 sur sqlservercentral.com
 

In prediction, accuracy is key. But it’s not all it’s cracked up to be as we will explore.

SQL SERVER – System Procedure to List Out Table From Linked Server

Publié le 7 septembre 2017 sur journey to sqlauthority
 

There is a system procedure named sp_tables which is used to list out the tables available in the CURRENT database of the CURRENT server. But did you know that th …

Six Scary SQL Surprises

Publié le 6 septembre 2017 sur simple-talk.com
 

In the Happy Database movies, SQL Server is benign and friendly, with no scary surprises lurking around the next corner. In these movies: People work together No-one but the DBA can make changes to production People tell us in advance when they want to …

SQL Server R Services: Working with Data Frames

Publié le 6 septembre 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 R Services: Working with Data Frames In the first article in this series …

SQL Server on Linux is the New SQL Server on Windows Core

Publié le 6 septembre 2017 sur brentozar.com
 

When Windows Server 2012 came out with Core, I heard some rather suspicious things at conferences like: “I’ll be able to take way less patching outages!” “It’ll be so much faster because it has less overhead!” …


Pages :