Edward Pollack

sp_msforeachdb: Improving on an Undocumented Stored Procedure

Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!

4.71 (42)

2016-04-15 (first published: )

13,236 reads

Database Design Follies: NULL vs. NOT NULL

It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems more contentious than you expected it to be.

4.38 (78)

2016-02-26 (first published: )

17,844 reads

Blogs

Keynotes in Australia and New Zealand

By

I get to do the SQL in the City Summit keynotes in Australia and...

Event Log File Paths

By

How does one consistently find the correct path to the Extended Event Log file...

Clearing an Email from the Microsoft Directory

By

Years ago I was working on a demo with Microsoft and someone added me...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

DBA Walkthrough – Adding space on IBM AIX Power Machines

By SOLVARIA

Comments posted to this topic are about the item DBA Walkthrough – Adding space...

The Datatimeoffset Value

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Datatimeoffset Value

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers