Introduction to Extended Events
Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in...
2017-11-29
750 reads
Dharmendra Keshari
SQL SERVER ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL
In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise...
2017-11-25
588 reads
SQL SERVER ON LINUX INSTALLATION – PART3 – INSTALL SQL SERVER COMMAND-LINE TOOLS ON RHEL
As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it...
2017-11-23
743 reads
Finding Input Parameters in an Execution Plan
The query execution plan is a map of work which SQL Server is going to perform to execute a query....
2017-11-22 (first published: 2017-11-11)
6,983 reads
SQL SERVER ON LINUX INSTALLATION – PART2 – INSTALL SQL SERVER ON RHEL
In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we...
2017-11-22
812 reads
SQL Server on Linux Installation On RHEL Server – PART1
In the previous posts, we learned how toinstall SQL Server on Ubuntu Server&install SQL Server on CentOS. Today, we’ll walk...
2017-11-21
1,039 reads
Figuring out Time-Out Prone queries
Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done...
2017-11-20 (first published: 2017-11-09)
666 reads
SQL Operation Studio Tool
Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!
SQL Operation studio is a lightweight open source...
2017-11-20
1,547 reads
Getting Query Execution Statistics
If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,...
2017-11-17 (first published: 2017-11-06)
5,956 reads
Over-Indexing can hurt your SQL Server performance
Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked...
2017-11-15 (first published: 2017-11-05)
5,202 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
The Cosmetics Testing Laboratory is called FARE LABS Pvt. Ltd.
Because we are NABL Accredited Laboratories, our personal care and cosmetics research center provides...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers