Views in SQL Server

Views in SQL Server. In this article, we briefly covered types of views in SQL Server and gave several examples of user defined views.

Simple SQL Server Functions to Solve Real-World Problems

Simple SQL Server Functions to Solve Real-World Problems. Article demonstrates the creative use of simple SQL Server functions, such as LEN and SUBSTRING (or REPLACE), in real-life scenario.

22 Nifty SQL Index Examples to Warp Speed Your Queries

22 Nifty SQL Index Examples to Warp Speed Your Queries. Indexing the database tables is one of the ways to up your game in tuning queries. How do you do it? Today’s post will give you 22 SQL index examples to run queries in a flash.

Understanding DROP TABLE IF EXISTS SQL Statement

Understanding DROP TABLE IF EXISTS SQL Statement. The DROP TABLE IF EXISTS statement is used to drop existing database objects. When we create a complex stored procedure, we might also make several intermediate tables (physical tables or temp tables) to store and process the data.

SQL Server TRIM, LTRIM, and RTRIM Functions

SQL Server TRIM, LTRIM, and RTRIM Functions. The TRIM function of SQL Server is designed to remove leading and trailing spaces from a character string. A leading space is a space that occurs before the actual string.

SQL UPPER Function and its Usage on the Examples

SQL UPPER Function and its Usage on the Examples. The UPPER function is the SQL Server function that converts character expressions to upper case. It works when either an ad hoc string is passed to the function or a column name is passed.

SQL AVG Function: A Complete Guide

SQL Server also provides the average function – AVG() for calculating Average in T-SQL scripts. Learn SQL AVG Function: A Complete Guide.

Understanding SQL Server ALTER TABLE ADD COLUMN Statement

Understanding SQL Server ALTER TABLE ADD COLUMN Statement. This article clarifies the essence of the SQL Server ALTER TABLE ADD COLUMN statement, its syntax, and various use cases of implementations.

SQL INSERT INTO SELECT: 5 Easy Ways to Handle Duplicates

SQL INSERT INTO SELECT: 5 Easy Ways to Handle Duplicates. You probably know how to insert records into a table using single or multiple VALUES clauses. You also know how to do bulk inserts using SQL INSERT INTO SELECT. But you still clicked the article. Is it about handling duplicates?

Top Answers to 5 Burning Questions on SQL COALESCE Function

In this article, you'll find the answers to the five most-asked questions about SQL COALESCE function in SQL Server. Explore useful examples.

How to Count the Number of Rows in SQL Server Table

There are various ways to count the number of rows in a table of SQL Server. This article will describe them for you to always choose the right way to do it. How to Count the Number of Rows in SQL Server Table.

How to Properly Use the T-SQL IsNumeric Function

Learn how to Properly Use the T-SQL IsNumeric Function. In this article, we'll look at the T-SQL ISNumeric function and how you can use it in your day-to-day SQL scripting tasks.

T-SQL Datetime Data Type

T-SQL Datetime Data Type. The aticle describes datetime and datetime2 data types, their key differences and how to make sure you are entering the correct date when using these data types.

Do You Make These Mistakes When Using SQL CURSOR?

Do You Make These Mistakes When Using SQL CURSOR? The article discusses 4 common mistakes to avoid when using SQL CURSOR to make sure it won’t cause performance issues.

SQL DROP TABLE Statement and Various Use Cases

In this article, you will learn more about SQL DROP TABLE statement syntax and various use cases of using it on practical examples.

MIN and MAX Aggregate Functions in SQL Server

MIN and MAX Aggregate Functions in SQL Server. This article demonstrates the use of the MIN and MAX aggregate functions in SQL Server that return values for a given range stored in a table.

Handling the NULL Values Effectively with the SQL COALESCE Function

Handling the NULL Values Effectively with the SQL COALESCE Function. This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values.

Workplace Encounters: Reclaiming Space from an Oversized Database – {coding}Sight

This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd April 2015 and 23rd April 2015.