Microsoft SQL Server Archives

Using Sequences in database systems

A Sequence is a database object capable to generate numbers (i.e. it is a number generator). One of the main[…]

In SQL, The Count function counts the number of values in a set. Such function accepts a parameter, that specifies[…]

To delete a great number of rows from a table may become a pain in the neck. A never ending[…]

It is really common to have columns that stores sequences of numbers in database systems (specially in relational databases). Users[…]

For many people, using noncorrelated subqueries (using In/Not In) seems to be more natural than using Exists/Not Exists and correlated[…]

Joins are one of the most common operators in SQL queries. In this post, we present inner and outer joins[…]

In this post, we continue our series on performance tuning. We present the concepts of logical reads and physical reads,[…]

In a previous post, we present an introduction to database tuning. In this post, we’ll talk about SQL execution plans[…]

Duplicate data can be generated in the database due to design error, software bugs or misuse by end users. Depending[…]

Non-correlated subqueries (where the inner query does not have any column from the outer query tables) are usually implemented using[…]