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,590 reads
T-SQL
Manage Your Business Rules in T-SQL Query
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,786 reads
Different ways to Convert a SQL INT Value into a String Value
In this article we cover different ways to convert a SQL Server numeric value into a string value.
2022-07-08
Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,230 reads
Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data
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
SQL Server Monitoring Using Free Tools
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
5,554 reads
Quantifier predicates
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
Performance Tuning Using Free Tools, Part 2
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
5,213 reads
How to Create a FOR Loop in SQL Server
Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
2021-12-31
BETWEEN the two of us
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
Blogs
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
A New Word: mcfeely
By Steve Jones
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are...
Forums
How to install mysql-connector-python-8.4.0.zip it does not have setup.py
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
when primary is down and not accessible failover not occured then how to recover
HI All, can any one reply on this when primary is down and not...
The On-Call Load
Comments posted to this topic are about the item The On-Call Load
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers