Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Find Table in Every Database of SQL Server – Part 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL System Table
Yesterday I wrote about SQL SERVER – Find Table in Every Database of SQL Server. Today we will see another method how we can achieve the same result using Information_Schema view. Refer my previous article here for additional information. CREATE PROCEDURE usp_FindTableNameInAllDatabase @TableName VARCHAR(256) AS DECLARE @DBName VARCHAR(256) DECLARE @varSQL…
Read More

SQLAuthority News – Download Microsoft Office Visio 2007 Professional SQL Server Add-In

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download
Note : Download Microsoft Office Visio 2007 Professional SQL Server Add-In by Microsoft Visio Infrastructure for SQL Servers is a tool which is meant for IT administrators who require constant interactions with the users for the installations of the SQL server in any IT infrastructure. Visio Infrastructure for SQL Servers…
Read More
All Articles executionplanbig-600x400

SQL SERVER – Join Better Performance – LEFT JOIN or NOT IN?

Pinal Dave
SQL Performance
SQL Joins, SQL Scripts, SQL Server

First of all answer this question : Which method of T-SQL is better for performance LEFT JOIN or NOT IN when writing a query? The answer is: It depends! It all depends on what kind of data is and what kind query it is etc. In that case just for fun guess one option LEFT JOIN or NOT IN. If you need to refer the query which demonstrates the mentioned clauses, review following two queries for Join Better Performance.

Read More