Are your CPU-intensive queries running slowly? Check your VM type.
When you build a VM for SQL Server in Amazon EC2, Azure VMs, or Google Compute Engine, it’s all too easy to overlook the CPU speeds that you’re getting.
2019-05-03
Performance and Tuning
A Brief History of Deadlock and Modern Approach of Resolution
Deadlocks have been constant troublemakers for database professionals for years. They seem to show up from nowhere and keep on happening again and again. Pinal Dave provides some oversight.
2019-04-05
SQL Server Logical Reads – What do they really tell us?
SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading
2019-01-15
3,258 reads
SQL Server Logical Reads – What do they really tell us?
In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading
2018-12-10
2,593 reads
Automatic Query Performance Tuning in SQL Server Database
In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.
2018-07-10
4,171 reads
SELECT INTO vs INSERT INTO on Columnstore
This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.
2016-08-05 (first published: 2015-06-09)
17,342 reads
Query Performance Tuning – A Methodical Approach
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
15,935 reads
Blogs
The Microsoft Power Platform
By James-Serra
The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow....
From Evangelist to Advocate
It’s time for a little bit of change to occur. I am no longer...
Database File Changes
Data professionals around the globe are frequently finding themselves occupied with figuring out why...
Forums
Building a table based on another one(s)
Hi, We have 3 people that answer the phones to help our customer with...
Best way to find if string is whitespace
I appreciate it is a trifling question and yet. One of our sites organises...
How to measure Latency between App and database server
Hi All, We have SQL Server instance running on a VM. Now we wanted...
Ask SSC