Use the queries below to get the desired information.

Execute it at regular intervals (daily?) and store the results. Build a reporting query on these stored results to get the differences...

All settings remain the same. Stats were updated with the regular maintenance tasks.

Your question is similar to this thread.

Btw: you start with the values as a single string with comma seperated values ('a,b,c') and not with multiple strings seperated by a comma...

ram302 (11/17/2016)

---

...Backstory: The query is part of a stored proc, and was running ok in SQL Server 2012. The system was recently upgraded to 2014, and the s.proc is taking...

You are mis-interpreting the relation between processor and hyperthreading. With hyperthreading the physical core acts as multiple cores. To the processes the physical core itself is *not* visible/available on its...

I was editing my first post with the answer to your question, but you were faster with your reply ;-).

Back to your question: Internally SQL will use the most efficient...

These articles are about determining the correct MAXDOP setting:

What value should be used for MAXDOP[/url]

MAXDOP of Confusion (Dear SQL DBA Episode 8)[/url]

Back to your question: Internally SQL will use the...

Queries with a CREATE statement can only be executed once. The second time you execute the same query you'll get the error message about the object already exists. If you...

I won't rant about the age of the SQL server and the end-of-support of it many-many years ago :w00t:. I expect you are aware of it and are just forced...

rajemessage 14195 (11/17/2016)

---

hi,

1) select * from abc where abcid =(select top 1 abcid from xyz where xyzid =@xyz)

2) Select * from df where dfid in (select...

Because it happens only occasionally: could it be an existing file must be overwritten, which is already (or still) locked by another process?

Something like a backup that is created to...

Harshana-455711 (11/15/2016)

---

Hi

We have SQL Server 2012 Standard Edition without any service pack so we need to upgrade to SP3. can we do the in-house upgrade ?. Appreciate your feedback on...

Glad I could help, and thank you for reporting back. This can help others who stumble upon this thread.

The SID on a SQL login can be specified but the SID of a Windows account is defined on Windows level (like in Active Directory). If you want the SID...

I'm not familiar wirth C#, but shouldn't you pass a value for the ID parameter (see bold part below)?

<snip>

...