Editorials

SQLServerCentral Editorial

One more reason to use foreign key constraints

Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]

You rated this post out of 5. Change rating

2024-04-27

125 reads

SQLServerCentral Editorial

Do you listen to music when you work?

I want to make this a participation topic. When you are working, do you listen to music or do you need quiet? And if it isn’t music, do you do something else? TV, movies? For me, it is almost always music. As I write my first Database Weekly newsletter editorial in a few months, I […]

You rated this post out of 5. Change rating

2024-04-20

110 reads

Blogs

Bicep Your Elastic Jobs

By

I posted on Terraform and Azure SQL last year but wanted to see what...

3rd Party Applications Have Issues

By

As a SQL DBA, what do you do when a vendor application has performance...

Check Azure SQL DB Space Used

By

A couple of days ago I was doing some cleaning on some Azure SQL...

Read the latest Blogs

Forums

The On-Call Load

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The On-Call Load

Two Table Hints

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Two Table Hints

Database Dashboards in Azure Data Studio

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Dashboards in Azure Data...

Visit the forum

Question of the Day

Two Table Hints

What happens when I run this code:

SELECT
  p.ProductName
, p.ProductCategory
FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);

See possible answers