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. 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. 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. 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. 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. 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 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. 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. 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?
In this article, you'll find the answers to the five most-asked questions about SQL COALESCE function in SQL Server. Explore useful examples.
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.
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. 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? The article discusses 4 common mistakes to avoid when using SQL CURSOR to make sure it won’t cause performance issues.
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. 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. This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values.
This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd April 2015 and 23rd April 2015.