Generate index on foreign key columns
Script find all foreign key without index in database and create new one for them.
2012-03-29 (first published: 2008-01-25)
3,089 reads
Blogs
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
SQL Server on Linux Storage Secrets on Microsoft Channel 9
By kleegeek
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...
Daily Coping 29 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Having sum(amount) = 0 returns negatives as well.
Hello all, I'm trying to get a list of ID's that have a total...
How to limit SQL Job Success events
Hi, We have a monitoring tool that reads Windows Event Log entries for Failure...
SQL Server Agent producing unreproducible error
I've built a Powershell script, which I want to run through SQL Server Agent....
Ask SSC