My book “Learn T-SQL from Scratch” is launched
A lot of my colleagues and people in my network reached out to me to train them on the SQL Server and T-SQL. They think that my style of...
2021-11-23
15 reads
SQL Server Carpenter
Script to create copies of the existing object
Many a time we need copies of an object but with different names. I also got a requirement to process the files in parallel using SSIS. We had already...
2021-09-17 (first published: 2021-09-09)
559 reads
Divide the rows of a column in equals batches in grid format
I published an article Divide the rows in equals batches few days ago. One of my reader requested me to help him with a requirement to divide a column’s...
2021-09-13 (first published: 2021-08-28)
515 reads
Divide the rows in equals batches
Here is the simple and practical use case of NTILE function. We’ve used it to divide the rows of sys.columns into N batches. N is the batch size. We’ve...
2021-08-25 (first published: 2021-08-15)
2,133 reads
Get the month end dates of last N years
Here is a simple T-SQL script that may come handy if you need the month end dates of last N years. N is the number of years. The output...
2021-09-03 (first published: 2021-08-13)
350 reads
Get the month end dates of last N months
Here is a simple T-SQL script that may come handy if you need the month end dates of last N months. N is the number of months. The output...
2021-08-13
1,145 reads
SSIS Logging – Linking sysssislog with custom log
I was working on an ETL solution, which was expected to run for hours. It has become extremely important to track the errors properly, so as to debug the...
2021-07-05 (first published: 2021-06-21)
465 reads
Query to find Nonclustered Index clashing with Clustered Index
It’s being quite a long time when I made the last post. Actually, I was lacking a topic that should trigger me to write. Finally, I got one when...
2021-05-12 (first published: 2021-04-28)
943 reads
Lesser-known facts of Explicit Transactions
Transactions are of various kinds in SQL Server such as Autocommit, Implicit, Explicit and Batch-scoped. I personally found this article quite helpful if you wish to understand Implicit Transactions....
2021-03-22 (first published: 2021-03-16)
217 reads
Behavior of numeric data types with ”
As we all know, there are various numeric data types, such as TINYINT, INT, SMALLINT, BIGINT, NUMERIC, DECIMAL, SMALLMONEY, MONEY and FLOAT. I was working on a SSIS package,...
2021-03-10 (first published: 2021-03-07)
413 reads
Blogs
SQL Server 2025 GAs Today
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
The Roundup for T-SQL Tuesday #192
By Steve Jones
Last week I asked you to write about SQL Server 2025 and what things...
Forums
The case for "Understanding our business" training
Comments posted to this topic are about the item The case for "Understanding our...
Specifying the Collation
Comments posted to this topic are about the item Specifying the Collation
SQL Server 2025 has arrived!
Comments posted to this topic are about the item SQL Server 2025 has arrived!
Question of the Day
Specifying the Collation
I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:
DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'
SELECT p.PersonType,
p.Title,
p.LastName,
c.CustomerID,
c.AccountNumber
FROM Person.Person AS p
INNER JOIN Sales.Customer AS c
ON c.PersonID = p.BusinessEntityID
COLLATE @c
Will this solve my problem? See possible answers