Sites anglophones


[Video] Office Hours: Holiday Speed Round

Publié le 29 décembre 2022 sur brentozar.com
 

Beep beep! Here’s a speed round of Office Hours where I rip through a dozen questions in under ten minutes. Want to see your own questions answered? Post ’em and upvote the ones you like at https://pollgab.com/room/brento. 00:00 Start 00:22 …

SQL ConstantCare® Population Report: Winter 2022

Publié le 28 décembre 2022 sur brentozar.com
 

Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the winter 2022 version of our SQL Const …

Executing Optional Code in Flyway Callbacks

Publié le 28 décembre 2022 sur sqlservercentral.com
 

The post Executing Optional Code in Flyway Callbacks appeared first on SQLServerCentral.

[Video] Office Hours: Ham Pillow Edition

Publié le 27 décembre 2022 sur brentozar.com
 

Y’all post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss, and then I artfully dodge giving you answers. At least, that’s how it feels sometimes, hahaha: Here’s what we discussed in …

The Lock Escalation Threshold – Part 3

Publié le 26 décembre 2022 sur sqlservercentral.com
 

The post The Lock Escalation Threshold – Part 3 appeared first on SQLServerCentral.

Building a SQL Computational Framework for MACD Indicators

Publié le 26 décembre 2022 sur sqlservercentral.com
 

The post Building a SQL Computational Framework for MACD Indicators appeared first on SQLServerCentral.

Flyway Desktop in Database Development Work: An Overview

Publié le 23 décembre 2022 sur sqlservercentral.com
 

The post Flyway Desktop in Database Development Work: An Overview appeared first on SQLServerCentral.

Heapq Module in Python: Using Heaps and Priority Queues

Publié le 23 décembre 2022 sur sqlservercentral.com
 

The post Heapq Module in Python: Using Heaps and Priority Queues appeared first on SQLServerCentral.

Should You Use SQL Server 2022’s GREATEST and LEAST?

Publié le 22 décembre 2022 sur brentozar.com
 

If you’ve been following along with this week’s posts on DATETRUNC and STRING_SPLIT, you’re probably going to think the answer is no, but bear with me. It’s Christmas week, right? The news can’t all be bad. GREATEST and LE …

Should You Use SQL Server 2022’s STRING_SPLIT?

Publié le 21 décembre 2022 sur brentozar.com
 

SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that’s the only thing they improved – there’s still a critical performance problem with it. Let’s ta …

Maintaining a Utilities Schema in a Flyway Project

Publié le 21 décembre 2022 sur sqlservercentral.com
 

The post Maintaining a Utilities Schema in a Flyway Project appeared first on SQLServerCentral.

The Mentoring Class of 2023

Publié le 20 décembre 2022 sur sqlskills.com - paul randall
 

(Meeps, one of our seven cats, helping with the selection process…) Since my first round of community mentoring back in 2015, when I mentored 54 people for six months, I’ve been asked periodically whether I’d do it again. My answer was always som …

Should You Use SQL Server 2022’s DATETRUNC?

Publié le 20 décembre 2022 sur brentozar.com
 

SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example:SELECT DATETRUNC(year, ‘2017-06-01’); Truncates everything in that date other than the year, so it returns just 2017-01-01 00:00: You might ask, …

 

SQL Server 2022: How Auto-Drop Statistics Work

Publié le 19 décembre 2022 sur simple-talk.com
 

Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table structure is not blocked by the presence of the statistic. An auto-created statistics is also dropped automatic …

 

 

Resolving to Write in the New Year

Publié le 19 décembre 2022 sur simple-talk.com
 

It is almost New Year’s Day, that time when the optimistic at heart start thinking about making changes in their life on that magical day that ends the year. After the glorious gluttony-fest that has only recently ended in many cultures, it does …

 


Pages :