While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up...

2015-09-25 (first published: 2015-09-11)

867 reads

Extended Events – Event Anatomy

by Jason Brimhall

SQL RNNR

As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the...

2015-09-11

16 reads

Extended Events – Event Anatomy

by Jason Brimhall

SQL RNNR

So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into...

2015-09-11

619 reads

Work of art – the intra query parallelism deadlock graphs

by pankajmanek

SQLYSE with Pankaj Manek

Look at some of the graphs produced by the intra query parallelism deadlocks, below.

Bart Duncan explains this “phenomenon” (bug, rather)...

2015-09-10

1,382 reads

A look on the CXPACKET wait type

by Igor Micev

Si vis pacem, para sql

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...

2015-09-10

41 reads

A look on the CXPACKET wait type

by Igor Micev

Si vis pacem, para sql

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...

2015-09-10

10 reads