Mala Mahadevan

Querying database schema using graph tables

SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature more usable – although it is far from a full-fledged graph database. Graph tables are essentially […]

5 (4)

2019-12-23

12,294 reads

Graph – Shortest Path

‘Shortest path’ is by far the most feature of SQL Graph for now. What does this even mean? ‘Shortest path’ is the term accorded to the shortest distance between...

2019-10-08 (first published: )

483 reads

Simple Graph Queries

In this post we saw how to create some graph tables with data. In this I will explore simple queries off of this data and how they compare with...

2019-10-01 (first published: )

419 reads

Blogs

Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)

By

I am very passionate about having a disaster recovery architecture, plan and strategy. This...

I Presented with Live Captioning and Sign Language Interpreters

By

I had the pleasure of presenting a full-day pre-conference session on the Friday before...

What's New in SQL 2019? at the Santa Fe SQL Server User Group

By

Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG...

Read the latest Blogs

Forums

Nutriverse keto

By khgaqwnmhuop

https dragonsdenketo com/nutriverse-keto/  

Convert column values into single row comma separator

By Rock

Team My requirement is to convert column values into single row comma separator along...

Running VBS Script through SQL Agent Job

By EsquireDeveloper

Hello All, Glad to have found this board. I have a VB Script that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DBCC Meaning

See possible answers