Sites anglophones


Registration is Open for GroupBy.org’s April Free Conference

Publié le 20 mars 2017 sur brentozar.com
 

GroupBy.org is our community training initiative where your votes pick the session lineup. Here’s the lineup you chose for GroupBy April: Friday, April 21: 8AM Eastern – How to Use Parameters Like a Pro and Boost Performance by Guy Gla …

[Video] Office Hours 2017/03/15 (With Transcriptions)

Publié le 20 mars 2017 sur brentozar.com
 

This week, Brent, Richie, and Erik discuss the requirements for getting a Senior DBA or Database Architect job, data migration, encryption, fragmentation, differences between SQL Server 2016 and 2014, update stats strategies for large tables vs small o …

Backups in Azure SQL Data Warehouse

Publié le 20 mars 2017 sur sqlservercentral.com
 

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.

SQL SERVER – sp_readrequest – Long Running Process

Publié le 20 mars 2017 sur journey to sqlauthority
 

Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest  is continuously listed as long running SP. Well, the good part was that it was not taking to …

Performance and Stability Related Fixes in Post-SQL Server 2014 SP2 Builds

Publié le 19 mars 2017 sur sqlskills.com - glen berry
 

As of February 21, 2017, there have been four Cumulative Updates (CU) for the Service Pack 2 branch of SQL Server 2014. There have been a large number of hotfixes in each of these cumulative updates. If you are running on the SQL Server 2014 SP2 branch …

How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #114

Publié le 19 mars 2017 sur journey to sqlauthority
 

Question: How to Find How Many Rows Each Query Returned Along with Execution Plan? Answer: During my performance tuning consultancy engagement, this is one of the most asked questions. Everyone wants to know how many row any query returned and what is …

Connect Item: Query Plan Hash in sys.dm_exec_query_stats vs Query Plan Hash in the query plan

Publié le 18 mars 2017 sur brentozar.com
 

Shifty Henry said to Bugs You know those moments when you’re looking at something for so long, and it’s still not working, and you’re pretty sure you’re losing that final grip on your sanity? Well, that feeling was multiplied th …

SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request

Publié le 18 mars 2017 sur journey to sqlauthority
 

If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is very helpful and can help in pointing the exact issue r …

sp_BlitzCache Tip: Cutting Through Heavy Dynamic SQL Use

Publié le 17 mars 2017 sur brentozar.com
 

It keeps me up at night Out of the box, sp_BlitzCache will give you enough stuff to work on in your server’s plan cache to last a month of leap days. This is great for most people, but if you use a ton of dynamic SQL in stored procedures, it can …

SQL Server Bulk Insert Row Terminator Issues

Publié le 17 mars 2017 sur sqlservercentral.com
 

We often need to import data into SQL Server from a file. Sometimes unwanted end of line characters are part of the source file and these can create issues when importing the data. One of the ways to avoid this issue is to use SQL Server Integration Se …

SQL SERVER – Availability Group Missing or Deleted Automatically?

Publié le 17 mars 2017 sur journey to sqlauthority
 

As a part of my passion, I try to help people in fixing simple issues and explain the behavior by looking at logs. Here is an email from my friend about Availability Group Missing or Deleted Automatically. Pinal, We need your services again to hel …

Do you get our bi-weekly newsletter?

Publié le 17 mars 2017 sur sqlskills.com - paul randall
 

You may not know this, but for the last six years I’ve been producing a bi-weekly newsletter for everyone signed up for our mailing list (which we only use for the newsletter). It’s a bit of a labor of love, and a way for me to post opinion …

My World Tour

Publié le 16 mars 2017 sur sqlblog.com
 

I just finished my last stop on my “World Tour”. The cities included Toronto, Johannesburg, Hong Kong, Sydney, Milan, and Singapore. I missed South America and Antarctica on this “tour”, but I hit the other continents. I was par …

Indexed Views And Data Modifications

Publié le 16 mars 2017 sur brentozar.com
 

Love/Hate When indexed views help, they make aggregation queries super fast. There are some kind of horrible limitations and requirements. When they hurt, your modifications slow to a crawl because SQL has to not only keep your horrible indexes synchro …

Installing SQL Server vNext on an AWS EC2 RHEL Instance

Publié le 16 mars 2017 sur sqlservercentral.com
 

The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step …


Pages :