You are here:

## Blog Archive:

* Can be used in order to search for older blogs Entries

## Search in blogs

 KeywordsPhrase

## Blog Categories:

* Can be used in order to search for blogs Entries by Categories

## Blog Tags:

* Can be used in order to search for blogs by keywords

## TNWikiSummit

 Read first, before you you use the blog!
 Author: ronen ariely Created: 08/10/2010 21:01 Ronen Ariely Public Blog

Recent Entries

## Grouping continuous Ranges together: Part 2, Using geometry Data type

By ronen ariely on 30/03/2019 23:59

We have a SET of separated slots/ranges and we want to represent the merged ranges which cover all the separated ranges, using a SET of minimum number of ranges. In other words, we want to to Group continuous and overlaps Ranges together. If we have SET of slots/ranges, and two or more of these ranges has shared point/s (a point which exists in both ranges), then these ranges can be merge together into a single range.

For example if we are dealing with ranges of integers and we have the ranges 3-6 and 5-8, then we can marge these into the single range 3-8, or the ranges 2-4,4-6 can be merged into 2-6.

In my previous post I covered the solution using the "Gaps and Islands" approach. In this post I will cover a solution which is based on SQL Server built-in GEOMETRY data type.

## Grouping continuous Ranges together: Part 1, Gaps and Islands approach

By ronen ariely on 25/03/2019 13:19

Note! This post is draft, which I post fast as answer to question which asked at stackoverflow. Since I don't have time this week to prepare a well formatted post with images, full explanation, and well formatted text, but at the same time I want to provide a solution for the sake of these who asked for it, therefore I publish this as a first draft and provide the code for one of two solutions I will discuss.

Note! The solution which presented here is not the one which I recommend to use in this case. This solution address the question using a well known approach named "Gaps and Islands" and might fit for most cases. In my next post I will present a totally different approach using my personal trick, which can improve performance dramatically in some scenario.

So what do we have here? The post include code and some comments to solve several scenario of Grouping continuous Ranges together.

I will start with the simplest case which is ranges of integers, for example 2-4, 6-8, 8-10, 13-14 which should be grouped into 2-4, 6-10, 13-14.

Next I will move to explain issue related to the resolution of space between the ranges, and I will go to present a solution for Ranges of Decimal numbers.

Finally, using the solution which I presented in detail for INTEGERS I will present a solution for "Grouping continuous time-slots together", which was the original question in the forum.

## SQL Internals - Physical Table Structure under the hood, and implementation on real case scenarios

By ronen ariely on 20/03/2019 22:40

This post summarize my lecture from last week at PASS DBA Virtual Group.

Understanding what we have under the hood is not only done for the sake of learning a theory, but it directly impacts your daily work, and it can help us to improve performance and reduce resources dramatically.

During this session we discussed the structure of tables behind the scenes. We saw the changes behind the scenes related to DDL actions, which we execute on tables. Using this information, I demonstrated several real case scenarios, and the dramatic impact of understanding the internals on choosing our solution.

Is the order of columns important? Is dropping a column is the right solution and what is the impact? Questions like those are very common in the forums and usually does not get the right answers even by experts, but the answers might be a game changer in production environment.

This session is a live demo!
There is no presentation to share, but in this post I will share the code and some points.

THIS POST DOES NOT REPLACE THE SESSION BUT COMES TO SUMMERTIME IT
It is highly recommended to watch the recording first

## SQL Server: physical_device_name in the Backup log shows GUID

By ronen ariely on 07/03/2019 21:05

The table msdb.dbo.backupmediafamily includes information regarding the media which used for database's backups.  The values in the physical_device_name column shows the physical name of the backup device like backup destination path or restore source path.

I noticed a question at MSDN forum, which was asked many times before in different forums. In this short post I will give some info and explain where these GUID came from and why we see record on backups but we cannot find any backup file related to these

## T-SQL: Playing with STRING_SPLIT function

By ronen ariely on 13/02/2019 00:55
This post does not aim to provide a solution for production but to present some playing with the function STRING_SPLIT which was added to SQL Server 2016, and discuss some theoretical results we can get using the function (Not For Production)

## Transact-SQL: multiple Tips for a single question

By ronen ariely on 11/02/2019 08:02

In this post I want to present several tips which can help in daily queries. This post does not present an advanced topic and it does not bring some high insights, but these tips can be very useful and I already wrote them, so why not present them😃

* You can understand more about what I mean by "I already wrote them" in the off-topic section, or simply skip it and move to the technical part

## Get the name of current stored procedure using SQL Server, Azure Database, Azure Data Warehouse, and Parallel Data Warehouse

By ronen ariely on 12/01/2019 05:37

Several days ago, i saw a question in the MSDN forums, which led me to write this blog. I will rephrase the original question a bit and discuss the following request: How can we get the name of the current Stored Procedure (SP) from inside the SP

This is actually very simple question with multiple solutions which we can use on SQL Server On-Premises, but these solutions are not supported in other frameworks like Azure Data Warehouse and Parallel Data Warehouse.

My goal is to provide solutions for Azure Data Warehouse and Parallel Data Warehouse, but on the way I will cover the common solution for SQL Server and Azure Database as well.

## Azure Resource locks - Will it keep your database safe?

By ronen ariely on 01/12/2018 04:42
There is a very common mistake which I saw many times in the forums. People are using (or advising others to use) Azure Resource locks in order to prevent deletion of Azure SQL database or other services, but is it really the solution and does in work for this task?!? The short answer is NO and for the explanation and full demo, you can keep reading this post

## SQL Server internals: Is Order of Column in the table important?

By ronen ariely on 28/11/2018 19:44

A common question that raise in forums: Is The Order of columns important?

We focus on the database's side and not the client's side point-of-view. For example, is order of columns related to performance, is it related to errors that might rise only when use specific order, or will SELECT query return different DATA (not important the order of the result SET but the DATA) if the order of columns is different...

In this post I want to present some simple demo which answer the question

Update 2019-03-21: adding example from my last lecture.

## Understanding what are Azure Active Directory, Azure Subscriptions, Azure Accounts [Hebrew]

By ronen ariely on 01/10/2018 12:02

המושגים חשבון ענן, מנוי ענן, ושירות תקיות בענן הם חלק מהמנה הלוגי הבסיסי של ניהול השירותים שלנו בענן של מייקרוסופט (Microsoft Azure). עם זה, קיים בילבול דיי רציני בין המתמשים בשירותים השונים לגבי השימוש המדויק של כל אחד מרכיבים אלו וכיצד הם משתלבים ביחד במבנה היראכי. שאלו רבות בפורומים קשורות ישירות או בעקיפין להבנת נושא זה. ככלל אני אוהב לספק תשובות בפורומים ולעזור למשתמשים, אבל מהצד השני אני עצלן ואני לא מעוניין לכתוב תשובה בהיקף של בלוג בכל פעם שאני נתקל בשאלה. לכן אני אוהבמאוד לתת תשובות קצרות יחסית ולהפנות אנשים למאמרים מתאימים ותיעוד רשמי אשר ניתן למצוא באינטרנט.

ואכן, באינטרנט נוכל למצוא מאמרים רבים וטובים בנושא, אבל מייקרוסופט לאמספקים תיעוד רישמי בעברית לצמערי ועד כה לא מצאתי פרסום נאות בעיני, אשר נותן מענה פשוט להבנה, ולכסות נושא זה. לכן אני אנסה בפרסום זה לתת את המענה הנ"ל