Bogdan SAHLEAN

  • Interests: SQL Server - everthing

SQLServerCentral Article

sp_who4

Introduction The analysis of blocking in SQL Server can be hard if the SQL Server instance has a high number of active connections. This analysis becomes complicated because busy instances could have more than one blocking connection, meaning that we could have more than just one blocking chain. For every group of blocked connections, we […]

4.13 (8)

You rated this post out of 5. Change rating

2021-02-04

13,999 reads

SQLServerCentral Article

Collections: Computed gaps for continuous numbers

Problem Finding the hole for continuous sequences of numbers could be a discouraging task even for advanced programmers. This article presents a new solution based on usage of geometry data type and on a unknown function (if not, maybe less used function) specific designed for geometry objects. Sample: Given the following sequence of [dis]continuous numbers […]

5 (2)

You rated this post out of 5. Change rating

2020-03-30

1,613 reads

SQLServerCentral Article

Collections

Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of integers? They are lists or arrays consisting of integers. The number of […]

3.13 (8)

You rated this post out of 5. Change rating

2020-02-13

5,945 reads

Blogs

The Basics of TRY CATCH Blocks–#SQLNewBlogger

By

I was working with a customer and discussing how to do error handling. This...

Working with ALS – Insights from the Ability Summit

By

The 14th annual Ability Summit is a global event that I attended a few...

Apr 9 Webinar: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

By

UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar,...

Read the latest Blogs

Forums

Botched "Data warehouse" design...

By pietlinden

Someone landed a PowerBI mess in my lap, and near as I can tell,...

disaster recovery

By sqlfriend

We have two data centers in same city. One is our main site, the...

Set up Availability Group without a cluster to create read-only database

By koln

I want to have a a secondary ready-only database available for reporting, which is...

Visit the forum

Question of the Day

Backing up the Resource Database

How does the Resource database in SQL Server 2022 get backed up?

See possible answers