Index Locking Strategy

This script returns the index locking strategy informationfor all user tables in a database. It also generates the required TSQL statement to alter locking strategies if required. These statements require CTRL-C and CTRL-V individually into query analyser for execution. Results are best viewed in text only. This TSQL can be wrapped in a stored procedure […]

4 (1)

2002-07-04

1,376 reads

Blogs

SQL Server on Linux Storage Secrets on Microsoft Channel 9

By

I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...

Daily Coping 29 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Server vs Instance. A rant.

By

It’s a SQL Server Instance not a SQL Server. The product is SQL Server....

Read the latest Blogs

Forums

Having sum(amount) = 0 returns negatives as well.

By C-M-A

Hello all, I'm trying to get a list of ID's that have a total...

How to limit SQL Job Success events

By Graham Van der vaart

Hi, We have a monitoring tool that reads Windows Event Log entries for Failure...

SQL Server Agent producing unreproducible error

By Thom A

I've built a Powershell script, which I want to run through SQL Server Agent....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers