Getting started with ROUND() and Its Use Cases
Learn the basics of the ROUND() function in this article.
2022-12-02
2,665 reads
Learn the basics of the ROUND() function in this article.
2022-12-02
2,665 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
5,180 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)
9,927 reads
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
1,747 reads
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
3,014 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
404 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,057 reads
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
4,482 reads
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
1,450 reads
There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
2019-12-10
20,208 reads
I am very excited and lucky to be speaking once again at SQLBits along...
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Monitoring for Problems The encryption of your existing data occurs as a background process...
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?
Comments posted to this topic are about the item Fear of "What If"