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,369 reads

Blogs

Getting Started with SQL Prompt 10

By

This week we released SQL Prompt 10, which is an exciting milestone for us....

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting

By

Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Learn from the Troubles of Others

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learn from the Troubles of...

Collections

By bsahlean 61286

Comments posted to this topic are about the item Collections

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers