We encountered this same issue with some servers we in place upgraded from Windows Server 2012R2 to 2019.  Our server was initially SQL 2014 that was upgraded to 2016, which...

This worked for me.  Also resolved an issue where a new instance of SSMS was spawning each time I double clicked a .sql file.

I started up a trace yesterday to capture some of the statements. If I take one of those statements which was causing 1.4 million reads, with the same parameter...

That was my initial thought, but then when I saw that the query plans were the same before, during, and after the issue, I figured that couldn't be the case.

I have created a stored procedure in the msdb that will basically start a job and wait for completion. I have implemented the certificate signed stored procedure in one...

For those of us who registered using the SSC3D registration code, will you have a list of these individuals or do we need to bring something with us to the...

To add on to my earlier replies, I have the following information/inquiries.

I am trying to identify the best accounts to use for each service.

Microsoft SQL Server Best Practices Analyzer is...

Thanks for the reply Michael.

So I will use separate accounts for each of the services across each of the servers. Just out of curiosity besides what you mentioned about...

I am in the process of researching and testing the use of domain user accounts to run the various SQL Server services as our startup accounts on our servers are...

Thanks for the info. 😀

Doug Hora (5/12/2008)

---

Item 3 mentions replication and the fact you have to remove replication first. If you're moving a file with merge replication on the same server (to one...

Samuel Vella (1/9/2008)

---

It was correct, its your specifications that were wrong 😛

select top 1

date, session

from #rr

where convert(varchar, date, 103) +...

Samuel Vella (1/9/2008)

---

select top 1

date, session

from #rr

where session not in (select session from #rr where message = 'error')

order by date...

Exactly what I was looking for.

Many thanks for the quick replies.

Cheers! 😀

Thanks for your reply. This is not quite what I need. A little more information. Session is reset daily and increases over time (so as the day goes...