Part 2 of how to find a table in every database of SQL Server: this stored procedure loops through sys.databases and reads the Information_Schema view.
SQL SERVER – Find Table in Every Database of SQL Server
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.
SQL SERVER – Download FAQ Sheet – SQL Server in One Page
Readers asked for one page listing SQL Server FAQs, so I made a FAQ Sheet in PDF format with the daily used details. Download it and tell me what to add.
SQL SERVER – Query Analyzer Shortcuts – Part 2
Praveen Barath replied to my Query Analyzer Shortcuts post, explaining why SSMS in SQL Server 2005 feels slower and why its features are worth learning.
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.
SQLAuthority News – Authors Personal Bookmarks
I reorganized my personal bookmarks into two lists: SQLAuthority best articles and SQLAuthority favorite articles. Take a look and tell me what you think.
SQLAuthority News – Download Microsoft Office Visio 2007 Professional SQL Server Add-In
Microsoft’s Visio 2007 Professional SQL Server Add-In lets IT admins map SQL Server installs with configuration data, so setup needs less back and forth.
SQL SERVER – Converting Subqueries to Joins
Developers often write subqueries where Joins would do, or the other way around. A short note on converting between the two, with links to my earlier examples.
SQL SERVER – Join Better Performance – LEFT JOIN or NOT IN?
LEFT JOIN or NOT IN: which one gives Join Better Performance? It depends on the data. Compare the two queries and their execution plans on AdventureWorks.