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?
SQL SERVER – How to Write Correlated Subquery?
This is a follow-up blog post to my earlier blog post written about SQL SERVER – Writing Your First Subquery From a Single Table. In the blog post, we discuss how to write a correlated subquery and why it is actually necessary. In a query, a correlated subquery is a subquery that uses values from the outer query. Subqueries are usually running once for each row processed for outer query and that is why they are often inefficient as well.
How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? – Interview Question of the Week #204
Question: How to Create an Empty Table and Fool Optimizer to Believe It Contains Data?
Answer: Before I answer this question, I must acknowledge that I have never heard this question in my 20 years career before and I must ask you back, where do you come up with these kinds of questions.