Roman Numerals to integers, and Vice Versa, in SQL:
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
21,192 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Brute-force searching for data.
Today, I needed a way of searching through a database, any database, looking for a certain string. The procedure I...
2011-07-08
3,809 reads
Belt and braces
A moment ago, I was deep in some coding. What it was is not entirely relevant, With a page-full of...
2011-06-30
2,586 reads
'Topping and Tailing' strings in database tables
/*
When you are having to extract just part of a string in TSQL, there are a number of techniques you...
2011-06-14
2,220 reads
A Quick TRIM, Sir?
The other day, I was answering a question on the ASK.SQLSERVERCENTRAL.COM forum from a programmer who had hit a
problem...
2011-01-28
2,152 reads
Silly Billiseconds
You have to admire Microsoft for sticking to their guns, even when being palpably stupid. I refer, of course to...
2011-01-13
3,341 reads
Listing members of a group in SQL Server.
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,558 reads
Cleaning up excess contiguous spaces in strings. A mystery.
/* Have you ever come across the problem where you have to remove spaces from a string that has too many?...
2010-09-30
2,976 reads
COMPUTE: now it is going, what else will do it?
/*I'd be very surprised if you've ever used the old COMPUTE clause in SQL Server. It is a bit mad,...
2010-09-23
1,618 reads
Ambiguities and the wild object.oriented brigades
--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over...
2010-07-29
2,005 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers