devxlogo

Data Access And Management

Create Database Primary Keys on the Fly

Since Guids are unique anywhere you find them, they make a good primary key.The trick is to create them where and when you need them using the CoCreateGuidAPI. You can

See Who Is Blocking Your SQL Server

If you have ever monitored any blocking problems in SQL Server, you know that sp_who only shows you the spid (SQL Server’s internal Process ID) that is causing the blocking