sys.tables only searches one database. My quick stored procedure finds a table in every database on the server and returns database, schema and table name.
What Is an Index in SQL Server?
An index in SQL Server took one query from 33,517 reads to 66 on the same table. What clustered and nonclustered really mean, why every index is paid for on the way in, and how to find the ones nobody uses.
CHARINDEX Start Position: Find the Second Delimiter
CHARINDEX start position finds the next delimiter. Guard a missing first match, preserve NULL, and extract empty fields without negative lengths.
SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article
Reader Praveen Barath adds his own query optimization tips to my rules of thumb: tune only working code, write repeated statements identically and more.
SQL SERVER – Optimization Rules of Thumb – Best Practices
My optimization rules of thumb for a slow running query: read the query plan first, turn scans into seeks, fix bookmark lookups with a covering index and more.
Using Synonyms to Simplify Cross-Database Queries
Using synonyms can hide a cross-database object name from callers, but permissions, dependency checks, and deployment still need care.
Drawing a Diagram of an Existing Database
A diagram of an existing database starts with real foreign keys, uses SSMS to reveal relationships, and records the important paths a picture misses.