Additional Articles


Technical Article

Transaction locking and row versioning guide

In any database, mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users that access the data increases, it becomes important to have applications that use transactions efficiently. This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.

You rated this post out of 5. Change rating

2022-10-05

External Article

Redgate Summit: The Database DevOps Transformation

Digital transformation and data modernization are frequently cited as high-value strategic projects that are crucial to achieving competitive advantage. At the same time, delivery of code in agile and predictable ways has led to many businesses adopting DevOps practices. Throughout this event we will explore how Database DevOps can be the function that accelerates transformation projects.

Join us On October 6th as we invite experts to share their insider tips and tricks.

2022-09-28

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

Calling Invoke-Sqlcmd from powershell and passing an object containing a '-'

By axm1955@yahoo.com

Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...

SSMS V20 encryption  vs  SQL Server SSL Encryption

By tonytiger5812

I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...

Enable a Disabled Index

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Enable a Disabled Index

Visit the forum

Question of the Day

Enable a Disabled Index

I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?

See possible answers