Brian Knight

Brian Knight, MCSE, MCDBA, is on the Board of Directors for the Professional Association for SQL Server (PASS) and runs the local SQL Server users group in Jacksonville. Brian is a contributing columnist for SQL Magazine and also maintains a weekly column for the database website SQLServerCentral.com. He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and co-author of Professional SQL Server DTS (Wrox Press). Brian is a Senior SQL Server Database Consultant at Alltel in Jacksonville and spends most of his time deep in DTS and SQL Server.

Set Extended Properties for Every Table

Extended properties are a neat feature in SQL Server 2000 that let you set meta data for an individual object. This stored procedure is a baseline sproc that lets you set the properties of every object in a DB to a given value. For example, if you baseline your database at 1.5.0, you can set […]

2005-03-02 (first published: )

179 reads

sp_MSforeachfk-Perform an action on every FK

This stored procedure loops through each user defined Foreign Key and performs an action on that FK, like disabling them or printing its name. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. .Shortened version of the usage (there are […]

2002-06-14

652 reads

sp_MSforeachsproc -Perform an action on each sproc

This stored procedure loops through each view and performs an action on that stored procedure, like printing the records or running an sp_help. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp.Shortened version of the usage (there are a lot […]

2002-06-14

1,356 reads

sp_MSforeachtrigger-Perform action on each trigger

This stored procedure loops through each trigger and performs an action on that trigger , like disabling or printing it. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. Shortened version of the usage (there are a lot more parameters […]

2002-06-14

636 reads

sp_MSforeachview - Perform an action on each view

This stored procedure loops through each view and performs an action on that view, like counting or printing the records. Please install this stored procedure in the MASTER database. For full usage instructions and advanced parameters please see the article about it at http://www.sqlservercentral.com/columnists/bknight/sp_msforeachworker.asp. Shortened version of the usage (there are a lot more parameters […]

2002-06-14

1,740 reads

Detect the Amount of Wasted Data Space in a Table for 2000

SP_WASTED_SPACE will run through each column in your database and print a report of all the character columns. It will then print a report with :* The maximum length that a column is storing* The average length of data stored in each column* The amount of wasted space in each column* Hints on how to […]

2002-03-14

1,105 reads

Blogs

Synapse Analytics Spark Example 2 - ROW_NUMBER()

By

The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...

Synapse Analytics Spark Example 1 - Group By

By

I have been playing around with the new Azure Synapse Analytics, and I realised...

Renaming Files by Padding Numbers with PowerShell

By

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...

Read the latest Blogs

Forums

The media family on device incorrectly formed for read only file group restore

By thostenor

Yes the databases (source and destination) are the same version.  I have checked 3...

The Time Zone Range

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Time Zone Range

Mathematicians and SQL

By Joe Celko

Comments posted to this topic are about the item Mathematicians and SQL

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers