I think this is also posted here https://www.sqlservercentral.com/forums/topic/restore-database-on-azure-vm-fails

Thanks for the test data. The following should work. I tested it with a few combinations with no errors.

drop table #outputTable

CREATE TABLE [#outputTable](

[FirstName] [varchar](255) NULL,

[LastName] [varchar](255) NULL,

[RowNumber]...

I'm not sure about the null issue. Using convert rather than cast might help but I'm not sure.

Can you post some test data? It would really increase the chances of...

I think, but I'm not sure, it's because @pFirstRow and @pLastRow are ints. The compiler sees these int values and the '+' signs and tries to convert the strings to ints so...

All,

Sorry - please ignore this question. A simple mistake reading the results on the posts table. The query works as expected. I had been looking at it for a couple...

Thank you for your advice.

This seems to work:

EVALUATE

FILTER (ADDCOLUMNS(

Posts,"Created year",Year(Posts[CreationDate])

),

AND( 


AND (Posts[FavoriteCount]>1,Posts[ViewCount]>10)
,SEARCH ("SQL",Posts[Tags],1,0)>0)
)

The logic is that the first parameter of filter can either be a table or a filter or, as...

Thanks (to all) for the advice and links. This seems to be helpful too.

Organizational structuring is not so difficult. But the structuring of the cost (6 levels) is...

One thing that I forgot to mention about partitions is that one of the things you can do is store different parts of the table on different storage. The application...

Sue is correct.

More details (2016): https://docs.microsoft.com/en-gb/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver15

More details (2017): https://docs.microsoft.com/en-gb/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-ver15

There is an overview of partitioning here https://docs.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver15

Can...

I think I've solved it. I need to do some more testing and then, if it works, I'll post in case it helps others.

Thank you. Sorry I checked the syntax a few times, before posting, but missed that. Unfortunately I'm still struggling to combine the add columns and filter.

The AddColumns on it's own...

Sorry to add to all the questions:

Has NodeB ever worked correctly as the primary node since the Availability Group was setup?

When you failover to hostB is the IP for the...

Thanks for your help.

Just before your latest posted I tried a further restart of the host and, for some reason, it's working. Sorry I can't provide an explanation as I...

In the log folder I found some .trc files. One of the entries is "Audit login failed". The text is:

"Network error code 0xe8 occurred while establishing a connection; the connection...