Conditional DELETE and INSERT in PostgreSQL

Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, called ALL_EMPLOYEES, which contains all employees' information who are working or had ever worked for […]

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

2020 Advent of Code – Day 5

By

This series looks at the Advent of Code challenges. As one of my goals,...

What’s new with Power BI?

By

At the Microsoft Business Applications Summit 2021, a ton of new features for Power...

Tech Field Day 23 Recap

By

April 21 to 23 saw a new milestone for me. I was a new...

Read the latest Blogs

Forums

Availability Group with Replication

By sqlguru

I have configured availability group for automatic failover with synchronous mode. So that way...

Joining 3 tables

By Ctalley13

Hello All, I am new to the SQL world and with work I use...

Geocoding in SQL Server - do I need C# for it?

By pietlinden

I've been digging around playing with spatial maps in SQL Server.  I've read a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers