Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
152 reads
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
152 reads
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
2,542 reads
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
1,082 reads
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-09-02 (first published: 2014-08-26)
7,863 reads
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-08-26
159 reads
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
625 reads
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
127 reads
A few months back I made the decision to leave the relative comfort and security of my permanent role and...
2014-07-09
563 reads
I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...
2014-05-31
1,726 reads
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,623 reads
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Hello SQL Devs, Looking for a reliable way to catch SQL script issues before...
Hey SQL Developers 👋 Struggling with last-minute script errors before deployment? Check out our...
Hi DBAs 👋 Before deploying scripts in production, wouldn’t it be great to catch...
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers