Transact-SQL

SQLServerCentral Article

The difference between BIN2 and Case-Sensitive collations in SQL

  • Article

Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.

5 (2)

You rated this post out of 5. Change rating

2024-03-15

1,638 reads

SQLServerCentral Article

GENERATE_SERIES() Breaks Minimal Logging

  • Article

tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]

5 (9)

You rated this post out of 5. Change rating

2023-09-18

3,840 reads

SQLServerCentral Article

Performance Tuning with SQLFacts Tools

  • Article

The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary costs more to host in the cloud and affects the bottom line for your organization.

5 (3)

You rated this post out of 5. Change rating

2023-04-07

10,892 reads

SQLServerCentral Article

Manage Your Business Rules in T-SQL Query

  • Article

Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]

4 (1)

You rated this post out of 5. Change rating

2022-10-18 (first published: )

11,118 reads

SQLServerCentral Article

Playing popular game of Wordle using T-SQL

  • Article

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

You rated this post out of 5. Change rating

2022-01-19

694 reads

Blogs

Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A…

By

Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure...

Cyber Scams and Operation Shamrock

By

Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...

The Book of Redgate: Ingeniously Simple

By

Redgate has been known for many useful tools that are easy to use. We’ve...

Read the latest Blogs

Forums

Shorten the Debate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Shorten the Debate

Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore

By mehul.bhuva@gmail.com

Comments posted to this topic are about the item Azure SQL Performance Tuning: Mastering...

Adding Lots of Dates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Lots of Dates

Visit the forum

Question of the Day

Adding Lots of Dates

The second parameter for the EOMONTH() function is an integer. In June 2025, if I run this code, what is returned?

DECLARE @d DATE = GETDATE()
SELECT EOMONTH(@d, 95695)

See possible answers