Twitter | Search | |
This is the legacy version of twitter.com. We will be shutting it down on 15 December 2020. Please switch to a supported browser or device. You can see a list of supported browsers in our Help Center.
Andrew J. Kelly
SQL Server Consultant, Senior Technology Subject Matter Expert with B3 Group Inc.
4,489
Tweets
256
Following
1,877
Followers
Tweets
Andrew J. Kelly 15h
Replying to @chuckh1958 @alzdba
More than likely the connection has Implicit Transactions turned on. Change that setting and you should see the behavior you are expecting.
Reply Retweet Like
Andrew J. Kelly Nov 30
Replying to @SQLRockstar
Sorry to hear that Tom. I was pretty sick from Covid but it looks like the worst may be behind me and will recover. It doesn't compare to losing someone but I can sympathize with your comments. Condolences.
Reply Retweet Like
Andrew J. Kelly Nov 30
Replying to @DesertIsleSQL
December 7th is already an infamous day. A day that will live in infamy to be exact.
Reply Retweet Like
Andrew J. Kelly Nov 29
Replying to @NYBaronSoftware
I wish I knew. No clue and the few people i have seen recently are all fine
Reply Retweet Like
Andrew J. Kelly Nov 29
Replying to @AMtwo
If it was money I made a mistake. Please send it back
Reply Retweet Like
Andrew J. Kelly Nov 29
Replying to @tjaybelt @jasonhorner
I heard someone with a Rzr put it there in the middle of the night. I am betting TJay had something to do with it.
Reply Retweet Like
Andrew J. Kelly Nov 29
Replying to @DesertDBA
Thanks Jeff. I had taken vacation for the whole week and ended up stuck in the house and in bed for much of it. Not what I had envisioned for my vacation :)
Reply Retweet Like
Andrew J. Kelly Nov 29
Replying to @GlennAlanBerry
Been using mine for about 3 years now and couldn't be happier with it. Makes my desktop scream, especially on boot up.
Reply Retweet Like
Andrew J. Kelly Nov 29
Today is the first day since getting sick with COVID that I can actually feel myself getting better. I still can't taste or smell anything but the chest pressure has subsided noticeably and I can breath much easier. I am sure I am past the worst of it now.
Reply Retweet Like
Andrew J. Kelly retweeted
U.S. Marines Nov 27
Replying to @USMC
Their heroism allowed UN forces to break through enemy lines, saving 98,000 refugees evacuated at Hungnam Port.
Reply Retweet Like
Andrew J. Kelly Nov 10
Replying to @way0utwest
Thats a lot of XBox game credits
Reply Retweet Like
Andrew J. Kelly Nov 10
Same to you. OohRah
Reply Retweet Like
Andrew J. Kelly Nov 6
Replying to @nicharsh
Enjoy Nick. Wish I was there
Reply Retweet Like
Andrew J. Kelly Nov 6
Replying to @AndyLeonard
I verified and the table was truncated earlier so there was no data in it when the Drop was issued. It was spread across 4 LUN's but they are all FLASH and no issues reported. The drop took almost 2 hours with 0 waits or blocking. CPU was racking up but otherwise no reason.
Reply Retweet Like
Andrew J. Kelly Nov 5
Replying to @AndyLeonard
They tried that first and same issue
Reply Retweet Like
Andrew J. Kelly Nov 5
We have been seeing for a while now that actions such as DROP TABLE take a very long time. I am trying to drop a CCI table that is completely empty and it has been running for 30 minutes with no waits reported and no blocking. 2016 SP2 CU14. Anyone else seeing this?
Reply Retweet Like
Andrew J. Kelly Nov 5
Replying to @GlennAlanBerry
Seriously. I would have stayed home and ordered online.
Reply Retweet Like
Andrew J. Kelly Sep 28
Replying to @pshore73 @SQLBek and 2 others
He is a Marine. He filters thru his teeth
Reply Retweet Like
Andrew J. Kelly Sep 28
It's called collateral damage
Reply Retweet Like
Andrew J. Kelly Sep 28
There is no fun in that. A tactical approach is the way to go
Reply Retweet Like