Let us learn how I use a quick trick to know the object property with the keyword OBJECTPROPERTY. Let us learn how we can figure it out.
While working on working on a Comprehensive Database Performance Health Check my client asked me – Do MAX(col) Scan Table? Let us learn about that today.
Question: How to Get Rowcount of Every Table in SSMS?
Answer: After watching my earlier video on the fastest way to get the rowcount for the table,
Recently one of my oldest clients asked me a very interesting question about a table variable and SELECT INTO. Let us learn about it.
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.
I received a very interesting question from the user. The question is about modifying the table used in the SCHEMABINDING View.
SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.