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.
How to Get Rowcount of Every Table in SSMS? – Interview Question of the Week #288
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,
SQL SERVER – SELECT INTO a Table Variable in T-SQL
Recently one of my oldest clients asked me a very interesting question about a table variable and SELECT INTO. Let us learn about it.
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.
SQL SERVER – Modifying Table Used In SCHEMABINDING View
I received a very interesting question from the user. The question is about modifying the table used in the SCHEMABINDING View.
What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245
SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.
When was Table Accessed Last By User? – Interview Question of the Week #226
Question: When was Table Accessed Last By User?