Finding Sister Locations to Help Each Other: Answers & DiscussionThe post Finding Sister Locations to Help Each Other: Answers & Discussion appeared first on SQLServerCentral. 15 avril 2024 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
Using ChatGPT for T-SQL Code ReviewsFor this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server […] 9 avril 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
Check Azure SQL DB Space UsedA couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […] 29 mars 2024 dans Sites anglophones étiqueté Administration / Azure / Azure SQL / Azure SQL Database / Database Administration / Database Space / SQL Server / t-sql par sqlservercentral.com
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
Option Recompile is a Magic Turbo Button That Actually Works.I didn’t say that – Guy Glantser did. Guy Glantser is an Israeli SQL Server guru with a […] 12 mars 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
The Last Ticket/Issue I Closed #TSQL2sdayFor this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that […] 13 février 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
Writing SQL Server code with AI using GitHub CopilotIntroduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting […] 12 février 2024 dans Sites anglophones étiqueté AI / Artificial Intelligence (AI) / Copilot / GitHub / t-sql par sqlservercentral.com
Use a Table Variable for Logging Entries that Need to ...Introduction Table variables are special types of local variables that can be used to store data temporarily, similar […] 9 février 2024 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
Deploying Azure SQL Database Using an ARM TemplateProvisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […] 2 février 2024 dans Sites anglophones étiqueté Administration / ARM template / Azure / Azure SQL / Azure SQL Database / Azure SQL Managed Instance / azure sql server / SQL Database / t-sql / TEMPLATE par sqlservercentral.com
Gracefully Handle Errors using TRY CATCH Logic in SQL Server ...The post Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures appeared first on SQLServerCentral. 31 janvier 2024 dans Sites anglophones étiqueté Error Handling / t-sql / TRY..CATCH par sqlservercentral.com
Dijkstra's AlgorithmIntroduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of […] 5 janvier 2024 dans Sites anglophones étiqueté Dijkstra / graphs / minimal path / t-sql par sqlservercentral.com
Searching an Encrypted ColumnWhen encrypting a database column, equality searching can be preserved by using a deterministic encryption algorithm. A deterministic […] 15 décembre 2023 dans Sites anglophones étiqueté Encryption / Security / t-sql par sqlservercentral.com
SQL GROUP BY Alias – An Oracle feature that would ...The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared […] 13 décembre 2023 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
SQL Window Functions Series: LAG() and LEAD()In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […] 11 décembre 2023 dans Sites anglophones étiqueté #sql interview questions / Advanced SQL / Data / Database / Date Calculations / Date computation / DATEDIFF / LAG / LAG function / LEAD / OVER() / Performance / Performance and Tuning / Performance Tuning / Programming Language / SQL / SQL Compare / sql monitor / SQL Performance / SQL Prompt / SQL Script / SQL Server / t-sql / time series / TSQL / Window Functions par sqlservercentral.com
Window Function Basics – PARTITION BYOne of the things that I’ve done over the last year to improve my T-SQL skills is learn […] 8 décembre 2023 dans Sites anglophones étiqueté t-sql / Window Functions par sqlservercentral.com
Time Series Data Mining Example with T-SQL when Adding New ...The post Time Series Data Mining Example with T-SQL when Adding New Data appeared first on SQLServerCentral. 27 novembre 2023 dans Sites anglophones étiqueté Data Mining / t-sql par sqlservercentral.com
Ensuring a Single Row TableSingle row tables in data modeling Single row tables are a fact of our life as as a […] 27 novembre 2023 dans Sites anglophones étiqueté calculated columns / Database Design / Database Design and Implementation / Primary Key / Primary Key (PK) / single row table / SQL Server / t-sql par sqlservercentral.com
Unpivoting Multiple Sets of Columns in SQL Server using CROSS ...The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral. 24 novembre 2023 dans Sites anglophones étiqueté APPLY / cross apply / t-sql / UNPIVOT par sqlservercentral.com
Strategies for queries against bit columnsRecently someone posted a question where they couldn’t quite figure out how to construct a predicate based […] 20 novembre 2023 dans Sites anglophones étiqueté BIT / Homepage / t-sql / T-SQL Programming par simple-talk.com
Efficient Table Migration to a New Schema in T-SQLIntroduction Efficiently migrating tables to a new schema in T-SQL is a common task for database administrators and […] 3 novembre 2023 dans Sites anglophones étiqueté Database Administration / schema / Schemas / t-sql / Table Migration par sqlservercentral.com
Don’t use DISTINCT as a “join-fixer”I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there […] 16 octobre 2023 dans Sites anglophones étiqueté Homepage / t-sql / T-SQL Programming par simple-talk.com
Alternatives To SQL Server 2022 Built-in function GREATESTThe post Alternatives To SQL Server 2022 Built-in function GREATEST appeared first on SQLServerCentral. 9 octobre 2023 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
The Basics of Using GENERATE_SERIES()First, SQL Server 2022 has many interesting new features for both DBAs and database developers. GENERATE_SERIES is one […] 9 octobre 2023 dans Sites anglophones étiqueté GENERATE_SERIES() / t-sql 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
Different Ways to Format Currency Output in SQLThe post Different Ways to Format Currency Output in SQL appeared first on SQLServerCentral. 28 août 2023 dans Sites anglophones étiqueté SQL Server / t-sql par sqlservercentral.com
Working around schema drift in SQL ServerAt Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […] 14 août 2023 dans Sites anglophones étiqueté Homepage / stateofdatabaselandscapesurvey / t-sql / T-SQL Programming par simple-talk.com
Sample Use Case for Using SQLCMD Utility Batch FilesThe post Sample Use Case for Using SQLCMD Utility Batch Files appeared first on SQLServerCentral. 14 juillet 2023 dans Sites anglophones étiqueté DBA tips / DBA Tools / SQL Server / SQL Server Data Tools (SSDT) / t-sql par sqlservercentral.com
FOR XML PATH Changed The Way I Think About T-SQL ...The first time I saw FOR XML PATH being used to generate a comma-delimited list, I think I […] 11 juillet 2023 dans Sites anglophones étiqueté t-sql par brentozar.com
Get the Most Current Row From a Detail TableTask: Update a table with the most current value of a detail table. In this article I’m using […] 10 juillet 2023 dans Sites anglophones étiqueté FIRST_VALUE / LAST_VALUE / Performance / Performance and Tuning / ROW_NUMBER / t-sql / Update par sqlservercentral.com
Starter Metadata T-SQL Query Examples for Databases and TablesThe post Starter Metadata T-SQL Query Examples for Databases and Tables appeared first on SQLServerCentral. 7 juillet 2023 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
Horizontal TreesIntroduction The sp_HorizontalTree procedure introduced here may be used to audit tables with dependent columns. A column is dependent […] 16 juin 2023 dans Sites anglophones étiqueté accounting / audit / dependent columns / t-sql / tree par sqlservercentral.com
Common Table Expression BasicsIntroduction Firstly, we need to understand what is a common table expression. Common table expressions, also abbreviated as […] 19 mai 2023 dans Sites anglophones étiqueté Common Table Expressions (CTE) / t-sql par sqlservercentral.com
REPLACE versus TRANSLATE for SQL Server Text Data ManipulationThe post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral. 19 mai 2023 dans Sites anglophones étiqueté t-sql / tSQLt par sqlservercentral.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
DAX CASE Statement Functionality with IF, SWITCH and SWITCH TrueThe post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral. 3 avril 2023 dans Sites anglophones étiqueté CASE Equivalent / DAX / t-sql / Uncategorized par sqlservercentral.com
Passing parameters to query without TVFsProblem Statement You have a need to extract data from a table or view with 1 or more […] 27 mars 2023 dans Sites anglophones étiqueté t-sql / Table Valued Function (TVF) / Table-Valued Parameter par sqlservercentral.com
ChatGPT in SQL Server – Practical examplesIntroduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL […] 6 mars 2023 dans Sites anglophones étiqueté Artificial Intelligence (AI) / ChatGPT / MS SQL Server / t-sql par sqlservercentral.com
Can You Nest Transactions in SQL Server?To find out, let’s set up a simple status log table: DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE […] 28 février 2023 dans Sites anglophones étiqueté t-sql par brentozar.com
Find 40 Problems in This Stored Procedure.Aaron Bertrand posted a challenge: We’re going to use the AdventureWorks sample database (get your copy here), where […] 24 février 2023 dans Sites anglophones étiqueté t-sql par brentozar.com
3 Ways to Debug T-SQL CodeWriting new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers […] 10 janvier 2023 dans Sites anglophones étiqueté t-sql par brentozar.com
How to Find Missing Rows in a TableWhen someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table […] 5 janvier 2023 dans Sites anglophones étiqueté t-sql par brentozar.com
Should You Use SQL Server 2022’s STRING_SPLIT?SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to […] 21 décembre 2022 dans Sites anglophones étiqueté t-sql par brentozar.com
Should You Use SQL Server 2022’s DATETRUNC?SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example: SELECT DATETRUNC(year, […] 20 décembre 2022 dans Sites anglophones étiqueté t-sql par brentozar.com
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
Slow “Having” Query? Try Pre-Filtering.I was helping a client with a query, and I’m going to rework the example to use the […] 29 novembre 2022 dans Sites anglophones étiqueté t-sql par brentozar.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
SQL Cheat Sheet for Basic T-SQL CommandsThe post SQL Cheat Sheet for Basic T-SQL Commands appeared first on SQLServerCentral. 31 octobre 2022 dans Sites anglophones étiqueté t-sql / Uncategorized par sqlservercentral.com
SQL Server Engineering Using Free ToolsYou can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE […] 28 octobre 2022 dans Sites anglophones étiqueté Free tools / Performance / t-sql par sqlservercentral.com
Data Lineage Scripts for Microsoft SQL Server and Azure SQLData Lineage is a process of understanding data’s lifecycle, from origin to destination. It tracks where data originates, […] 19 octobre 2022 dans Sites anglophones étiqueté Azure SQL Database / Azure Synapse Analytics / data governance / data lineage / MS SQL Server / t-sql / Uncategorized par sqlservercentral.com
#tsql2sday: Start Your Dynamic SQL with a Comment.When you write dynamic SQL, start like this: CREATE OR ALTER PROC dbo.MyProc AS BEGIN DECLARE @StringToExecute NVARCHAR(4000); […] 11 octobre 2022 dans Sites anglophones étiqueté t-sql par brentozar.com