Today I went on a quest to discover a way to list all currently running SQL Server Agent jobs. As every other quest, this one also started with Google-ing.
Within 2 minutes I found this great post by Brent Ozar on SQLServerPedia. Why is this post so great? It is so great because Brent figured
Continue reading […] How to query currently running SQL Server Agent jobs […]
Recently, at a SQL Server conference, the parallelism topic was brought up. One of the participants in the conversation expressed opinion that once the parallelism for the SQL Server instance is disabled, there is no way a query will be executed in parallel.
At the time I just expressed my doubt and my hope that this
Continue reading […] SQL Server parallelism on server level and MAXDOP […]