Twitter | Search | |
Jonathan Kehayias
Principal Consultant for , SQL Server MCM and MVP, Rambling DBA, Husband, Father, and general goofball.
34,723
Tweets
780
Following
9,679
Followers
Tweets
Jonathan Kehayias 21h
Replying to @chuckh1958 @PaulRandal
Ask but I am pretty sure that is “by design” and you can’t force an index reorg to a higher priority
Reply Retweet Like
Jonathan Kehayias Feb 18
Replying to @chuckh1958
Do you have the deadlock graph? Can you post it online somewhere like pastebin or email it to me? I'd be happy to take a look at it.
Reply Retweet Like
Jonathan Kehayias Feb 14
Replying to @pshore73 @SqlFerret
Shoot me an email if you need the steps and TSQL
Reply Retweet Like
Jonathan Kehayias Feb 14
Replying to @pshore73 @SqlFerret
It would only save you the snapshot generation and BCP from the publisher, but that can be totally worth it for some systems.
Reply Retweet Like
Jonathan Kehayias Feb 14
Replying to @pshore73 @SqlFerret
You can have both up and running with that method. You are just pausing distribution to get the backup and LSN and then you start the agent again
Reply Retweet Like
Jonathan Kehayias Feb 14
Replying to @pshore73 @SqlFerret
If you are just moving the subscriber to a new system you could take a backup of the subscriber and initialize from LSN if you pause distribution first and grab the distribution agent LSN from the distribution database.
Reply Retweet Like
Jonathan Kehayias Feb 13
But I don’t do the whole passive aggressive thing, I am totally an “Active Aggressive” if you mess with me
Reply Retweet Like
Jonathan Kehayias Feb 13
She was way nicer than I would have been. I would have timed the punch and slammed back as hard as I could against the seat so it actually smashed his fist and then he would have had a reason to be mad.
Reply Retweet Like
Jonathan Kehayias Feb 13
You need more time with papa bear Timmy? LOL!
Reply Retweet Like
Jonathan Kehayias Feb 13
Be careful, you can't unsee somethings, and I am not responsible for therapy bills, ask
Reply Retweet Like
Jonathan Kehayias Feb 13
[Blog] Transactional Replication Use Cases - Common use cases as well as scenarios where it can be used to solve a business problem a different way.
Reply Retweet Like
Jonathan Kehayias Feb 13
Replying to @KimberlyLTripp
Reply Retweet Like
Jonathan Kehayias Feb 13
Replying to @KimberlyLTripp
Now I am trying to think about just how many times I did that during setup of a classroom.... This could be dangerous, worse than the photo which cannot be mentioned bad even...
Reply Retweet Like
Jonathan Kehayias Feb 13
Lovely... What happens at , gets published on FB, IG, and Twitter for all eternity... LOL!
Reply Retweet Like
Jonathan Kehayias Feb 12
Replying to @pshore73 @Bobr_1981
For something fragmenting that fast, just experience. That’s not a one size fits all recommendation, it was specifically for the scenario that was provided in the question. 80% fill on a identity column with inserts only would just waste 20% page space for nothing gained
Reply Retweet Like
Jonathan Kehayias Feb 12
Replying to @Bobr_1981
That said, I wouldn’t just focus on avg_fragmentation_percent as a metric on SSD, I would also look at page density and use that to determine how much wasted space there is on disk and in memory
Reply Retweet Like
Jonathan Kehayias Feb 12
Replying to @Bobr_1981
Fragmentation would be driven by the key order, randomness of values, fill factor, and whether you have RCSI or a Readable Secondary enabled for an AG due to the 14byte version tag overhead on modification. If the fill factor is 0 I would start with 80 and monitor
Reply Retweet Like
Jonathan Kehayias Feb 11
I know not what you refer to here
Reply Retweet Like
Jonathan Kehayias Feb 11
Because picked the worst photo out of the batch to post of me.
Reply Retweet Like
Jonathan Kehayias Feb 11
SQL 2017 and 2019 installed side by side on same server. Installed SSL Cert for protocol encryption. Configuration Manager for 2017 can't find cert. Configuration Manager for 2019 can. Why can one see the cert and not the other? Any ideas welcome at this point!
Reply Retweet Like