Puzzle: Write a Shortest Code to Produce Zero.
SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016
One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.
SQL Server Management Studio – New Feature – Object Explorer Query Tracking
A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information. You can read my earlier blog here SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard. In this blog post we will learn about the brand new feature called Object Explorer Query Tracking.
How to Allow Only Alphabets in Column? – Interview Question #136
Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.
SQL SERVER – 3 Different Usage of DBCC SQLPERF
Have you ever wondered what does DBCC SQLPERF do in SQL Server?
How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135
Question: How to Show Results of sp_spaceused in a Single Result?
Answer: When I hear this question from my co-interviewer, I objected. I think it is not a good interview question. I do not expect any of the candidates to remember any of the syntax. Remembering basic syntax should be a good idea, but it should not be the sole requirement of the hiring a good candidate. I believe I am a good DBA but trust me personally I do not remember all the syntax.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
Question: How to Clear Plan Cache with Scoped Configuration?