Sites anglophones


SQL Prompt Hidden Gems: The SSMS Results Pane

Publié le 21 juin 2018 sur sqlservercentral.com
 

Louis Davidson explores the hidden treasures within SQL Prompt right-click context menu when working in the SSMS grid format results pane.

Converting Trace to Extended Events

Publié le 21 juin 2018 sur sqlservercentral.com
 

A walkthrough of a conversion of a SQL Trace setup to an Extended Event session. 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 how to find and fix the root causes o …

In-Memory OLTP – SQL Server In-Memory OLTP Internals Overview

Publié le 21 juin 2018 sur sqlservercentral.com
 

In-Memory OLTP (project “Hekaton”) is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve significant improvem …

SQL SERVER – Transfer Logins Error: Msg 15419: Supplied Parameter sid Should be Binary(16) – sp_help_revlogin

Publié le 21 juin 2018 sur journey to sqlauthority
 

While I was writing my earlier blog, I came across another interesting issue with sp_help_revlogin script. In this blog we would learn about the cause of Msg 15419, “Supplied parameter sid should be binary(16)” while transferring the login …

AMD Ryzen Threadripper 2990X CPU-Z Leaks?

Publié le 20 juin 2018 sur sqlskills.com - glen berry
 

On June 5, 2018, during the Computex show in Taiwan, AMD revealed some details about its upcoming 12nm 2nd generation Ryzen Threadripper processor family that will have up to 32 physical cores (and 64 threads with SMT) that will work on existing X399 m …

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

Publié le 20 juin 2018 sur brentozar.com
 

sp_BlitzIndex gives your indexes a psychiatrist-style evaluation. It’s a lot like a real psychiatrist: it’s just flagging behaviors, and there’s not necessarily anything wrong with being a hoarder, or a workaholic, or a furry. Th …

Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3

Publié le 20 juin 2018 sur simple-talk.com
 

The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Desktop provides a p …

Welcome to the new world of curating data, not owning it

Publié le 20 juin 2018 sur sqlservercentral.com
 

Faced with the new challenges of data protection – and increased levels of oversight – many of us working with SQL Server have come to the same conclusion. Quite simply, the column names and free text descriptions available to us to describ …

Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes

Publié le 20 juin 2018 sur sqlservercentral.com
 

SQL SERVER – Unable to Install Reporting Service Add-In for SharePoint – System.ArgumentException

Publié le 20 juin 2018 sur journey to sqlauthority
 

There are so many components in SQL Server and sometimes there is an error in installing components which I have not used at all. One such component is SSRS with SharePoint. To use this, we need to install Reporting Service Add-In for SharePoint. In th …

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

Publié le 19 juin 2018 sur sqlskills.com - glen berry
 

As of May 30, 2018, there has been one Cumulative Update (CU) for the Service Pack 2 branch of SQL Server 2016. There have been a large number of hotfixes in each of these cumulative updates. If you are running on the SQL Server 2016 SP2 branch (which …

A Surprising Simplification Limitation

Publié le 19 juin 2018 sur brentozar.com
 

When It Comes To Simplification Rob Farley has my favorite material on it. There’s an incredible amount of laziness ingenuity built into the optimizer to keep your servers from doing unnecessary work. That’s why I’d expect a query lik …

Databases with MAXSIZE Set

Publié le 19 juin 2018 sur sqlservercentral.com
 

Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database. When t …

SQL Server Database Corruption Detect

Publié le 19 juin 2018 sur sqlservercentral.com
 

How to detect DB corruption ASAP…

Reducing risk with Smart Recommendations in SQL Census

Publié le 19 juin 2018 sur sqlservercentral.com
 

Redgate are reducing risk with Smart Recommendations in SQL Census


Pages :