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

Blogs

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

By

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Read the latest Blogs

Forums

Deleting duplicate records with a CTE

By michael.leach2015

This code is modified from an example I saw.  The purpose is to delete...

Building Your Brand

By Grant Fritchey

Comments posted to this topic are about the item Building Your Brand

A Little Paranoia is Good

By Grant Fritchey

Comments posted to this topic are about the item A Little Paranoia is Good

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers