The ins and outs of joining tables in SQL Server
Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server.
2022-05-13
Learn SQL
Ordering a result set in SQL Server
To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY.
2022-04-08
When to use CHAR, VARCHAR, or VARCHAR(MAX)
It’s important to choose the right datatypes when designing a database. Greg Larsen explains the differences between CHAR, VARCHAR and VARCHAR(MAX).
2022-02-14
How to replace an identity column with a sequence number
SQL Server provides two ways to include an incrementing number in a table. Greg Larsen explains how to replace an identity column with a sequence number.
2022-01-24
How to return multiple sequence numbers with sp_sequence_get_range
Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.
2022-01-05
Using SQL Server sequence objects
SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.
2021-12-06
Introduction to SQL Server sequence objects
SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.
2021-11-17
Working with SQL Server identity columns
SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.
2021-10-22
SQL Server identity column
The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works.
2021-09-13
SQL Server High Availability and Disaster Recovery Plan
Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.
2021-08-06
Blogs
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
VMware & SQL Server 823-824 alerts
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
Forums
SQL Query Question
Hello everyone, Thank you for looking into my question. I have a dataset like...
"Frankenrows"
I'm not sure if that's the correct term for what we're seeing here, but...
Ask SSC