Sites anglophones


Renaming a Schema in SQL Server

Publié le 25 septembre 2018 sur sqlservercentral.com
 

If you have a schema you want to retire, here’s a method for moving all objects inside that schema to a new one.

Adaptive Query Processing in SQL Server

Publié le 25 septembre 2018 sur sqlservercentral.com
 

Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.

SQL Authority News – Microsoft Released SQL Server 2019 Preview

Publié le 25 septembre 2018 sur journey to sqlauthority
 

The wait is over. Microsoft has just announced SQL Server 2019 Preview in the Ignite conference. Lots of people were wondering if there is going to be any SQL Server 2018. The answer is Microsoft is going to skip this year as a release for SQL Server a …

What’s New in SQL Server 2019 System Tables

Publié le 24 septembre 2018 sur brentozar.com
 

The free SQL Server 2019 preview download is out, and here are quite a few things to check out that aren’t documented yet: New System Objects Starting with new stored procedures: sys.sp_add_feature_restriction sys.sp_autoindex_cancel_dta sys.sp_a …

SQL Server Build Lists

Publié le 24 septembre 2018 sur sqlservercentral.com
 

Here are the various build lists that are published on SQL Server. SQL Server 2019 SQL Server 2017 SQL Server 2016 SQL Server 2014 SQL Server 2012 SQL Server 2008 R2 SQL Server 2008 SQL Server 2005 SQL Server 2000 SQL Server 7 SQL Server 6 Please feel …

What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

Publié le 24 septembre 2018 sur brentozar.com
 

The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Serv …

What’s New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues)

Publié le 24 septembre 2018 sur brentozar.com
 

For over a decade, SQL Server’s handling of table variables has been legendarily bad. I’ve long used this Stack Overflow query from Sam Saffron to illustrate terrible cardinality estimation:declare @VoteStats table (PostId int, up int, …

What’s New in SQL Server 2019: Adaptive Memory Grants

Publié le 24 septembre 2018 sur brentozar.com
 

When you run a query, SQL Server guesses how much memory you’re going to need for things like sorts and joins. As your query starts, it gets an allocation of workspace memory, then starts work. Sometimes SQL Server underestimates the work you …

Questions About HIPAA That You Were Too Shy to Ask

Publié le 24 septembre 2018 sur sqlservercentral.com
 

As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to day responsibilities. Rebecca Edwards answers common questions about HIPAA that you were too shy to ask.

Uploading On-Premise data to Azure Blob Storage using SSIS

Publié le 24 septembre 2018 sur sqlservercentral.com
 

Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task.

SQL SERVER – Selecting Random n Rows from a Table

Publié le 24 septembre 2018 sur journey to sqlauthority
 

Every day I spend a good amount of time with different customers helping them with SQL Server Performance Tuning issues. Today we will discuss the question asked by a developer at the organization where I was engaged in Comprehensive Database Perf …

[Video] Office Hours 2018/9/19 (With Transcriptions)

Publié le 23 septembre 2018 sur brentozar.com
 

This week, Brent, Tara, Erik, and Richie discuss moving views between databases, Cluster Quorum File Share on AlwaysOn, checking for corruption, rebooting/restarting SQL server after applying cumulative updates, how many drive letter to use for a VM, d …

How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192

Publié le 23 septembre 2018 sur journey to sqlauthority
 

Question: How to Escape a Single Quote in SQL Server? Answer: Yesterday, I had an opportunity to visit a SQL User Group in Bangalore, India, and during the event, I had received a very simple question from a college student. As soon as he asked th …

Leaked: SQL Server 2019 Big Data Clusters Introduction Video

Publié le 22 septembre 2018 sur brentozar.com
 

Psst – you’re probably not supposed to see this yet, but look what @WalkingCat found: SQL Server 2019 Vision pic.twitter.com/zbjI28FYSu — WalkingCat (@h0x0d) September 21, 2018 What the video says Growing volumes of data create deep p …

SQL SERVER – Query to Find the Longest Running Function – Function Elapsed Time

Publié le 22 septembre 2018 sur journey to sqlauthority
 

I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server. …


Pages :