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 (7)

2021-02-04

12,423 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)

2020-03-30

1,586 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)

2020-02-13

5,860 reads

Blogs

STRING_SPLIT Basics–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

Read the latest Blogs

Forums

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

SQL Server Kerberos authentication from a Linux clients

By Louis Lam-391748

Hi All, I have a need to establish a SQL Server Kerberos authentication from...

Housekeeping of SQL Azure DB's

By NicHopper

Hi all, I have a question for you, as some move into the cloud...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers