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.
SQL SERVER – Puzzle – Solution – Why Does UNION ALL Work but UNION Produces Error?
Last week, I asked a very simple puzzle about SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?. The puzzle was very simple and interesting both together. I got quite a few valid answers to the puzzle so far. You may check original puzzle post to see all the valid answers. In this blog post we will quickly discuss the answer of our puzzle.
How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155
Question: How to List All the clustered and nonclustered Indexes of Your Table in SQL Server?
SQL SERVER – Log Shipping Monitor Not Getting Updated
One of my clients has implemented log shipping and everything was working fine. Recently they implemented a reporting tool which reported alerts that data missing for few log shipping tables. The data for “last_backup_file” and “last_backup_date” is not getting updated for primary server (log_shipping_monitor_primary) and was showing null. For secondary it was reported correctly.