Question: Is there any way to replace DBCC INPUTBUFFER Command?
SQL SERVER – 2016 – Wait Stats and Queues Script Updated – Identify Resource Bottlenecks
NOTE: This script will just work fine with earlier version of SQL Server (2008, 2012, 2014) along with SQL Server 2016. It will give the expected results in all the SQL Server versions. This script will help you identify resource bottlenecks in your SQL Server.
A few years ago, I wrote the script which will help us identify SQL Wait Stats and Queues. It is a very popular script. You can find the link to the script over here: Introduction to Wait Stats and Wait Types. However, it has been a long time since I wrote that script and it was written for SQL Server 2008.
SQL SERVER – How to Downgrade SQL Server Edition?
One of a unique advantage of freelancing is learning more and more. I get a chance to hear some of the real word problem and it gives me immense pleasure to provide a feasible solution to them. In this blog post we will discuss How to Downgrade SQL Server Edition?
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
Interviews are fun. Most of the time the interviewer has all the interesting questions, but I often come across a few individuals who stomps the interviewer. I was recently called by one of the organizations where I regularly help with their hiring process. They were stumped by interviewing candidates with one of the questions related to recent executed queries. Let us see the question and its answer.
SQL SERVER – DMVs to Detect Performance Problems in SQL Server – Notes from the Field #135
[Notes from Pinal]: Performance tuning is a complex subject, SQL SERVER – DMVs to Detect Performance Problems in SQL Server.
SQL SERVER – Script: Change Service Account Using WMI / SMO
Last week I wrote a post where my friend faced problem because he changed the service account of SQL Server from services. mass rather than SQL Server Configuration Manager. Let us learn how to change service account using WMI/SMO.
SQL SERVER – Identify Time Between Backups Calculation
As part of my script archives, I stumbled upon a script that I had written a long time back and thought this must get to the blog. This script was inspired from a simple question asked by an DBA when I had visited them for a session. The question was…
Read More