Thanks a lot Lowell.

Thanks, This is a DML trigger after insert.

Need to setup alerts to different groups on table insert on different criteria.

Thanks Kenny.

The article mentioned is for TDE enabled db. Not for column level encrypted db.

I was not able to find a script to troubleshoot this particular issue.

http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-january-2016/

Thanks!

Thanks Gail!

Thanks all!

Thanks.

For VARCHAR [varchar(MAX) & varchar(800] fields on two different tables. This fields are intended to use in WHERE CLAUSE (using 'like').

Thanks!

Thanks Gail. The article was much helpful.

Regarding the performance counters to troubleshot sql server memory usage, can you suggest the counters/DMVs/scripts I should use to monitor sql memory other than...

Thanks Gail. But there is a reasonable amount of memory allocated to OS/Other apps which is over 35GB. Still be an issue?

Thanks, If that is the case, why is the available memory on Windows server less than 7GB and going down further day by day?

Locked pages on memory is enabled.

Here's the breakdown:

SQL Server version: 2014 Enterprise

Total on Windows Server 2012 R2: 128GB

SQL Max memory: 90GB

SQL usage on task manager: 31 GB

Total memory...

Hi Gail,

I know the task manager lies. But in this case the locked pages in memory is enabled. And the available memory on "Windows Server" is 7 GB as SQL...