One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.
It is not possible that readers of SQLAuthority.com is not aware of amazing tools built by Redgate. We all know that Redgate builds tool which makes SQL DBA and Developer’s life easier. We can eliminate human errors and improve our efficiency. Redgate software along with helpful tools also produces a very interesting content for DBA and Developers. I am excited to see that Redate has recently announced Community Hub.
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.
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 being asked in interviews. However, let us accept this question as it is and let us see how to solve this problem.
The other day, I received an email asking – What does elastic scalability mean?
SQL Server Performance Tuning is my hobby, passion and a job. During my recent consulting engagement for Comprehensive Database Performance Health Check, I had to face a very interesting situation which I had never faced before. I personally take any consulting gig where SQL Server is running slow, it does not matter if it is Configuration Manager Console, Dynamics, NAV, SharePoint or any other application which runs SQL Server as a database.