Database development

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

How to SHOW or LIST Tables in MySQL

Database development, MySQL, Tables

There are two primary methods to view the tables in MySQL: In this article, we are going to explore them both....
Read More

How to Use a ROUND Function in SQL Server

Database development, Statements

The ROUND function in SQL Server is a powerful tool that allows you to round numeric values to a specific number of decimal places. This...
Read More

SQL AS: Usage, Examples, and How it Can Benefit You Best

Database development, SQL Server, Statements

What is the AS statement in SQL? The AS keyword in SQL is used to create a temporary alias for a...
Read More

How to Get SQL Server Statistics Information Using System Statistical Functions

Database administation, Database development, Database Optimization & Structure, Stored Procedures

Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
Read More

SQL Server RAISERROR Statement with Simple Examples

Database administation, Database development, Stored Procedures, Troubleshooting Issues

The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and...
Read More

Stored Procedure to Delete Duplicate Records in SQL Table

Database development, Stored Procedures, Tables

Sometimes during our run as DBAs, we come up across at least one table that is loaded with...
Read More

What is a Materialized View and Why Should you Use It?

Database development, Views • One Comment

As data volumes continue to increase, more developers look towards materialized views to process queries. This approach has a lot of...
Read More

How to Write Complex Queries in SQL

Database development, Statements

Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a query is not in one table, but in several,...
Read More

SQL Stuff Function

Database development, Statements

The main idea around the SQL Server function called STUFF is concatenating multiple columns into a...
Read More
Close