One of my clients contacted me for an issue where they reported that they are seeing an issue with numbers when they are accessed via Oracle linked server.
How to Get Top N Records Per Group? – Ranking Function – Interview Question of the Week #156
Question: How to Get Top N Records Per Group? (using Ranking Function)Â
Answer:Â During a recent interview, I had given this simple puzzle to over 40 candidates. This simple puzzle depends on Ranking Window Functions.
SQL SERVER – What Does SET NOEXEC Do?
Just the other day I received an email with a question – What Does SET NOEXEC Do?
SQL SERVER – How to Change Column Property From NULL to NOT NULL Value?
A Very popular question I often here whenever I am presenting at the developer conference – How to Change Column Property From NULL to Not NULL Value?
Difinity 2018 – Auckland, New Zealand – Pre-Con on SQL Server Performance Tuning
It is indeed fun to let you know that I will be presenting at Difinity 2018Â (12-14 February, 2018), New Zealand 3 different sessions on SQL Server Performance Tuning. SQL Server Performance Tuning is my favorite topic and I will get the opportunity to present on this topic not once but three times. If you are in and around the Auckland area, you should not miss any chance to meet me and learn SQL Server Performance tuning first hand from me.
SQL SERVER – 2017 – How to Remove Leading and Trailing Spaces with TRIM Function?
TRIM Function has haunted SQL DBA for ages. If you have been using SQL Server for a while, you will totally agree with me over here. In this blog post we will see how the new feature TRIM of SQL Server 2017 works in few simple words.
SQL SERVER – Introduction to Log Space Usage DMV – sys.dm_db_log_space_usage
It has been quite a while since SQL Server 2017 has been introduced, however just recently I have been seeing interest for this project. Lots of users are just switching to SQL Server 2017 and I believe that is normal. In the year 2017 during my Comprehensive Database Performance Health Check, I encountered mostly SQL Server 2014 and SQL Server 2016. Recently, during the consultancy, I received a very interesting question about log space.