Let us see a script built for one of my clients of Comprehensive Database Performance Health Check to Check Index Fragmentation with RowCount.
SQL Puzzle – Schema and Table Creation – Answer Without Running Code
It has been a while we have a puzzle on this blog. Let us have a very simple and interesting puzzle today about Schema and Table Creation.
MySQL – MariaDB – Writing the Very First Stored Procedure
While it was easy to write a stored procedure in SQL Server, for MariaDB and MySQL one has to know a bit of syntax to write the very first stored procedure.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
SQL SERVER Management Studio – ALT Keys Trick to Select Vertical Text
Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.
SQL SERVER Management Studio – ALT + SHIFT Keys Trick to Select Vertical Text
Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.
SQL SERVER Management Studio – Removing Completion Time in Messages
I have received many curious emails and questions while working with clients on Removing Completion Time in Messages. Let us learn them today.
SQL SERVER – Installation Error: 25641- For target, “package0.event_file”, the parameter “filename” passed is invalid. Target parameter at index 0 is invalid
While installing SQL Server 2012 in a client environment, they faced an interesting error about for target. Here is the information that is taken.
SQL SERVER Tools I Use and Recommend (Updated: October 2019)
One of the most popular questions, I had received what tools I use personally when I work with SQL Server. I recommended share my preference.