Many people like this blog post and asked me to follow up questions about whether this method can be used to prevent users from changing the index.
In this blog post, we will be discussing a very interesting scenario of Trigger on Database to Prevent Table Creation. Let us learn today.
Earlier I had written a blog post SQL SERVER – List Tables with Size and Row Counts. Jason Horner, an SQL Server Expert, improved my query.
Earlier I wrote about SQL SERVER – MAX Columns ID Used in Table and lots of people asked me to create a video on this topic. Let us see the video.
Lots of good feedback, I have received on my recent to the point blog posts. Today we will see a script for Available Free Space in Data and Log File.