@patrickmcginnis59

Yes, it is certainly possible to have a NoSQL database that handles ACID properly. It just surprises me that some don't. As I understand the Bitcoin exploit, I can't...

@Alan.B

After reading your comment, I've nervously put the routine in a test harness. It clocked at 0.054 Ms. per execution. I have to say that when I'm optimizing, I go...

Here is a LTRIM function that works for whitespace

[font="Courier New"]

    -- does a particular procedure  exist

IF EXISTS ( SELECT  1

            FROM   information_schema.Routines

            WHERE   ROUTINE_NAME = 'LeftTrim'--name of procedire

                    AND ROUTINE_TYPE = 'FUNCTION'--for a function --'FUNCTION'

                    AND...

@SQL-Lover

Surely, neither a key nor a key constraint is an index, though in fact a primary key constraint or unique constraint will usually, in an RDBMS, be implemented by using...

@Jay-h

A 'table' without a clustered index is a bad idea when its data is usually returned in an aggregated form, or in a sorted order.

However, I've noticed a few occasions...

In case anyone is curious as to the relationship between a Primary key and a Clustered index in SQL Server, I cover the topic here Primary Key Primer for...

..or whether it was the clustered...

@Yet Another DBA

For years, I did all my work in ErWin, which is a good ERD tool, and I very seldom used SQL code for designing databases. Mind you, I...

Just posting an answer to this forum just in case anyone else hits the problem.

The return value from a stored procedure is always an integer and it was never intended...

I'm surprised, I'll admit, that anyone should want to argue that developers as a profession are noted for their diversity. Please, if you think that the profession is being...

"As well as computer scientists, I know of several DBAs who were once professional musicians, actors, hairdressers, artists, scientists, athletes, soldiers and even solicitors and architects. They all make good...

I've written a few 'guest' editorials for SSC in the past. I've really enjoyed doing so, and seeing the comments. I'll definitely try entering a few for Steve's sabbatical!

A...

I used to work closely with a security expert who installed an intrusion-detection system. Once it was in place, I was amazed how many attacks we faced, and how some...

@peter-2 E. Kierstead

I would advise you to resist the temptation to blame Microsoft for being slow at shredding XML. I did the same once in the blog I referenced earlier...

I've just run a re-test on my system of the two rival splits, dbo.DelimitedSplit8K, and 'Element-based XML (text()), but this time including the REPLACE-based conversion of the list to XML...