I had a fascinating side conversation with a client that introduced me to a financial concept called the Rule of 72. Let us learn today.
Trace Flags 1117 and 1118 No Longer Required since SQL Server 2016
In this blog post, we will discuss the recent implementation of trace flags 1117 and 1118 by a client when it is not required since 2016
Go Programming Language: 10 Interview Questions With Tested Answers
The Go programming language is small, so ten questions cover most of an interview. This post answers each one in plain words with a tiny program. Every program was run twice on Go 1.27.1, and the real output is shown.
SQL SERVER – Convert Cursor to Set Based Insert
In this blog post, we will focus on the issue of cursor-based inserts and demonstrate how to convert them into set based operations.
Finding Top Earners: A T-SQL Challenge in SQL Server
The goal is to find the top three highest-paid (top earners) employees in each department and their corresponding department details.
SQL SERVER – Resolving Deadlock by Accessing Objects in the Same Order
In Understanding SQL Server Deadlocks, I mentioned that one way to avoid or resolve deadlock is by accessing objects in the same order.
Detecting Deadlocks in SQL Server Using Trace Flags 1204 and 1222
Well, let us discuss Detecting Deadlocks in SQL Server Using Trace Flags 1204 and 1222. T-SQL for enabling, disabling, and checking the status of these trace flags.