Sites anglophones


Can You Get Parameter Sniffing on Updates and Deletes?

Publié le 28 janvier 2021 sur brentozar.com
 

Sure you can – parameter sniffing is everywhere. Anytime that you have one piece of code that needs to handle a varying number of rows, you’re probably gonna have to worry about parameter sniffing. I’ll start with any Stack Overflow d …

Finding Inactive SQL Server Databases

Publié le 28 janvier 2021 sur sqlservercentral.com
 

The post Finding Inactive SQL Server Databases appeared first on SQLServerCentral.

Building SQL Memorial – Automating Updates

Publié le 28 janvier 2021 sur sqlservercentral.com
 

In my last article, I wrote about the SQL Memorial structure for publishing information on the Internet for others to view. I had chosen Jekyll as a way of taking information in files and publishing it as a good looking website. However, I don’t want t …

Power BI Theme Generator New Methods and Customizations

Publié le 28 janvier 2021 sur sqlservercentral.com
 

The post Power BI Theme Generator New Methods and Customizations appeared first on SQLServerCentral.

“But Surely NOLOCK Is Okay If No One’s Changing Data, Right?”

Publié le 27 janvier 2021 sur brentozar.com
 

Some of y’all, bless your hearts, are really, really, really in love with NOLOCK. I’ve shown you how you get incorrect results when someone’s updating the rows, and I’ve shown how you get wrong-o results when someone’s upd …

Building SQL Memorial – Getting Started

Publié le 27 janvier 2021 sur sqlservercentral.com
 

Introduction One of the projects I’ve been wanting to tackle for some time is putting up a memorial for those people that our community has lost. I talked about it when Dwain Camps passed, and I kicked myself for not having something available when Tom …

Mastering TempDB: The basics

Publié le 26 janvier 2021 sur simple-talk.com
 

I regularly deliver a presentation called “Mastering TempDB”. I wrote it based on what I wish I knew about TempDB “growing up” in my career as a SQL Server DBA. It really is a breakdown of what TempDB is, how it is used, what pr …

Free Webcast: Help! My SQL Server Maintenance is Taking Too Long!

Publié le 26 janvier 2021 sur brentozar.com
 

“Time for a smoke break.” You manage growing SQL Server databases with shrinking nightly maintenance windows. You just don’t have enough time left each night to do the necessary backups, corruption checking, index maintenance, and dat …

Is Tempdb Causing a Bottleneck?

Publié le 26 janvier 2021 sur sqlservercentral.com
 

The post Is Tempdb Causing a Bottleneck? appeared first on SQLServerCentral.

Getting started with the SQL MERGE statement

Publié le 26 janvier 2021 sur sqlservercentral.com
 

This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is perfor …

Create SQL Server Graphics with ggplot2 and R Services

Publié le 26 janvier 2021 sur sqlservercentral.com
 

The post Create SQL Server Graphics with ggplot2 and R Services appeared first on SQLServerCentral.

SQL Server triggers: The good and the scary

Publié le 25 janvier 2021 sur simple-talk.com
 

SQL Server triggers are a subject of both functionality and controversy on any database platform. They can provide immense utility at a low cost, but are often misused by developers, DBAs, and architects alike, resulting in performance bottlenecks or m …

Power Query or SQL Server? Which, when and why

Publié le 25 janvier 2021 sur sqlservercentral.com
 

When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor nec …

What SQL Server Feature Do You Wish Would Go Away?

Publié le 22 janvier 2021 sur brentozar.com
 

I asked a two-part question on Twitter: if you could only remove one feature from SQL, why would it be cursors? If you could only remove one feature from SQL, why would it be cursors? — Brent Ozar (@BrentO) January 20, 2021 The responses were gre …

Automating SQL Compare Snapshots using SQL Snapper

Publié le 22 janvier 2021 sur sqlservercentral.com
 

The post Automating SQL Compare Snapshots using SQL Snapper appeared first on SQLServerCentral.


Pages :