I think part of the problem is how you are defining "first" and "group by". Since you have no ORDER BY in your query, you have no "first"....

To add to what ratbak said, if you have a lot of schemas, you MAY not have a default set to dbo for a specific user. This is configurable,...

Certificates are backed up along with the database, so when you restore, all certificates are restored along with the database. You will likely need to re-map the master key...

In the example you gave, the reason you are NOT seeing a duplicate when you have mother in there twice instead of father is because you used UNION.  UNION will...

My advice - post the error message.  I have a feeling it doesn't say the literal words "INSERT is wrong".

Now, I am also not 100% familiar with PostgreSQL, but I...

The query being executed for those curious and not wanting to click the link:

insert into [ExtractReports].[dbo].[TradeCodesDelete](PartID,Code,CodeTypeID,SourceTypeID,RevisionID,ZPLID,PartLevel,CreatedDate,FlagDelete)
   ----select count(1) from [ExtractReports].[dbo].[TradeCodesDelete]
 ---update [ExtractReports].[dbo].[TradeCodesDelete] set FlagDelete=2 where...

My opinion - missing indexes report is only useful if you know the usage counts for those missing indexes AND the performance gain/hit by creating it.

For example, if you look...

Looking at this, it looks like a homework assignment, so I am not about to just give the answer in TSQL format, but I will try to lead you to...

My advice - reach out to Microsoft support.  You pay for their support and those types of errors are things that should be covered by support.

The link you provided indicates...

My first question on this is - do you need to remove the subquery?.  Is it performing badly?  At what point will it perform "good enough"?  Basically, do you need...

I think I am a bit confused by the question.  My understanding of the "Generate Scripts" button is that it is used when performing an administrative related task and you...

The approach we take at our workplace is that service accounts do not have password expiration in place unless we believe the account has been compromised.  The service accounts also...

What I would do is restore live to a dev environment.  Once things are on the development environment, run the stored procedure a few times as is so you can...

HAHAHA... that is the running gag in the office actually!  But the data in that database is critical to the company until the product goes EOL, yet it is running...

@ZZartin - that makes perfect sense.  I do agree that the "urgent" fixes can go live without prior approval or code review, but we DO still do a post-release code...