Gosh I just don't remember at this point what we ended up doing. I want to say that we either recommended that they rewrite it to use a single database...

Hi, yes that is my concern that BEGAN TRAN; and COMMIT TRAN; might not be improving things and could expose the query to holding a lock should something go wrong...

I can't use truncate because not all rows are deleted.  The delete is matching rows to rows in a stage table that qualify to be deleted.

The question I have in...

schleep, not exactly. I too expected that xp_logininfo would show that the user has read permission to the database but it does not.  It indicates only that the person gains...

Because logins have user mappings, I though that a login had to be mapped to a database user for the person to get those database permissions. Apparently not... having a...

• This reply was modified 5 years, 1 month ago by  PHXHoward.

Thanks for the replies and the warning about constraints. We have not faced a problem with online index rebuilds because the method that SQL Server uses to keep the index...

Thanks both of you for the info. I'll check perfmon counters.

Looking at another fairly busy vm that handles some communications tools, I see spikes up to 879,956 pages/sec....

Hi Sue.  I just tested again with another login.

grant select on [ReportServer].[dbo].[ExecutionLog3] to [xxx\xxxxx]

The user did not yet exist in the ReportServer database so...

Thank you. I tried to create the user as you advised but it told me that there was already a user in the ReportServer database that had that name.  Checked...

Thank you Jack. It confuses me that the row estimate is more accurate and the subtree cost is lower in 2017 but the elapsed time is longer.

The reason...

Thanks for the script.

Right click inside the query results windows and choose "Save Results As..." will also preserve the formatting when a csv is opened in Excel.

Thanks a lot for replying Jacob.  That did work.

It means that the developer will need to change the query or else remove the repeatable read requirement.  More work...

I take it that the error message is trying to say this:

"Repeatable Read transactions must access memory optimized tables and natively compiled modules under snapshot isolation."

Does...

Thanks Chris and Sue.  Very good information.

Howard