Se connecter

Recherches récentes

Aucune recherche récente

Options de recherche

Disponible uniquement lorsque vous êtes connecté.
framapiaf.org est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Un service Mastodon fourni par l'association d’éducation populaire Framasoft.

Administré par :

Statistiques du serveur :

1,4K
comptes actifs

framapiaf.org: À proposÉtatAnnuaire des profilsPolitique de confidentialité

Mastodon: À proposTélécharger l’applicationRaccourcis clavierVoir le code sourcev4.3.7

#sqlserver

5 messages5 participants2 messages aujourd’hui
Public
zartom

Reverse Substrings in SQL Server: Four Efficient Methods
Master Reverse SQL Substrings in SQL Server! Learn efficient methods to reverse substring order, transforming "apple-banana-cherry" into "cherry-banana-apple". Explore modern techniques using STRING_SPLIT & STRING_AGG for optimal performance. #SQLServer #stringmanipulation #ReverseSubstring #SQLtips #programming #database
tech-champion.com/database/sql
...

Public
Alvin Ashcraft

Azure & DevOps Podcast Episode 345 - .NET Aspire and Databases with Jerry Nixon and host Jeffrey Palermo. buff.ly/Bn4lTiN #podcast #devcommunity #sqlserver #database #aspire #dotnet #dotnetaspire #cloudnative

Azure & DevOps Podcast: .NET A...

buff.lyAzure & DevOps Podcast: .NET Aspire and Databases with Jerry Nixon - Episode 345Jerry Nixon is a Principal Program Manager on the SQL Server team focused on the Data API builder. He’s also a fanatic for #CSharp, #StarTrek, and Etymology. He also serves as a professor at Colorado Christian University.   Topics of Discussion: [3:34] Why Jerry describes his life as a pearl necklace. [5:15] Jerry recommends the book Never Eat Alone and the importance of community. [6:01] How engineers and parenting are aligned. [7:02] Jerry reflects on Microsoft’s history of evangelism, the rise of “opinionated” frameworks, and how .NET Aspire revives a form of proven prescriptive guidance. [9:35] Prescriptive guidance. [12:03] The inevitable evolution of .NET Aspire and how it simplifies container-based development by handling orchestration behind the scenes. [16:56] Paying more attention and awareness to the developer community. [18:30] How GraphQL fits into the Data API Builder experience, giving developers flexibility without needing to write complex backends. [21:40] Jerry talks about community feedback on Data API Builder and how real-world use cases help prioritize features and fix gaps in tooling. [31:02] Jerry’s perspective on building container-based solutions. [32:15] Data API Builder’s community involvement and upcoming features. [36:15] Docker Desktop. [38:58] The architectural concept of Data API Builder. [44:42] C# coding conventions at Microsoft and the friendly battles over things like naming, underscores, and formatting styles across internal teams.   Mentioned in this Episode: — New Video Podcast! Email us at . (Sponsor) , by Jeffrey Palermo   Want to Learn More? Visit for show notes and additional episodes.
Public
Alvin Ashcraft 🐿️

Azure & DevOps Podcast Episode 345 - .NET Aspire and Databases with Jerry Nixon and host Jeffrey Palermo.

feed.azuredevops.show/net-aspi

feed.azuredevops.showAzure & DevOps Podcast: .NET Aspire and Databases with Jerry Nixon - Episode 345Jerry Nixon is a Principal Program Manager on the SQL Server team focused on the Data API builder. He’s also a fanatic for #CSharp, #StarTrek, and Etymology. He also serves as a professor at Colorado Christian University.   Topics of Discussion: [3:34] Why Jerry describes his life as a pearl necklace. [5:15] Jerry recommends the book Never Eat Alone and the importance of community. [6:01] How engineers and parenting are aligned. [7:02] Jerry reflects on Microsoft’s history of evangelism, the rise of “opinionated” frameworks, and how .NET Aspire revives a form of proven prescriptive guidance. [9:35] Prescriptive guidance. [12:03] The inevitable evolution of .NET Aspire and how it simplifies container-based development by handling orchestration behind the scenes. [16:56] Paying more attention and awareness to the developer community. [18:30] How GraphQL fits into the Data API Builder experience, giving developers flexibility without needing to write complex backends. [21:40] Jerry talks about community feedback on Data API Builder and how real-world use cases help prioritize features and fix gaps in tooling. [31:02] Jerry’s perspective on building container-based solutions. [32:15] Data API Builder’s community involvement and upcoming features. [36:15] Docker Desktop. [38:58] The architectural concept of Data API Builder. [44:42] C# coding conventions at Microsoft and the friendly battles over things like naming, underscores, and formatting styles across internal teams.   Mentioned in this Episode: — New Video Podcast! Email us at . (Sponsor) , by Jeffrey Palermo   Want to Learn More? Visit for show notes and additional episodes.
#podcast#devcommunity#sqlserver
Public
Ænðr E. Feldstraw

Yo, #sqlserver tuners and optimizers, I have a question: under what circumstances would a #queryplan prefer a scan of a clustered index rather than a seek of a non-clustered index with the same predicate and output fields?

I've been pouring over query plans lately, trying to reduce pressure of processes in an environment that sees thousands of processes running, with hundreds at the same time, contending for data access, CPU time, and file locks.

ExplorerFlux en direct
À propos