Difference Between DELETE and TRUNCATE Table in SQL Server
Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE...
Do You Make These Mistakes When Using SQL CURSOR?
For some people, it’s the wrong question. SQL CURSOR IS the mistake. The devil is in the details! You can read all sorts of...
Virtual Columns and Functional Indexes
Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very...
Understanding SQL Server ALTER TABLE ADD COLUMN Statement
This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this...
Using INNER JOIN to Combine SQL Server Tables and Display Them in ASP.NET Webforms
This article describes the ways of using an INNER JOIN to combine results from two tables in the SQL Server database and display them in an...
SQL DROP TABLE Statement and Various Use Cases
The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and its data and indexes associated with it....
How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?
Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL...
Learn Database Design with SQL Server Management Studio (SSMS) – Part 2
It is the second part of the series focused on the SQL Server Management Studio usage. You will learn the database design core concepts and...
Synthetic Data Generation
Introduction Sooner or later, any information system gets a database, often – more than one. With time, that database gathers very much...
Mastering the Use of Stoplists With SQL Server Full-Text Search (FTS)
Creating and managing stoplists serves as one of the main components responsible for improving the...