SQL Server on steroids with RAM disk
I’ve faced pretty common situation recently – you need to work with huge data during development/testing. It’s good if you have...
2011-07-05
2,532 reads
I’ve faced pretty common situation recently – you need to work with huge data during development/testing. It’s good if you have...
2011-07-05
2,532 reads
I was running some database unit tests and needed to drop completely everyhing in my database. There are really many...
2011-07-04
671 reads
Table Value Constructors were introduced in SQL Server 2008 and enables you to (not only) insert more records with one...
2011-06-29
959 reads
It is known that you cannot get inserted identity values using OUTPUT clause when inserting to view which has instead...
2011-06-28
1,728 reads
Red Gate’s SQL Source Control (RGSSC) is very decent solution source control solution for database development. I am personally using...
2011-06-23
3,024 reads
I was using user-defined tables types (UDTT) quite intensively despite of their current disadvantages especially their forced READONLY behavior when...
2011-06-23
3,814 reads
Many years back when ASP 2.0 (not ASP.NET) was used as primary server language for web application on Microsoft platform,...
2011-06-10
739 reads
I faced problem that I had many lookup tables like ProductType, ClientType etc. and wanted to refer to their values...
2011-06-05
1,759 reads
SSMS is abbreviation of SQL Server Management Studio, according to Microsoft description it is “an integrated environment for accessing, configuring,...
2011-06-03
700 reads
SQL Treeo is free add-in to SQL Server Management Studio (SSMS) which enables user to create own folder structures within...
2011-05-25
952 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...
Hey SQL developers 👋 Tired of catching SQL issues after deployment? We built a...
Hi SQL professionals 👋 We’ve developed a smart SQL script validation tool to help...
Hi everyone 👋 We recently built a lightweight Windows tool for validating SQL Server...
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