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

14,130 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,615 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,951 reads

Blogs

Create a copy of an Azure SQL DB

By

Where I work, we will be migrating data from one set of databases into...

Take the SQL Saturday Topic Survey

By

What topics do you want to see presented at a future SQL Saturday (or...

Resetting Git and Abandoning Changes–#SQLNewBlogger

By

I recently had an issue in one of my Git repos, and decided to...

Read the latest Blogs

Forums

Looking for recommendations for reporting technologies replacements

By Rod at work

Here at work I've been maintaining an old ASP.NET WebForms app. I was assigned...

Using TDE Best Practice

By Harold Buckner

I am trying to understand when best to enable TDE. Our Asst. Director has...

Program Code giving duplicate errors where no duplicates exist

By Andre 425568

On our Java Hibernate program it is giving a duplicate value on an insert...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers