Mike Decuir

Former chemist, now data scientist, home brewer and gamer.

[Mike Decuir @mdecuir]

@mrdenny That is what I thought was the case, but just wanted to validate the assumption.

[Mike Decuir @mdecuir]

@mrdenny Then I may have found a different bug than I originally thought.

[Mike Decuir @mdecuir]

Does the query optimizer treat statistics the same whether they are generated with fullscan vs sampling? #sqlhelp

[Mike Decuir @mdecuir]

The level of detail captured by @SQLSentry is overkill most of the time but when things go wrong, that detail makes all the difference.

[Mike Decuir @mdecuir]

Just found a niche but nasty SQL Server merge replication bug that can bring a publisher to its knees. https://t.co/iiWrYjruQr

[Monica Rogati @mrogati]

The Bechdel test for tech conferences: 1) two women speaking 2) on the same panel 3) not about women in tech.

[Mike Decuir @mdecuir]

@brenndanw Wish I could be there but I am out of town through Sunday.

[Mike Decuir @mdecuir]

@dalehirt @DBArgenis @MeherSQL @aspiringgeek @brenndanw @nancyd @DSFNet I would love to, but not heading to the east side or #pnwsql tonight

[Mike Decuir @mdecuir]

If you want to sell me something but make me register before I can learn about what you are selling, you are never going to get my business.

[Mike Decuir @mdecuir]

My team is hiring a primarily DB dev. We get to deal with interesting challenges that no one else will encounter. http://t.co/H2AvcooZYr

[Mike Decuir @mdecuir]

@SirSQL Yeah. Every time I have tried to add some additional monitoring in, such as running a trace, It goes away by the time I start.

[Mike Decuir @mdecuir]

@SirSQL Is there anywhere I could interact with that network/provider stack to get more information?

[Mike Decuir @mdecuir]

@SirSQL This is being run from a SQL Server agent job running a TSQL job step. Dynamic sql is being run using sp_executesql.

[Mike Decuir @mdecuir]

@SirSQL This only sometimes happens and dynamic sql query being generated and executed is identical between successful and failed executions

[Mike Decuir @mdecuir]

@SirSQL I have never been able to intentionally reproduce the problem on any server.

[Mike Decuir @mdecuir]

@SirSQL The job usually runs without issue on all servers. Occasionally a server gets stuck so every execution fails with this error.

[Mike Decuir @mdecuir]

@SirSQL This is a stored procedure that is being called with no parameters. It eventually is executing some dynamic sql.

[Mike Decuir @mdecuir]

What could be causing SQL Server jobs to report "unknown token received" and "string data right truncation" sometimes. #sqlhelp

[Mike Decuir @mdecuir]

@acroll I was thinking of the kind of clout he would care about. Visibly having knowledge about a space he is clearly very interested in.

[Mike Decuir @mdecuir]

@acroll Decent chance you have enough clout by now that he would say yes if you asked.