Learn how you can parse a series of parameters that are passed in a string of tuples, meaning pairs, of values and preserve order without using STRING_SPLIT with the ordinal parameter.
2023-10-11
2,096 reads
2023-07-28
609 reads
This article looks at calculating prime numbers less than n with one query.
2023-06-14
7,146 reads
Learn the basics of how CTEs work with a few examples in this article.
2023-05-31 (first published: 2023-05-19)
5,825 reads
In this article we cover what a Common Table Expression CTE is and how to write a CTE for doing selects, inserts, deletes, updates and more.
2021-06-02
2020-12-29
660 reads
2020-12-22
851 reads
2020-12-15
648 reads
2020-06-18
840 reads
This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-25 (first published: 2019-11-24)
772 reads
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
Hi, we lost our sever sql2000 To restore database to a new one we...
Hi, since we lost our sql server 2000 server we are trying to restore...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers