Database administrator with 14+ years of hands-on experience in database management and database design.

static void Main(string[] args) { var script = @" ALTER TABLE table1 ADD CONSTRAINT PK_Constrain PRIMARY KEY CLUSTERED (a) WITH (ONLINE = ON, MAXDOP = 2, RESUMABLE = ON, MAX_DURATION = 240); "; var ...

The question of whether to modify the Declaration of Trust between the city of Tahlequah and Tahlequah Public Works Authority was considered during the monthly TPWA meeting Dec. 20, but action during ...

Join the event trusted by enterprise leaders for nearly two decades. VB Transform brings together the people building real enterprise AI strategy. Learn more AI has transformed the way companies work ...

The percentage of free space that is specified by `FILLFACTOR` is applied to the intermediate-level pages of the index. - OFF or *fillfactor* isn't specified The intermediate-level pages are filled to ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

Multiple Detail Records - 4 in this case. (linked to the header record) Multiple Inventory Records - again, 4 - (each detail record points to one specific inventory record, but the inventory may be ...

I'm currently working on a particular table that is about 7 million records. Size on disk is about 2GB. It so happens that the way this is indexed, The size of the index is about double the size of ...