Eddie dressler @Sqled

Joined October 2013

Tweets

252
Followers

96
Following

82
Likes

28

Eddie dressler @Sqled

2 years ago

@not_unambitious Loved it. Well done.

0 0 0 16 0

View Details

Eddie dressler @Sqled

2 years ago

Loving my first two sessions. One familiar, one new - both teaching me something. @TheCodeTraveler #kcdc2024

1 0 1 31 0

View Details

Eddie dressler @Sqled

4 years ago

Is sqlsaturday still a thing? Im looking to get connected to kansas city’s (or restart it). halp. @sqlandy #sqlsaturday #SQLServer

0 0 0 0 0

View Details

Eddie dressler @Sqled

4 years ago

@quorralyne im going to try to make you KC.NET user group meeting on 7/26! let’s see if my work schedule behaves.

1 0 1 0 0

View Details

Eddie dressler @Sqled

5 years ago

thanks @ShaneWelgama for your locking session. presentation was great, you may keep a glass of water with a straw nearby for dry throat/mouth.

1 0 2 0 0

View Details

Eddie dressler @Sqled

5 years ago

who knows the details of msdb.dbo.syssessions? im desperately tring to stop a zombie agent job. #sqlhelp

0 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

@SluggoDoug i like Elvis Costello’s “you turned to me” for the weeping angels episode as well as “the angels want to wear my red shoes”

0 0 1 0 0

View Details

Eddie dressler @Sqled

6 years ago

Thank you for your vid entitled “BCP in errors” from 3 years ago! @midnightdba. Kept what little bit of sanity i have left.

1 2 1 0 0

View Details

Eddie dressler @Sqled

6 years ago

@Hugo_Kornelis Ill see if i can get a good repro to make it real. Thanks for your help

0 0 0 0 0

View Details

Assume: col1 has clustered index defined on it via a PK constraint. I have a weird case where col2 with a NCI on it performs worse than when col2 has a NCI and INCLUDES col1. I thought the include was kind of implicit due to the NCI built on the CI. details appreciated! #sqlhelp

1 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

@Hugo_Kornelis Hugo TYVM. The confusing part in my case is that all NCIs have a pointer to the CI (its baked into NCIs). So why, if the NCI knows to which row in the CI it points did an INCLUDE of the column (that IS that pointer) speed up the query? It shouldbhave made NO difference

1 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

@Hugo_Kornelis I dont hugo. But its pretty simple. Pk on col1, then run Select col1, col2 from table1 where col2 = 0. Build an index1 on col2. And the select will use the index. build index2 on col2 INCLUDE col1 and Rerun the select. You will see rhe ExePlan choses the index2...why?

1 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

For anyone who needs a reminder.... #sqlhelp.

1 0 7 0 0

View Details

Eddie dressler @Sqled

6 years ago

@mrdenny @jdanton @erinstellato Ha! Never would I ignore you @mrdenny Thanks for the chiming in!

0 0 1 0 0

View Details

Eddie dressler @Sqled

6 years ago

Can i easly set up an ee session to capture DML? All i want to do is capture and store before and after values of DML. Yes i know i can use triggers, yes i know i can use CDC. Im pouring over all of my options and figured id ask the expert(s)... #sqlhelp @erinstellato

1 0 1 0 0

View Details

Eddie dressler @Sqled

6 years ago

@jdanton @erinstellato @mrdenny In rereading my post i realize i refered to two different phenominoms. I wish to capture data values not sql statements. Thanks Joey and Denny for the followup.

1 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

@erinstellato @jdanton @mrdenny Erin you are a rocker! Thanks for directly answering my question! And thanks to this community for chiming in. After a full day of researching i too found no way for exented events to capture a before and after value of an update!

0 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

@pinaldave Thanks for another great performance demo. This time in MySQL!

0 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

@PaulRandal Thanks for your responses Paul! I think im closer to solving my issue.

0 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

I have idle blockers running amok in prod. ill get one “random” session go idle and that will start a nasty blocking chain. Does anyone have good systemic ways to root cause why the spid/transaction went idle in the first place!? Thanks all! #sqlhelp.

0 0 0 0 0

View Details

Eddie dressler @Sqled

6 years ago

@PaulRandal Dpa defines an idle blocker as one that WAS doing work but is not currently. Often times from an mis managed trans. So i have a spid and a time point and i know its blocking locker. Another road i could go down is “how do you find the last wait a spid had?” Thanks!