I am a SQL Server Performance Tuning Expert and I consultant with multiple organizations across the world when they have performance tuning issues. I am often showed one or more of the tables of the system and asked to tune system around those tables. The task of table tuning is very challenging.
SQL Authority News – Microsoft Released SQL Server 2019 Preview
The wait is over. Microsoft has just announced SQL Server 2019 Preview in the Ignite conference. Lots of people were wondering if there is going to be any SQL Server 2018. The answer is Microsoft is going to skip this year as a release for SQL Server and will release SQL Server 2019 early next year.
SQL SERVER – Selecting Random n Rows from a Table
Every day I spend a good amount of time with different customers helping them with SQL Server Performance Tuning issues. Today we will discuss the question asked by a developer at the organization where I was engaged in Comprehensive Database Performance Health Check. The developers wanted to know if there is any way he can randomly select n rows from a table.
How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192
Question:Â How to Escape a Single Quote in SQL Server?
SQL SERVER – Query to Find the Longest Running Function – Function Elapsed Time
I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server. In this blog post, we will discuss Query to Find the Longest Running Function.
SQL SERVER – Restoring SQL Server 2017 to SQL Server 2005 Using Generate Scripts
Let me answer the first question first – There is no way to backup and restore SQL Server 2017 to SQL Server 2005 with the help of any tools. In this blog post, we will learn about how we can generate scripts to achieve this task.Â
SQL SERVER – Simple Method to Find FIRST and LAST Day of Current Date
In my very old post SQL SERVER – Query to Find First and Last Day of Current Month – Date Function, I had explained how to find the first day and last day of the current date.