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
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
need help with assigning a value to a variable
Hi I am trying to assign the value of the variable using the output...
Merry Christmas 2025
Comments posted to this topic are about the item Merry Christmas 2025
The Reindeer Count
Comments posted to this topic are about the item The Reindeer Count
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers