Database development

Stored Procedure to Get Database Tables Information

Database development, Stored Procedures

As SQL Server DBAs, we always take care of one of the most important things for the business, the...
Read More

How to Use REPLACE in SQL

Database development, Statements

When querying data with SQL, the need to manipulate string-based results is very common. There are many options across the major relational...
Read More

Stored Procedure to Get Indexes Status in All Databases

Database development, Stored Procedures

As SQL Server DBAs, we’ve heard that index structures can dramatically improve the performance of any given query (or set of queries)....
Read More

SQL BETWEEN-Smart Tips to Scan for a Range of Values

Database development, Statements

SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be...
Read More

SQL ORDER BY: The 5 Do’s and Don’ts to Sort Data Like a Pro

Database development, Statements

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...
Read More

Overview of T-SQL PRINT Statement

Database development, Statements

PRINT statements are crucial in any programming language. They will allow the routine or program that you are running to dump some type of...
Read More

SQL GROUP BY- 3 Easy Tips to Group Results Like a Pro

Database development, SQL Server, Statements

Grouping is an important feature that helps organize and arrange data. There are a lot of ways to...
Read More

How to Comment MySQL Code: Best Practices

Database development, Statements

Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when...
Read More

WhoIsActive Runner

Database development, Stored Procedures

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...
Read More

Guide for CTE in SQL Server

Database development, Tables

The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can...
Read More
Close