• Interests: Sailing, boats, wooden boats, wooden boats with sails - oh, and sailing

Technical Article

Get all Tables and Columns for each Database

This script will get the name of each database from master..sysdatabases, then use each database's Information Schemata to get the tables and columns in each of the databases. Several recent requests for assistance have used this to answer their needs. I ran it across 245 databases and pulled back 1.4 million results in about 30 […]

5 (1)

You rated this post out of 5. Change rating

2004-04-15

1,326 reads

Blogs

Resetting Git and Abandoning Changes–#SQLNewBlogger

By

I recently had an issue in one of my Git repos, and decided to...

Exploring Window Functions Execution Plans

By

There are quite a few different ways that you’re likely to see window functions...

Exploring Windows Function Execution Plans

By

There are quite a few different ways that you’re likely to see windows functions...

Read the latest Blogs

Forums

sp_server_diagnostics in ErrorLog

By Casper101

I have the following in the SQL Errorlog, that was never there before: sp_server_diagnostics...

Login failed for user sa sql server 2022 - windows server 2022

By aman

i got the login failed error for user sa, but not always so I...

Login failed for user sa sql server 2022 - windows server 2022

By aman

i got the login failed error for user sa, but not always so I...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers