Sites anglophones


Sit Down. We Need to Talk About Your Scalar Functions.

Publié le 25 juin 2020 sur brentozar.com
 

Thanks for coming today. I apologize for baiting you in here with a picture of toilet paper. That’s not even in the US – that’s from my Iceland trip, before I flew back here to the US. Look, we all make mistakes. That’s not the …

 

Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines

Publié le 24 juin 2020 sur simple-talk.com
 

The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines A discussion of how columnstore indexes work is important for making the best use of them, but a practical …

 

How to Upgrade SQL Server Evaluation Edition to Developer Edition

Publié le 24 juin 2020 sur brentozar.com
 

Six months ago today, you installed SQL Server Evaluation Edition. You told yourself you’d take care of that sooner or later, and…you forgot. Now, your SQL Server won’t start: Error 17051: SQL Server evaluation edition has expired. A …

When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation

Publié le 24 juin 2020 sur sqlservercentral.com
 

The post When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation appeared first on SQLServerCentral.

Solving Oracle Performance Issues in 4 Easy Steps

Publié le 24 juin 2020 sur sqlservercentral.com
 

The post Solving Oracle Performance Issues in 4 Easy Steps appeared first on SQLServerCentral.

Bad Idea Jeans: Building Big Query Plans

Publié le 23 juin 2020 sur brentozar.com
 

When you build a monitoring tool that sends advice via email, you discover two things: Some people have really, really big execution plans Email servers have reasonable limits on file attachment sizes Add those two things together, and Richie found him …

How to Find the Estimation Cost for a Query

Publié le 23 juin 2020 sur sqlservercentral.com
 

execut The post How to Find the Estimation Cost for a Query appeared first on SQLServerCentral.

SSIS Variable and Parameter Analysis

Publié le 23 juin 2020 sur sqlservercentral.com
 

Introduction If you have an SSIS project that’s matured over time and makes good use of variables and parameters, you’re probably nervous about deleting any of them, even if you think that they are no longer in use. Wouldn’t it be great to be sure and …

 

Heaps in SQL Server: Part 2 Optimizing Reads

Publié le 22 juin 2020 sur simple-talk.com
 

The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps are not necessarily the developer’s favourite child, as they are not very performant, especially when it comes to selecting data (most pe …

 

 

Storage 101: Cloud Storage

Publié le 22 juin 2020 sur simple-talk.com
 

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …

 

 

Connecting to a SQL Server Docker Container Running in macOS

Publié le 22 juin 2020 sur simple-talk.com
 

The series so far: Creating Your First SQL Server Docker Container in macOS Managing SQL Server Docker containers in macOS Connecting to a SQL Server Docker Container Running in macOS In the second part of this article series, you learned about the con …

 

Finally, You Can Buy Brent Ozar Unlimited Swag.

Publié le 22 juin 2020 sur brentozar.com
 

When I’m doing a webcast, the same question always comes up: “Hey, how do I get one of those coffee mugs?” We used to give ’em away during our in-person live training classes, but since I stopped doing those, we needed to come u …

DAX for SQL Folks: Part III – DAX Calculations

Publié le 22 juin 2020 sur sqlservercentral.com
 

Introduction In response to my approach in the popular MDX Guide for SQL Folks series. I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning ex …

Testing SQL Server Stored Procedures and Functions with SQL Data Compare

Publié le 22 juin 2020 sur sqlservercentral.com
 

The post Testing SQL Server Stored Procedures and Functions with SQL Data Compare appeared first on SQLServerCentral.

What is the impact of remote working on estate management?

Publié le 19 juin 2020 sur sqlservercentral.com
 

The post What is the impact of remote working on estate management? appeared first on SQLServerCentral.


Pages :