Sites anglophones


Stairway to Azure SQL Database: Level 1 Getting Started

Publié le 13 juin 2018 sur sqlservercentral.com
 

In this first level, learn how to get started with Azure and Azure SQL Database.

SQL SERVER – Performance Comparison IN vs OR

Publié le 13 juin 2018 sur journey to sqlauthority
 

Some questions never get old and some question and I believe we will be discussing them for many more years in the future. Just other days, I received this question during my SQL Server Performance Tuning Practical Workshop. The question was about …

New Stack Overflow Public Database Available (2018-06)

Publié le 12 juin 2018 sur brentozar.com
 

@Taryn and the kind folks at Stack Overflow publish their data export periodically with your questions, answers, comments, user info, and more. It’s available as an XML data dump, which I then take and import into SQL Server for teaching performa …

Indexing Strategies For Cross Apply

Publié le 12 juin 2018 sur brentozar.com
 

Slicked Brad The apply operator remains one of my favorite tools, but much like CTEs and windowing functions, they’re not totally magical unless you look at your indexes. Starting with a dead simple query on the Users table, it’d be easy to …

Using Power BI in a Hybrid Environment

Publié le 12 juin 2018 sur sqlservercentral.com
 

This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many or …

Dynamic File Column mapping in SSIS.

Publié le 12 juin 2018 sur sqlservercentral.com
 

An efficient and reliable method for reading CSV files with variable columns.

Indexes That Have Not Been Used but Are Being Updated

Publié le 12 juin 2018 sur sqlservercentral.com
 

Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.

SQL SERVER – SSMS 17.7 Observation – Two Miscellaneous Category in Database Property Options

Publié le 12 juin 2018 sur journey to sqlauthority
 

First of all this observation is only applicable if you are using SSMS 17.7 build. It was very interesting to me that I was able to find two Miscellaneous categories in Database Property Option for SQL Server. Please note the version of SQL Server …

New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems

Publié le 11 juin 2018 sur sqlskills.com - paul randall
 

Continuing our series of live, online classes, Erin, Jonathan, and Kimberly will be delivering their new IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems in October! The class w …

New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning

Publié le 11 juin 2018 sur sqlskills.com - paul randall
 

Continuing our series of live, online classes, Kimberly will be delivering her new IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning in October! The class will be delivered live via WebEx …

New live online training class in August: Planning and Implementing an Upgrade/Migration to SQL Server 2017

Publié le 11 juin 2018 sur sqlskills.com - paul randall
 

Continuing our series of live, online classes, Glenn will be delivering his new IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017 in August! The class will be delivered live via Web …

Building SQL ConstantCare®: Why People Aren’t Using Query Store

Publié le 11 juin 2018 sur brentozar.com
 

When Microsoft first talked about Query Store, I was wildly excited. It’s basically a black box flight data recorder for SQL Server, tracking which queries run over time, how much work they do, and how their execution plans change. And then it ca …

SQL Prompt Safety Net Features for Developers

Publié le 11 juin 2018 sur sqlservercentral.com
 

Phil Factor describes a few common mishaps that everyone working in SSMS will have experienced a couple of times, and how SQL Prompt “Tab Magic” (now more prosaically called Tab Color and Tab History) provides ‘insurance’ agains …

Improving SQL Server 2016 Large Database Performance

Publié le 11 juin 2018 sur sqlservercentral.com
 

This article aims to save you days or weeks of troubleshooting when using SQL Server 2016 for large databases

SQL SERVER – How to Fix CONVERT_IMPLICIT Warnings?

Publié le 11 juin 2018 sur journey to sqlauthority
 

One of the biggest issues I see with at various of my customer who signed up at Comprehensive Database Performance Health Check is about CONVERT_IMPLICIT. As soon as I demonstrate my customer that they are not getting performance due to  …


Pages :