Thanks for your help. Sorry, yes, it is one particular database. All of the files listed in sys.masterfiles are reachable.

Thanks. I hadn't seen that option before. I did some research and I think the core cluster resources are the resources required to run the Windows cluster and they are...

Thanks for the reply. I'm not sure what you mean by core cluster resources but I used the same pattern as you when I was patching the servers (manual failover,...

I may not be able to provide a full answer as I've only worked with Availability Groups on 2016. However some more details on your setup might help people assist...

I think the following might give you the result you need?:

select [tbl_name], [tbl_space] from table_growth tg where 
not exists (select 1 from table_growth tg1 where tg.tbl_name=tg1.[tbl_name] and...

I think I misunderstood your first post. Does the table contain:

a) One row for each table and the date is the last time it was updated or

b) One row for...

I think the following would give you the result you need:

SELECT

[TBL_name]

,[TBL_rows]

,[TBL_space]

,[TBL_date]

From Table_Growth


where  datediff(d,[TBL_date],getdate())=1

For  your second question - Is there anything in the SQL log files about the failed increase?

Thanks for the reply. One detail I forgot - if I remember correctly it didn't have to be the same user logged in. As long as there was always someone...

I haven't used Access as a front end for SQL for a long time but I remember that it used to get slower over time. I had to make sure...

I split the table into partitions and some of them have processed. Thank you for your help. For some of the, larger, partitions I receive the following error:

"Failed to save...

• This reply was modified 5 years, 7 months ago by as_1234. Reason: The second file didn't attach initially

Thank you for your help.

I think this might give you the result you need?:

select p.PartID, p.PartNumber,m.SupplierId,m.TradeCode from #tempsupplier m 
inner join #parts p   on p.SupplierId=m.SupplierId
where (m.tradecode is not null...

Hello,

It would help us if you could provide a create table and some example data as detailed here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

With this we know we are using the same data types as...

If further assistance would be useful then can you provide some sample data? I'm not sure of the data that's kept in each table.

• This reply was modified 5 years, 7 months ago by as_1234. Reason: Rephrased reply