Un-concatenating row values
/* Anith Sen's achievement, in his article 'Concatenating Row Values in Transact-SQL' has been to list and illustrate the many ways...
2008-10-06
1,734 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Never say 'never' to the WHILE loop.
/* download the test text file Moby-Dyck.zip here */
/* You might notice that I refer to Moby **** in this blog. This is because the busybodyish...
2008-10-02
2,207 reads
IT Project Euthanasia
A guest editorial from Phil Factor on the kindest way to dispose of unwanted IT projects.
2008-05-26
146 reads
Every DBA's nightmare
When a copy of all 25 million of the UK’s child benefit records, including bank details, went missing in the post, whilst being sent to the NAO (National Audit Office) on 18th October, the UK government must have known that a cover-up was impossible. This sort of incident is every DBA’s nightmare.
2007-11-26
156 reads
Blogs
A Very Cool Benefit in SSMS 21
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Creating a “Real” Copy of a View: #SQLNewBlogger
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
Forums
Topic marked as spam - by mistake?
I received the following notification a few hours ago. It seems legit but has...
Getting blockage on Update Statement
Hi, Need your help. I've a SP that is using Update statement on a...
Query is filling Tempdb
I have query which is filling TEMPDB I need suggestion how to modify this...
Question of the Day
The Hash Join III
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers