Many people asked me to create a video on the same topic, so we have Prevent Unauthorized Index Modifications. Here is the video.
SQL SERVER – Prevent Users from Changing Index
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.
SQL SERVER – Trigger on Database to Prevent Table Creation
In this blog post, we will be discussing a very interesting scenario of Trigger on Database to Prevent Table Creation. Let us learn today.
SQL SERVER – List Tables with Size and Row Counts – Part 2
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.
SQL SERVER – Available Free Space in Data and Log File
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.
SQL SERVER – Rename View
There are two different ways one can rename view in SQL Server. Let us see in today’s blog post how to rename view. 1) SSMS 2) T-SQL
SQL SERVER – Find High Frequency Queries
Recently during consulting engagement, we had to Find High Frequency Queries in SQL Server, let us learn that today. Let us learn today.