How to re-create database quickly
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
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
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
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
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...
If I configure remote access to 0 on my servers, am I right in...
What is the best way to set the schedule of a maintenance plan or...
The LA Data Platform User Group had a necessary speaker cancellation for the group...
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