Technical Article

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

Daily Coping 30 Nov 2022

By

Today’s coping tip is to learn a new skill from a friend or share...

Encrypting Your SQL Data Should be Your Default Option

By

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Power BI Embedded: Using Row-Level Security for Multilingual Reports

By

Making multilingual reports in Power BI requires a lot of different elements. Translations can...

Read the latest Blogs

Forums

How to apply rates in a time column

By pedroccamara

Hello all I have this selected column : convert(TT.horas, Time) AS TimeTT, this column...

Designing Database from a piece of paper

By ciss1

Greetings experts, Hopefully, this is the forum for my question. I am trying to...

Sum up different dates

By pelusch

Hi guys To the table below - I want to sum up the amount...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers