Stored Procedure to Get Database Tables Information
As SQL Server DBAs, we always take care of one of the most important things for the business, the...
How to Use REPLACE in SQL
When querying data with SQL, the need to manipulate string-based results is very common. There are many options across the major relational...
Stored Procedure to Get Indexes Status in All Databases
As SQL Server DBAs, we’ve heard that index structures can dramatically improve the performance of any given query (or set of queries)....
SQL BETWEEN-Smart Tips to Scan for a Range of Values
SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be...
SQL ORDER BY: The 5 Do’s and Don’ts to Sort Data Like a Pro
Ugly. That’s what unsorted data looks like. We make data easy for the eyes by sorting them. And that’s what SQL ORDER BY is for. Use...
Overview of T-SQL PRINT Statement
PRINT statements are crucial in any programming language. They will allow the routine or program that you are running to dump some type of...
SQL GROUP BY- 3 Easy Tips to Group Results Like a Pro
Grouping is an important feature that helps organize and arrange data. There are a lot of ways to...
How to Comment MySQL Code: Best Practices
Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when...
WhoIsActive Runner
Nowadays, within the SQL Server DBA community, it is extremely likely that we use, or at the very least have heard of, the famous stored...
Guide for CTE in SQL Server
The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can...