Sites anglophones


Azure Data Factory Multiple File Load Example – Part 2

Publié le 12 février 2020 sur sqlservercentral.com
 

The post Azure Data Factory Multiple File Load Example – Part 2 appeared first on SQLServerCentral.

#TSQL2sday: My Life Hacks

Publié le 11 février 2020 sur SQLSkills.com - Erin Stellato
 

 T-SQL TuesdayJess Pomfret (newly awarded MVP!) is hosting month’s T-SQL Tuesday, and asked us to share our favorite life hacks – something that makes our day easier.  I have two that I consider indispensable.The first is Toggl, a …

#TSQL2sday: My Life Hack is an Hourglass. Yes, an Hourglass.

Publié le 11 février 2020 sur brentozar.com
 

For this month’s T-SQL Tuesday, Jess Pomfret asked for our favorite life hacks. My life hack is a half-hour hourglass. (Halfhourglass?) Seriously, an actual physical object: I keep it on my desk. Whenever I start working on a task, I flip the gla …

SQL SERVER – OPTION(FAST N) Hint and Performance

Publié le 11 février 2020 sur journey to sqlauthority
 

SQL Server 2019 is indeed very well made software by Microsoft. Recently, I have a very interesting situation while working with SQL Server 2019, which I had not faced before about OPTION(FAST N). While busy with Comprehensive Database Performance Heal …

Queue table issues with Availability Groups in SQL Server

Publié le 11 février 2020 sur sqlservercentral.com
 

The post Queue table issues with Availability Groups in SQL Server appeared first on SQLServerCentral.

The Dangers of using Float or Real Datatypes

Publié le 11 février 2020 sur sqlservercentral.com
 

The post The Dangers of using Float or Real Datatypes appeared first on SQLServerCentral.

Shell Scripting Standards

Publié le 11 février 2020 sur sqlservercentral.com
 

Abstract: The purpose of this document is to detail standards for coding shell scripts. Following these standards will help create shell scripts that are easy to read, understand, and maintain. The intent is that the database admins & developers ac …

Get Your Scalar UDFs to Run Faster Without Code Changes

Publié le 10 février 2020 sur simple-talk.com
 

Over the years, you probably have experienced or heard that using user-defined functions (UDF’s) do not scale well as the number of rows processed gets larger and larger. Which is too bad, because we have all heard that encapsulating your code in …

But the Database Worked in Development! Checking for Duplicates

Publié le 10 février 2020 sur simple-talk.com
 

The series so far: But the Database Worked in Development! Preventing Broken Constraints But the Database Worked in Development! Checking for Duplicates Like all grownup database developers, you will do your best to ensure that there are unique constra …

How to Pick a 2020 Microsoft Database Conference

Publié le 10 février 2020 sur brentozar.com
 

As a consultant and speaker, I’m lucky enough to go to a crazy number of SQL Server conferences. Here’s what I think of each mainstream conference out there – who they’re for, and who they’re not for. SQL Saturdays 2020 da …

SQL SERVER – Top Reasons for Slow Performance

Publié le 10 février 2020 sur journey to sqlauthority
 

Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. I had received a lot of interesting answers and perspectives on that topic. Lots of people also sent me a detailed email as they thought there is n …

New: 2020 State of Database DevOps report

Publié le 10 février 2020 sur sqlservercentral.com
 

The post New: 2020 State of Database DevOps report appeared first on SQLServerCentral.

Introduction to Attribute Relationships in SSAS

Publié le 10 février 2020 sur sqlservercentral.com
 

Introduction Attribute Relationships are usually defined in SSAS when there is a one-to-many relationship between the members within the same dimension. A very common example where we need to define attribute relationships is while developing a Geograp …

The Curious Case of… restoring a table into a different database

Publié le 9 février 2020 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

What is the Replacement of DBCC DBREINDEX? – Interview Question of the Week #263

Publié le 9 février 2020 sur journey to sqlauthority
 

Question: What is the Replacement of DBCC DBREINDEX?Answer: The answer to this question is very simple.Here is the syntax of the ALTER INDEX Rebuilding index.ALTER INDEX IndexName ON TableName REBUILD;It is a very simple syntax. Here is another syntax …


Pages :