Well, we discussed this during SQL YouTube Live – Performance Troubles – Execution Plans. Let us see MAX Column ID Used in Table.
SQL SERVER – Using CASE Expression in Default Value
It is not possible to use CASE Expression in Default Values when you add a new column. I hope this answers the question. However, there is a workaround.
SQL SERVER – Table or View – OBJECTPROPERTY
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.
Do MAX(col) Scan Table? – SQL in Sixty Seconds #106
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.