David Bird

Technical Article

Compare the Data in Two Tables

These queries are used to compare the data in two tables.   In these examples all the rows in each table is retrieved and compared using the UNION ALL command.  I would recommend adding additional WHERE criteria for very large tables to reduce the number of rows that will be compared.These SQL statements are based on […]

You rated this post out of 5. Change rating

2007-08-09 (first published: )

2,786 reads

Technical Article

Shrink Log file for all Databases

I use this script to shrink the log files for development databases. The intention is keep the log files as small as possible when the database is not in use. By scheduling this script I can control when it happens as oppose to using auto shrink.

1.5 (2)

You rated this post out of 5. Change rating

2005-07-08 (first published: )

2,521 reads


Parameterize your Databricks notebooks with widgets


Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

FDD 2023 – Session Materials


You can find the slides for my session at Future Data Driven summit at...

Quick Filtering in SSMS–#SQLNewBlogger


I saw someone limit the databases they see in SSMS, which isn’t something I...

Read the latest Blogs


Central Management Server (CMS) on AlwaysOn for Failover Process

By sunshine-587009

Good afternoon! Is there any type of documentation or process for failing over a...

Convert Binary or Hex field to show text information

By kakovatos7

Hi all, I have an SQL database table with events, and within it a...

Write https request to azure blobstorage

By Charmer

Hi All, I have been trying to download a csv file which is produced...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers