You need to put SQL in a Query Window. This can be opened on the top left of SSMS.

dbo is the default schema. You can create your own schemas to...

This is a MS SQL Server site so will not normally deal much with web developemnt. It may be best to look at https://stackoverflow.com although you had better check...

While better than nothing, I doubt many people use maintenance plans. I use the following:

https://ola.hallengren.com/

and

https://www.brentozar.com/archive/2017/03/databaserestore-open-source-database-restore-stored-procedure/

• This reply was modified 1 month, 3 weeks ago by  Ken McKelvey.

One solution would be to copy the data to a centralized database/warehouse and report from that.

https://learn.microsoft.com/en-us/answers/questions/1186978/is-it-possible-to-create-a-linked-server-from-azur

I have never come across this either.

The first thing I would do is run Brent Ozar's sp_blitz. As well as the health check, there are parameters which allow you...

The simple approach would be to put your query in a CTE with

,ROW_NUMBER() OVER (PARTITION BY Model ORDER BY Cal DESC) AS rn

and then SELECT FROM the CTE WHERE rn...

Do you have any DDL and test data to demonstate this?

1. If RT.coloumnC etc are strings, you could try something like:

RT.coloumnC='something' COLLATE <RT.coloumnC collation>

2. If #lt is not too big, you could try creating a remote SP and passing the...

¿Qué?

Just send an html email with the table in the body text.

• This reply was modified 3 months ago by  Ken McKelvey.

https://stackoverflow.com/questions/7086393/create-html-table-with-sql-for-xml/39487565#39487565

https://learn.microsoft.com/en-us/sql/xquery/flwor-statement-and-iteration-xquery?view=sql-server-ver15&redirectedfrom=MSDN

Why are you trying to install SQL Server 2005 when the lowest supported version is SQL Server 2016?

What version of Windows are you trying to install SQL 2005 on? I...

It is the SQL Server VSS Writer service which writes details of VSS backups to MSDB so that is where to start trouble shooting. Check the service account, check the...

• This reply was modified 3 months, 1 week ago by  Ken McKelvey.

The SQL Server VSS Writer service is probably disabled. It might have been disabled if it was interfering with SQL Server backups.

Before relying on someting like Veem, make sure you...

You could generate the code as dynamic SQL to cope with different numbers but you would need to check carefully how efficient a value of 100 was.

Whatever you are trying...

• This reply was modified 3 months, 2 weeks ago by  Ken McKelvey.