Find gaps in primary keys across multiple databases
Output table of gaps in a primary key across multiple databases on same, remote and/or linked servers.
2012-02-13 (first published: 2011-08-12)
929 reads
Blogs
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell
As AI continues to evolve, many of us are looking for ways to leverage...
Monday Monitor Tips: Finding the Hostname for Queries
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Forums
Internationalisation
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Size of DB on physical disk doesn't match Disk Usage by Table report
Hi everyone I am looking at the size of my db on disk (ie...
Getting the TEXTSIZE
Comments posted to this topic are about the item Getting the TEXTSIZE
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers