2005-12-30 (first published: 2005-12-09)
121 reads
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 […]
2002-07-04
1,376 reads
DBCC REINDEX all user tables
This script reindexes all user and system indexes in the database using the original fillfactor allocated to that index. It can be executed from the Query Analyzer as stand alone SQL or you could wrap it in a stored procedure.
2002-01-11
7,797 reads
Blogs
Daily Coping 30 Nov 2022
By Steve Jones
Today’s coping tip is to learn a new skill from a friend or share...
Encrypting Your SQL Data Should be Your Default Option
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 DataOnWheels
Making multilingual reports in Power BI requires a lot of different elements. Translations can...
Forums
How to apply rates in a time column
Hello all I have this selected column : convert(TT.horas, Time) AS TimeTT, this column...
Designing Database from a piece of paper
Greetings experts, Hopefully, this is the forum for my question. I am trying to...
Ask SSC