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,788 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,523 reads

Blogs

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

FabCon 2025 Recap

By

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...

Privacy Policy

By

We value your privacy. This policy explains what personal data we collect and why. What...

Read the latest Blogs

Forums

Why would using a variable vs Hard Value impact a Query's Performance

By YSLGuru

Why would using variables in place of hard coded numbers impact a query's performance? ...

XML data import with poor stored procedure performance (needs optimization)

By Lord Slaagh

Hello SSC! I have been tasked with optimizing a stored procedure the imports data...

Trouble accessing hidden XML download link on Blazor-based government site

By Jobs90312

Hey everyone, I'm trying to access an XML file download from a government website...

Visit the forum

Question of the Day

Importing Flat Files

What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?

See possible answers