This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Find Table in Every Database of SQL Server - Part 2

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

April 30, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

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.

Read More
SQL SERVER - Find Table in Every Database of SQL Server

SQL SERVER – Find Table in Every Database of SQL Server

April 29, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

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.

Read More
Gouache painting: a long tan leather strap lies straight across a workbench with two brass studs a short gap apart near its middle

CHARINDEX Start Position: Find the Second Delimiter

April 27, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

CHARINDEX start position finds the next delimiter. Guard a missing first match, preserve NULL, and extract empty fields without negative lengths.

Read More
Three blue, sage, and terracotta bowls nested together beside a matching set arranged separately.

SQL SERVER – Converting Subqueries to Joins

April 23, 2008
Pinal Dave
SQL Performance
SQL Joins, SQL Performance, SQL Scripts, SQL Server

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.

Read More
SQL SERVER - Join Better Performance - LEFT JOIN or NOT IN?

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

April 22, 2008
Pinal Dave
SQL Performance
SQL Joins, SQL Scripts, SQL Server

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.

Read More
Gouache painting: seen from above, three furrows lie side by side: one long, one shorter, one long

EOMONTH: Month Ends Are Different From DATEADD Month Clipping

April 21, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

EOMONTH gives me a month-end date when that is the actual reporting requirement. DATEADD moves a date by a month. These operations can agree for one step and disagree on the next.

Read More
SQL SERVER - 2008 - Row Constructors - Load Temp Tables From Stored Procedures

SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures

April 16, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure

Load temp tables from stored procedures with a simple INSERT INTO EXEC instead of a loopback OPENQUERY. Here is the before and after code.

Read More
Previous 1 … 313 314 315 316 317 318 319 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com