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,036 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,946 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah, Kota...
Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers