DECLARE @Data TABLE (Name nvarchar(100));
INSERT INTO @Data(Name)
VALUES 
('Microsoft Windows NT Workstation 10.0'),
('Microsoft Windows NT Workstation 10.0'),
('Microsoft Windows NT Workstation 10.0'),
('Microsoft Windows NT Server 10.0'),
('Microsoft Windows NT...

Actually, in Assembler comparison of 2 values is implemented via deducting of one value from another.

So, if you intuitively replace comparison with deduction then it means that you have some...

Not sure I can understand the request.

can you indicate what do you expect as an outcome?

Talking about efficiency, using variables and flow control in T-SQL says "defficiency" by itself.

More appropriate T-SQL statements should look like this:

SELECT @Val1 = case when @Var1=@VarA and @Var1=@VarA and @Var1=@VarA...

Why Microsoft released a less performant FORMAT function to make SQL server look bad? I am sure Microsoft released it from requests by SQL server community.

If it's so bad,...

If you don’t perform BACKUP LOG every 15 minutes then...

that’s disturbing.

always make sure that you have BACKUP LOG plans on every database in Full mode.

and every database...

What is the schedule of BACKUP LOG on this database?

Check for a job which running every 6 hours around 3 and 9 o'clock.

From how you describe it your vendor has very limited understanding of how databases work. (It should be "have no clue" really, but let's go with "limited understanding" for now)

saying...

Plans reflect the actually executed statements. Which were picked according to the logic defined by parameters or any other kind of states as they were at the time of execution....

Harsh but just. Just like Comrade Stalin.

Joe, when was the last time you walked in a basic software engineering course? Are you sure they still exist? Are you sure “software...

I prefer to ditch original rid's and upload the data using natural keys, with new rid generated within the "merged" tables.

unless, it's important to keep a record of the source...

I must say - storing big documents in SQL Server tables is a bad idea. Storing them inline with transactional updatable data is an extremely bad idea.

if you cannot store...

Updating LOB does not remove old value from the storage, it creates a new one and then changes the pointer in the row of the table.

cleaning up happens on some...