Profile cover photo
Profile photo
Ajay Dwivedi
49 followers -
Individual, Blogger, Programmer, SQL Server Professional, Son, Husband & Friend to Many :)
Individual, Blogger, Programmer, SQL Server Professional, Son, Husband & Friend to Many :)

49 followers
About
Posts

Post has attachment
It’s very common for Database professionals to experience blocking. Even though blocking is a usual activity, it can convert into an issue anytime. And becomes pain point when DBAs are not around to monitor blocking in real-time. For the alternative of…
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Want to know how to decide for Index Maintenance solution?
Add a comment...

Post has attachment
Like any other DBA, I fell into the trap of using straight maintenance solution using Reorganize operation for Indexes with avg fragmentation with 30% or less with Index Rebuild for avg fragmentation greater than 30%. Well above approach works fine in…
Add a comment...

Post has attachment

Post has attachment
Recently I was reading about Temporal Tables feature that has been introduced with SQL Server 2016. So, as usual, I thought to get the knowledge in practice with my virtual lab. I tried starting SQL Services, but to my surprise, SQL Services did not start…
Add a comment...

Post has attachment
Recently a good friend of mine asked me question whether is there any performance benefit in filtering the data out in subqueries, and then joining them. Well, answer is NO. If you keep the same tables with exact same predicate logic, it does not matter…
Add a comment...

Post has attachment
Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server Queries while performance tuning, then here is the official verdict from Paul Randal. Thanks Friends! I hope this info has been helpful to you. Happy Coding 🙂
Add a comment...

Post has attachment
Recently as part of Server Migration, I had to move nested folders and files from Source server to Destination. This task becomes hard when directory has child folders and files with no restriction on nesting level. And the subfolders may contain variety…
Add a comment...

Post has attachment
If you are a DBA then you understand the importance of having robust Database Maintenance Solution. Like everybody in SQL Server Community, Ola Hallengren’s Maintenance Solution is my favorite. Two days back, I was deploying OlaMaintenance Solution on our…
Add a comment...
Wait while more posts are being loaded