Vote for DB-First too - as long it are additions to the database, e.g. new columns or tables etc. As long you provide good default values (for new columns), the...

I think this is an AI generated article that contains lots of failures posted by a person with no real knowledge that was not even willing to test the results...

you can speed your WHILE loops up, when you simply do

WHILE 1 = 1 -- endless loop
BEGIN
    UPDATE TOP (@batchsize) ... WHERE ...

 ...

Regarding to the costs of local storage:

On "my" SQL Server we bought four 16 TB SSD drives last year (there were no more internal spots free) that can store the...

Querying for GETDATE() BETWEEN valid_from AND ISNULL(valid_to, '20991231')  is...

Allowing no NULL in valid_from / valid_to seems to be a good idea. But implement it with a DEFAULT = '18991231'  on BOTH columns (as at one of my previous...

I don't see the need for this undocumented command for this case (attaching a file). In reality it would cause more problems that it solves.

The command for attaching a database...

Are now bots commenting and praising an AI generated article?

For the sake of completnes in SQL 2019 you can use STRING_AGG() to aggregate the text of multiple lines - something...

@Snehalatha Mannar: LEFT(), RIGHT(), SUBSTRING(), REPLACE(), CHARINDEX() and combining strings by adding them is part of every ANSI-SQL-Standard compatible language, so you can use them to do easily what STUFF()...

• This reply was modified 1 years, 9 months ago by Thomas Franz.

Someone seems to know, how to ask a KI for a full explanation with examples for an SQL function...

If this would be a manual written article, you would have realized...

In the praxis you want to rename the files / folder too, since it is usually very inconsistent to have a database ArchiveSales with OldSales.mdf / ldf

Therefore for a clean...

Most servers have autopatching enabled and assigned to different groups that defines on which weekday at which hour they are allowed to restart.

Some servers (as our SQL Servers) are patched...

when I cast the values as VARBINARY(MAX) it works too.

TRUNCATE TABLE dbo.Image_Staging; TRUNCATE TABLE dbo.Images
INSERT INTO  dbo.Images (imageid, imagestatus, imagemodified, imagebinary) VALUES (1, 1, GETDATE(), HASHBYTES('SHA2_512',...

• This reply was modified 1 years, 10 months ago by Thomas Franz.

Bad style of the query (I know, it is intended here, but you should never write it this way in real code).

Instead of

SELECT 
  c.CustomerName, COUNT(oh.OrderID)
...

Nice solution.

Instead of combining LAG() and SUM() OVER you could have used just LAG - at least when it are just a fixed number of the last 4 entries. For...

• This reply was modified 2 years ago by Thomas Franz.