Sites anglophones


Why Order Isn’t Guaranteed Without an ORDER BY

Publié le 15 mai 2019 sur brentozar.com
 

Start with the Stack Overflow database, with no nonclustered indexes. If you’ve been playing around with demos, run my DropIndexes proc just to clear things out, which leaves the clustered indexes in place. Say you run this query:SELECT TOP 100 I …

SQL SERVER – Automatic Seeding of Availability Database ‘DB’ in Availability Group ‘AG’ Failed With an Unrecoverable Error

Publié le 15 mai 2019 sur journey to sqlauthority
 

While deploying Always On Availability Group with a client, they found that when they use automatic seeding, the database was not shown on secondary. After digging more, we found that it was there earlier in “Restoring” state when seeding w …

Types of SQL Server Temporary Tables

Publié le 15 mai 2019 sur sqlservercentral.com
 

The post Types of SQL Server Temporary Tables appeared first on SQLServerCentral.

Queries with OPTION (RECOMPILE) and Query Store

Publié le 14 mai 2019 sur SQLSkills.com - Erin Stellato
 

 Last week in our IEPTO2 class I was asked about queries with OPTION (RECOMPILE) and Query Store. Specifically: Do queries that have the OPTION (RECOMPILE) hint go into Query Store, AND do queries in a stored procedure created with the RECOMPILE o …

Which Queries Should You Cache in the Application?

Publié le 14 mai 2019 sur brentozar.com
 

I’ve talked about how the fastest query is the one you never make, and why when you’re scaling up a database application, you probably want to start caching query results in the app tier. Caching means: Less licensing costs for SQL Server L …

SQL SERVER – T-SQL Script to List Automatic Seeding of Always On Availability Group

Publié le 14 mai 2019 sur journey to sqlauthority
 

I love blog post which just solves a simple point and immediately gets us the necessary answer. Recently during one of the consulting engagement Comprehensive Database Performance Health Check at one of my customer place we identified a wait statistics …

Importing Data into Azure SQL Database

Publié le 14 mai 2019 sur sqlservercentral.com
 

The post Importing Data into Azure SQL Database appeared first on SQLServerCentral.

Using Azure Data Studio with Git

Publié le 14 mai 2019 sur sqlservercentral.com
 

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azu …

Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy

Publié le 14 mai 2019 sur sqlservercentral.com
 

SQL Server Integration Services (SSIS) is a great tool for building ETL processes.  On SQL Server, we can configure an Integration Services Catalog to deploy and configure all the SSIS packages. When using this service, there is also a catalog dat …

SQL For Cosmos DB – Handling Complex JSON Structures

Publié le 14 mai 2019 sur simple-talk.com
 

The series so far: Introduction to SQL for Cosmos DB SQL For Cosmos DB – Tips and Tricks SQL For Cosmos DB – Handling Complex JSON Structures JSON allows for nested nodes, arrays and arrays of objects, and Cosmos DB SQL can handle all of th …

Samsung Portable SSD X5 Review

Publié le 13 mai 2019 sur sqlskills.com - glen berry
 

If you have a fairly recent PC or Mac with a Thunderbolt 3 port, and you want/need some very high performance external storage, one of your best choices will be an external Thunderbolt 3 drive, especially one that uses an M.2 NVMe NAND flash drive with …

Creating Your First SQL Server Docker Container in macOS

Publié le 13 mai 2019 sur simple-talk.com
 

It is not surprising that macOS has become the platform of choice when designing, creating or developing new SQL Server solutions. Microsoft has invested important time and resources to create a set of very powerful cross platform (Windows, Linux, macO …

SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback

Publié le 13 mai 2019 sur journey to sqlauthority
 

There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server. Just the other day I had an early adopter customer who was usi …

Join DBAle’s data privacy competition!

Publié le 13 mai 2019 sur sqlservercentral.com
 

The post Join DBAle’s data privacy competition! appeared first on SQLServerCentral.

October IEPTO1 and IEAzure classes open for registration

Publié le 13 mai 2019 sur sqlskills.com - paul randall
 

We thought we were only going to present in-person classes in Spring this year, but as IEPTO1 and IEAzure both sold out and had long wait lists, we’ve added new deliveries of those classes in October! Our classes in October will be in C …


Pages :