The Unique Identifier datatype in SQL Server has tremendous potential to solve many of the issues one finds with Identity fields, other primary keys, etc. However it also has some drawbacks and limitations. Author Sharad Nandwani looks at some of the pros and cons of this datatype.
2004-06-24
14,019 reads
This short article looks at some mistakes developers should avoid when they also have the task of designing the database, database objects, or TSQL used to access it.
2003-12-16
7,935 reads
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
The thread for the league in 2025. Players from last year have priority.
Forgot I posted a similar issue back in 2020, String or Binary Truncation Error...
If I have Read replica (in Azure SQL MI), can it be used as...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers