Blog Posts

Blog Post

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Finding Data...

2019-07-02

26 reads

Blog Post

Continuous Learning

In case you can’t tell from some of my blog posts, I’m a bit of an advocate for DevOps. I’m extremely fortunate in my employer, Redgate Software, that they...

2019-07-01

124 reads

Blogs

Scaling PowerShell – Lessons from a Technical Interview

By

Recently, I was in a technical interview where the topic of running PowerShell at...

Installing Old Versions of PowerShell Modules with Their Dependencies

By

I don’t recall where this came up (probably in SQLSlack), but I had a...

In Memory of Andrew Clarke, AKA Phil Factor

By

One of the parts of getting older that really sucks is I seem to...

Read the latest Blogs

Forums

SQL Server, Heaps and Fragmentation

By dbakevlar

Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation

Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Pushing the Limits of AGs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pushing the Limits of AGs

Visit the forum

Question of the Day

SQL Server, Heaps and Fragmentation

A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?

See possible answers