Sites anglophones


Making a Difference in Uncertain Times

Publié le 11 mai 2020 sur sqlservercentral.com
 

The post Making a Difference in Uncertain Times appeared first on SQLServerCentral.

Free Upcoming Live Classes

Publié le 8 mai 2020 sur brentozar.com
 

So, we’re still under lockdown, huh? I see. Well, I guess I’ve got no choice but to keep y’all busy. Let’s get together for some free live classes: May 9 (Sat) 9AM Eastern: How to Think Like the SQL Server Engine: All Demo Editi …

Capturing DBCC CHECKDB Output

Publié le 8 mai 2020 sur SQLSkills.com - Erin Stellato
 

If you haven’t experienced database corruption in your SQL Server career and had to pore over DBCC CHECKDB output, you’re a lucky soul.  If you encounter corruption, the most important thing you can have is the output, because this hel …

Set Statistics Time Examples for Tuning SQL Server Queries

Publié le 8 mai 2020 sur sqlservercentral.com
 

The post Set Statistics Time Examples for Tuning SQL Server Queries appeared first on SQLServerCentral.

The Curious Case of… extent scan fragmentation

Publié le 7 mai 2020 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

[Video] Updated First Responder Kit and Consultant Toolkit for May 2020

Publié le 7 mai 2020 sur brentozar.com
 

We have quarantined all of the bugs. Many of the bugs. Okay, 7 of the bugs. Hey, we actually added more improvements than we fixed bugs this month! My favorite new things are that sp_BlitzIndex @Mode = 2 now makes it even easier to do disconnected inde …

No, You Can’t Calculate the Tipping Point with Simple Percentages.

Publié le 7 mai 2020 sur brentozar.com
 

This morning, Greg Gonzalez (who I respect) posted about visualizing the tipping point with Plan Explorer (a product I respect), and he wrote: The tipping point is the threshold at which a query plan will “tip” from seeking a non-covering n …

Dynamic SQL Going Haywire

Publié le 7 mai 2020 sur sqlservercentral.com
 

Those who work on various databases, or even those who do not, must have come across the term, Dynamic SQL. Dynamic SQL is basically a programming technique that enables you to build SQL statements dynamically at run time. It allows you to create more …

How to Attach a SQL Server Database without a Transaction Log and with Open Transactions

Publié le 7 mai 2020 sur sqlservercentral.com
 

The post How to Attach a SQL Server Database without a Transaction Log and with Open Transactions appeared first on SQLServerCentral.

Your Views Aren’t The Problem. Your Code Is.

Publié le 6 mai 2020 sur brentozar.com
 

“I hate views,” the DBA said. “They kill performance. And nested views are even worse.” Wrong. I’ll prove it. I’m going to use the 50GB StackOverflow2013 database, and I’ll start by creating a couple of indexes …

Announcing Two New Parameter Sniffing Classes

Publié le 5 mai 2020 sur brentozar.com
 

During the quarantine downtime, I’m working on a couple of new classes that I think you’re gonna like. Both of them are 100% demos, no slides (other than introductions at the start of the day), complete with hands-on lab assignment challeng …

How to Resolve a Duplicate Key Error in SSAS

Publié le 5 mai 2020 sur sqlservercentral.com
 

Problem Often while working with SQL Server Analysis Services, developers come across many errors that restrict them from deploying or processing the cube. In this article, I’m going to explain the reason that causes the Duplicate Key error in SSAS. Th …

How to Add a Filter to an Existing SQL Change Automation Project

Publié le 5 mai 2020 sur sqlservercentral.com
 

The post How to Add a Filter to an Existing SQL Change Automation Project appeared first on SQLServerCentral.

Technology Makes a Difference

Publié le 5 mai 2020 sur sqlservercentral.com
 

The post Technology Makes a Difference appeared first on SQLServerCentral.

Working From Home with Kids: 7 Weeks In

Publié le 4 mai 2020 sur SQLSkills.com - Erin Stellato
 

I’ve been meaning to write a follow up post to my original to discuss what life is REALLY like during quarantine.  I re-read my original post and then starting writing, but after about two pages realized it was more a journal entry than an i …


Pages :