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,018 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,932 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
The Utah Jazz experienced arguably their utmost modern acquire of the year in excess...
No person would create the situation that a eye-catching video game of basketball was...
Chicago Bulls vs. Charlotte HornetsCharlotte, North Carolina; Wednesday, 7:30 p.m. ESTBOTTOM LINE: Charlotte is...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers