Thanks! For audit purposes, I am trying to find when was the the last login of a SQL account in databases. So if i create a new sql account and...

Any help? Thanks in advance!

My understanding is that while running Index Rebuild or Integrity checkdb would not make database unavailable and it will not affect users other than the performance issues. Any thoughts?

Any advice please?

I’m not sure if we have a no activity window.  Users will be accessing and saving documents at any time to our system. Seems like huge loading process is a...

Thanks John. During the bulk logged recovery mode since it's not fully logged operations, would that means i would be ability to lose point in time restore right?

I have question, when i run the exec sp_password syntax it works fine. However, i have server level trigger which i am auditing security access changes, so in order to...

Would you enable the lock page in memory for SQL Server integration service account?

So you mean, Lock page in memory account can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk?

Thanks Guys. Regarding Jeffery response. Yes, I found what is using the memory , its SSIS which is using all of my memory on the server causing OS Paging high...

SQL Allocated max memory is not used by SQL Server, however it is showing the low PLE value.

Thanks Michael. So you saying for DR Secondaries in Always On the databases secondaries should not be in read only so that way Licenses are not needed. Did i understood...

Thanks. So we are thinking to have 3 secondary replicas, one is for reporting (async mode), second one is for sync replicas and third one is for DR(async mode). Would...

If it's DEV or QA then probably you can delete the db and then restore it.

Also would see any issue with reducing the resources on secondary replica, i would not think this has any impact on Primary server. Please advise?