The difference between BIN2 and Case-Sensitive collations in SQLA common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally […] 15 mars 2024 dans Sites anglophones étiqueté collation / t-sql / Transact SQL / TSQL / Unicode par sqlservercentral.com
GENERATE_SERIES() Breaks Minimal Loggingtl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […] 18 septembre 2023 dans Sites anglophones étiqueté bulk logged / Data Generation / Database Performance / GENERATE_SERIES() / Jeff Moden / Minimal Logging / software testing / t-sql / T-SQL Programming / Test Data / Transact SQL par sqlservercentral.com
One use case for NOT using schema prefixesI’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. […] 20 avril 2023 dans Sites anglophones étiqueté Blogs / Transact SQL par simple-talk.com
Performance Tuning with SQLFacts ToolsThe need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved […] 7 avril 2023 dans Sites anglophones étiqueté Index Tuning / indexes / parallelism / Performance Tuning / t-sql / Transact SQL par sqlservercentral.com
GENERATE_SERIES: My new go-to to build setsI have come across a lot of use cases for manufacturing rows on the fly, aside from […] 31 mars 2023 dans Sites anglophones étiqueté Homepage / SQL Server 2022 / T-SQL Programming / Transact SQL par simple-talk.com
Find 40 Problems in this SQL Server Stored ProcedureI’ve been at this for a while now, and have a very particular set of rules and […] 23 février 2023 dans Sites anglophones étiqueté Homepage / T-SQL Programming / Transact SQL par simple-talk.com
Petit guide de Transact SQL – Partie 1Des types de données aux tables temporelles… Ce petit guide est constituée de 4 parties qui vont être […] 9 février 2023 dans Sites francophones étiqueté auto-incréments / clonage d'une base / CREATE OR ALTER / historisation des données / identity / instantané de bases de données / Sécurité au niveau ligne / sequence / SQL Server / tables temporaires / tables temporelles / Transact SQL / type de données / Uncategorized / variables / vues indexées par mssqlserver.fr
Getting started with ROUND() and Its Use CasesIn this article, I will explore one of the SQL Server mathematical functions, ROUND. The T-SQL ROUND() function […] 2 décembre 2022 dans Sites anglophones étiqueté t-sql / Transact SQL par sqlservercentral.com
How to get IO statistics of SQL Server database filesSQL Server is a resource-intensive database system that requires adequate CPU and memory capacity to run transactions with […] 18 novembre 2022 dans Sites anglophones étiqueté DMV / t-sql / Transact SQL par sqlservercentral.com
Generating Repeatable Sets Of Test RowsIn order to test graph structures, I needed a large set of random data. In some ways, […] 30 septembre 2022 dans Sites anglophones étiqueté Blogs / Generating Data / Randomness / SQL Server / t-sql / Transact SQL par simple-talk.com
Manage Your Business Rules in T-SQL QueryMotivation At some point in the carrier, we have come across the problem of hard-coded values in SELECT […] 2 septembre 2022 dans Sites anglophones étiqueté Business Rules / Framework / Parameters / t-sql / Transact SQL par sqlservercentral.com
Working with T-SQL function AVG ()This article will explain SQL Server average function, AVG(), and its use cases. Many times, we need to […] 1 juillet 2022 dans Sites anglophones étiqueté aggregate function / t-sql / Transact SQL par sqlservercentral.com
SQL Server Monitoring Using Free ToolsDo you sometimes wonder how the pieces of your SQL Server systems are doing over time? Do you […] 28 janvier 2022 dans Sites anglophones étiqueté Database / Database Administration / database monitoring / Databases / monitoring / SQL Server / sql server agent / t-sql / Transact SQL / TSQL / Uncategorized par sqlservercentral.com
Playing popular game of Wordle using T-SQLA current frenzy surrounding the game of Wordle has swept the community. I have been playing this game […] 19 janvier 2022 dans Sites anglophones étiqueté games / stored procedures / t-sql / T-SQL Challenges / Transact SQL par sqlservercentral.com
Performance Tuning Using Free Tools, Part 2Does the cost of running SQL Server often surprise you? The cost may come from buying on-premises hardware […] 14 janvier 2022 dans Sites anglophones étiqueté Database Administration / Performance Tuning / query optimization / SQL Query / SQL Server / t-sql / Tools for development / Transact SQL / TSQL par sqlservercentral.com