Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
3,608 reads
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
3,608 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)
10,803 reads
In this article we cover different ways to convert a SQL Server numeric value into a string value.
2022-07-08
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,257 reads
In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.
2022-03-07
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
5,626 reads
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
2022-01-14
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
5,234 reads
Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
2021-12-31
BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of BETWEEN and also could be implemented.
2021-12-15
By Steve Jones
There is a nice article at Harness.io on their use of feature flags and...
By James Serra
There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...
I have this query, which is gives result I want (may be not, i...
Hello, I have long-term task, which came one year ago, and just now I...
Comments posted to this topic are about the item LOGON Trigger Count
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers