Miscellaneous

Technical Article

Display disk space stats for each table

  • Script

Here is my replacement for sp_spaceused, I have altered it so that if no table is past in using the @objname parameter it loops through all the tables which is alot easyer than running the old one for each table and it displays the data one result set. So should be easyer to create a […]

5 (2)

You rated this post out of 5. Change rating

2007-08-23

1,031 reads

Technical Article

Locate primary key - foreign key relations

  • Script

Recently one of my friend was doing some investigation in a new/unknown database and had really hard time locating the primary key – foreign key relations. Like it’s really tough to locate these relations when not enforced at database level in terms of primary key and foreign key constraints. But generally all database developers keep […]

4.14 (7)

You rated this post out of 5. Change rating

2011-09-14 (first published: )

2,760 reads

Technical Article

Create Log tables and Triggers

  • Script

Usually in business applications it is necessary to maintain the history of the data being modified for auditing purposes or for later analysis. Proven way to achieve this is to create a log table for each datatable with an additional column "Action" to indicate what the user has done on the data (either insert, update […]

1.17 (6)

You rated this post out of 5. Change rating

2007-10-26 (first published: )

6,197 reads

Blogs

Back in the EU

By

I flew to Amsterdam last night and hopefully by the time this publishes I’ll...

The Feedback Multiplier: How Leaders Can Turn Input into Innovation

By

In every organization there is a hidden currency more valuable than capital, more enduring...

Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)

By

Update for SQL Server 2025: This post and the GitHub repo have been updated for...

Read the latest Blogs

Forums

how to use a variable in a CASE statement?

By water490

hi everyone I am getting an error when I add a variable to a...

How to Use SQL Server Features to Cut Web App Latency in Half

By Muhammad Adnan

Comments posted to this topic are about the item How to Use SQL Server...

Choosing an AI in Sept 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Choosing an AI in Sept...

Visit the forum

Question of the Day

The New SQL Server 2025 Data type

In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?

See possible answers