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.
2024-03-15
1,557 reads
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 […]
2023-09-18
3,799 reads
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.
2023-04-07
10,828 reads
Learn the basics of the ROUND() function in this article.
2022-12-02
3,034 reads
This article shows how you can query your database files to get metadata about them and use that to get the reads, writes, and other IO statistics.
2022-11-18
9,383 reads
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 […]
2022-10-18 (first published: 2022-09-02)
11,067 reads
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,553 reads
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
6,688 reads
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.
2022-01-19
676 reads
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.
2022-01-19
4,466 reads
By Steve Jones
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin, and it’s a...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I'm trying to use forfiles in an Execute Process Task in my SSIS package...
Hi I want below data to appear like below using query CREATE TABLE [dbo].[Test](...
What is a partial backup for a read-write database?
See possible answers