External Article

Try Before You Commit in Flyway

Sometimes we want to check whether it is possible to run a Flyway migration without error, but not actually make the changes. We might just need to 'sanity test' the performance of a migration on the Staging server, for example. By using a placeholder 'switch' to trigger a SQL Exception, we can get Flyway to roll-back its transaction, and therefore the migration, on demand.

Stairway to SQL Server Indexes

Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.

Blogs

Daily Coping 1 Dec 2022

By

Today’s coping tip is to discover your artistic side. Design a friendly greeting card....

New Database Job – The 6 Month Plan

By

So, we made it through our first 90 days, things start getting tougher now...

SQL Homework – December 2022 – What’s new in SQL Server?

By

SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...

Read the latest Blogs

Forums

Replication Statistics

By coolchaitu

In Transactional Replication, create index and Alter index commands do not get replicated to...

The Last Valid Restore Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Valid Restore Time

Getting started with ROUND() and Its Use Cases

By Manvendra Deo Singh

Comments posted to this topic are about the item Getting started with ROUND() and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers