My apologies,

the queries which run on multiple processor cores (multi-threaded); if DMVs log their information correctly then fine, otherwise do we have any...

GilaMonster (7/28/2015)

---

Not really surprising. IN is usually a tad faster than a join (a very, very small amount). Changing the IN to a join may have also changed the logic...

[font="Verdana"]Great assistance!

Meanwhile i...

[font="Verdana"]

Despite all standard mechanism/best practices, just change the "Subscriber Connection" account to some .. even SQL authentication account; from "Subscriber's Properties" window(SSMS).

Wrote here for any future visitor to this thread,...

[font="Verdana"]Yes, good article again!

You are right that your provided "I know that it isn't a perfect solution" is not perfect. The human judges (interviewers) should be polished and skilled enough...

[font="Verdana"]

What about to call for distribution agent in Push Down subscription (snapshot replication) - which job to execute?

and the syntax listed in Job is not of Tsql SP? So how...

[font="Verdana"]easy hunt:)[/font]

Tough time!!!!! 😉

[font="Verdana"]gotcha! ;-)[/font]

[font="Verdana"]

Nice Article with very good title.

My frame of reference and general work environments do not let me to try to invigilate new technologies and even to implement solutions other...

Good to play with intrusions, but if everyone may have these skills developed.

Meanwhile, having a good boss is a very good luck 😀

Vote +1

"I am highly torn on how to handle requests and content on interview questions, but ultimately I think that putting more information out there is the best way to handle...

[font="Verdana"]Good Discussion!

And i would add that the people who are more intelligent than the average one are much higher distracted with the environmental factors around them, so they prefer to...

Thanks