Database development

The Easy and Practical SQL Server Tutorial for Beginners

Database development

Introduction to Our SQL Server Tutorial for Beginners Hello, budding SQL Server enthusiast!...
Read More

How to Use SQL Server T-SQL Function SUM: 5 Use Cases

Database development, Statements

The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column –...
Read More

SQL Server Resumable Index: Is it good for you?

Database development, Indexes

SQL 2017 introduced the ability to pause and resume index rebuild operations during database maintenance. This feature offers more...
Read More

SQL SELECT DISTINCT: Performance Best Practices

Database development, Statements

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say...
Read More

SQL OR Statement: The Basics

Database development, Statements

Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create,...
Read More

How to Use SQL SUM Function

Database development, Statements

SQL is a powerful and widely-used programming language for data storage, retrieval, and manipulation. One of the most commonly-used...
Read More

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
Close