Strong suggestion, don't store the images in the database. Can you? Yes. VARBINARY(MAX) would be the way to go. However, it really negatively impacts a whole slew of things...

Thing is it will be in file format. I mean converted table data in to file and then moved data...but i f there is need to see the data...

dbo.clan.spouses is a 3 part name where dbo is the database, clan is the schema and spouses is the table.

Looking at your screen shot you probably want dbo.[clan.spouses], where dbo...

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

The error message would help but I strongly suspect it is objecting to converting 'this is a string' to numeric. Search for TRY_CONVERT().

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

I cannot help you with this as I do not use...

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 7 months, 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 9 months ago by Ken McKelvey.