Sites anglophones


SQLskills SQL101: Should you kill that long-running transaction?

Publié le 10 octobre 2017 sur sqlskills.com - paul randall
 

As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologi …

SSMS 17.3 is available for download

Publié le 10 octobre 2017 sur sqlblog.com
 

  The latest version of SSMS ( SQL Server Management Studio 17.3 ) is now available to download. There are a bunch of new features in addition to the usual bug fixes but some of the more popular ones are a new wizard to import flat files, increase …

How to Do a Free SQL Server Health Check

Publié le 10 octobre 2017 sur brentozar.com
 

Your boss or client came to you and said, “Give me a quick health check on this SQL Server.” Step 1: Download & run sp_Blitz. Go to our download page and get our First Responder Kit. There’s a bunch of scripts and white papers in …

SSMS 17.3 has Profiler built-in

Publié le 10 octobre 2017 sur sqlblog.com
 

We all know that Profiler and its background functionality SQL Trace has been deprecated since 2012. Right? And we have all switched to using Extended Events (XE), a long time ago, right? No, the reality is that many of us still uses the old tracing in …

The BigData Legacy

Publié le 10 octobre 2017 sur sqlblog.com
 

Trends come along, and trends pass. Some hang around for quite a while, and then move on, and some seem to disappear quickly. Often we’re glad that they’ve gone, but we still bear scars. We live and work differently because they were there. …

How to examine differences with SQL Compare Summary View and SQL View

Publié le 10 octobre 2017 sur sqlservercentral.com
 

In this video, Steve Jones introduces the new Summary View that’s now available in Redgate SQL Compare. 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 an …

WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits

Publié le 10 octobre 2017 sur sqlservercentral.com
 

An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.

Data Starvation – Balance Your SQL Server – Part 1

Publié le 10 octobre 2017 sur journey to sqlauthority
 

With the new Intel Skylake CPUs coming out recently it seemed like a good time to discuss CPU resources and how to know if they’re running optimally.  After all, there’s little sense in upgrading your server if your current one is alre …

[Video] Office Hours 2017/10/4 (With Transcriptions)

Publié le 9 octobre 2017 sur brentozar.com
 

This week, Brent, Tara, and Richie discuss what they think about having no more service packs for SQL Server 2017 and newer versions, shrinking log files, how many servers can one DBA manage, log backups, mirroring vs Availability Groups vs log shippin …

Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools

Publié le 9 octobre 2017 sur sqlservercentral.com
 

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn’t. But one particularly common culprit is when …

Azure DWH part 18: Working with SQL Server Analysis Services

Publié le 9 octobre 2017 sur sqlservercentral.com
 

In this new article, we will learn how to create a cube extracting data from ADWH.

Easy way to create policies using SSMS

Publié le 9 octobre 2017 sur simple-talk.com
 

SSMS has an interesting feature that turns easy the creation of policies to check our servers compliance. Right-clicking an item inside object explorer window, you will find ‘Facet’ item in the context menu. Clicking on it will open the …

SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with Error 0x2, Status Code 0x38

Publié le 9 octobre 2017 sur journey to sqlauthority
 

I just love my On Demand offering because it gives me more pleasure of assisting clients who are in urgent need of an SQL expert. Most of the time I am called for help when clients are not able to start SQL Service due to some reason. Today we will see …

[Video] Office Hours 2017/09/13 (With Transcriptions)

Publié le 8 octobre 2017 sur brentozar.com
 

Note: this is coming to you from the past due to technical difficulties. This week, Brent and Erik discuss Availability Group issues, database diagram tools, AWS vs Azure, diagnosing async io waits, troubleshooting deadlocks, extended events, using sam …

How to Create Primary Key Without ANY Index? – Interview Question of the Week #142

Publié le 8 octobre 2017 sur journey to sqlauthority
 

Question: How to Create Primary Key Without ANY Index? Answer: Before you jump and say you know this answer, I request you to read the question one more time. In SQL Server, when we create Primary Key Constraint, it automatically creates Clustered Inde …


Pages :