• Interests: RC Helicopters

Technical Article

Comprehensive HTML Database Documentation (Revised

Getting "Subquery returned more than 1 value" error on cursors. Changed the following in a couple of places and it runs now. systypes.[name], --(SELECT systypes.[name] FROM systypes WHERE xtype = syscolumns.xtype), Mny thanks to whomever wrote the script. Saved me a bunch of effort."This script will document tables (including constraints and triggers, row counts, sizes […]

You rated this post out of 5. Change rating

2005-10-19 (first published: )

578 reads

Blogs

Speaking at SQL Saturday Austin 2025

By

SQL Saturday Austin 2025 is in just a few days. I am honored to...

Updating SSMS is Easy (w/ v21)

By

I’ve been using the SSMS preview for v21. This is the next evolution of...

Execute Fabric Data Pipeline from Azure Data Factory

By

In the blog post Call a Fabric REST API from Azure Data Factory I...

Read the latest Blogs

Forums

The Long Running Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Long Running Backup

Interview Tips

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Interview Tips

importing from PowerQuery... but with multiple powerqueries

By pietlinden

I finally got the PowerQuery source to "show" in SSIS (so I can see...

Visit the forum

Question of the Day

The Long Running Backup

I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?

See possible answers