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 8 months, 3 weeks 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 10 months, 2 weeks 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 11 months, 3 weeks ago by Thomas Franz.

Producing a Year-2100-problem by setting 31.12.2099 as default valid_to date. Ensures the job for my great-grandkids or their AI.

Sorry, but this script isn't really good in my opionion.

• why are you counting the numbers of rows to delete, this is a unneccessary big read
• you could write a...

when you already have partitions, you could simply do a

TRUNCATE TABLE dbo.big_stuff WITH (PARTITION(1 TO...

I  just wonder how this even could happen. Did all the companies not install the patches on the testing / dev environment before? And do they not have a cluster...

the problem is, that DATETIME is not an exact datatype (similar to float vs. decimal). DATETIME suppots only about 0.003 accuracy, so a DATETIME2 = '20240708 23:59:59.998' would be converted...

The two statements in the chapter More details of JOINs are equal.

And both are wrong, since you need to put the SUM(o.Amount) > 1000 into the HAVING and not the...

Can't you use Redgate SQL Backup to do restores that are no longer possible with native SQL backups? I think, I did this some years ago with SQL 2005 to...