Twitter | Search | |
Robert L Davis
Database Engineer at BlueMountain Capital Management............. Certified Master: SQL Server... MVP... Poker player... Ordained Pastafarian... Native American
86,835
Tweets
661
Following
6,272
Followers
Tweets
Robert L Davis retweeted
Arun Sirpal 24m
Yeah it's great check out my bug hunting fun
Reply Retweet Like
Robert L Davis 1h
If you have SSMS 16 or 17 installed, you can analyze the dumps via the new self-service tool:
Reply Retweet Like
Robert L Davis 17h
Looks like the mapping changes per version. That's good to know. I was querying SQL Server 16.
Reply Retweet Like
Robert L Davis 17h
Replying to @TheRockstarDBA
Will not block DML operations. Remember that schema changes includes things like rebuilding an index.
Reply Retweet Like
Robert L Davis retweeted
Peter Shore 18h
Pre-Cons on Performance Tuning from & PowerShell from
Reply Retweet Like
Robert L Davis 18h
Good sleuthing. Wonder what the CSN means.
Reply Retweet Like
Robert L Davis 18h
Replying to @TheRockstarDBA
Read uncommitted (aka nolock) takes a shared schema lock on the table and will block schema changes to the table.
Reply Retweet Like
Robert L Davis 18h
I think the first number is spinlock type. 149 = XVB_CSN. No idea what that means or what the other numbers mean.
Reply Retweet Like
Robert L Davis 20h
Replying to @cjsommer
Uncle! :)
Reply Retweet Like
Robert L Davis 21h
Reply Retweet Like
Robert L Davis retweeted
IDERA 21h
5 mistakes that could cost you your job: via
Reply Retweet Like
Robert L Davis 21h
Replying to @cjsommer
Thanks!
Reply Retweet Like
Robert L Davis 23h
for a change of pace, today's train derailment was in the subway.
Reply Retweet Like
Robert L Davis 23h
Ideally, no.
Reply Retweet Like
Robert L Davis 23h
Command line help for PowerShell requested:
Reply Retweet Like
Robert L Davis Jun 27
Replying to @michaelirvin88
If you and Jimmy Johnson had stayed that long, you would have had 8 rings.
Reply Retweet Like
Robert L Davis Jun 27
Happy birthday.
Reply Retweet Like
Robert L Davis Jun 27
I did. :)
Reply Retweet Like
Robert L Davis Jun 27
Funny, I'll be on Homestead Lane. :)
Reply Retweet Like
Robert L Davis Jun 26
You're in Otisville? Or just nearby?
Reply Retweet Like