2018-02-28 (first published: 2018-01-10)
3,063 reads
Performance
2018-06-12 (first published: 2018-01-03)
1,944 reads
2018-05-30 (first published: 2018-01-03)
2,478 reads
Why is My Database Application so Slow?
When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.
2017-11-02
7,358 reads
SQL Server Performance Benchmarking with Patterns
A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.
2019-06-14 (first published: 2017-10-19)
4,897 reads
Investigating the Cause of SQL Server High CPU Load Conditions When They Happen
Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.
2017-09-20
4,188 reads
Five Mistakes Performance Tuners Make
Erik Darling explains why your queries aren't scaling in production.
2017-09-06
5,344 reads
Performance Myths : Oversizing string columns
Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.
2017-08-02
8,420 reads
Performance Myths: Oversizing string columns
Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.
2017-07-13
7,641 reads
2017-07-10
880 reads
Blogs
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Forums
Error while connecting Local DB 2012 in Windows 7 PC using SSMS
I am trying to access LocalDB 2012 on my Windows 7 SP1 PC. I...
The Modern Algorithm of Chance
Comments posted to this topic are about the item The Modern Algorithm of Chance
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
Comments posted to this topic are about the item Use Logic Apps To Save...
Question of the Day
Crazy Code I
I have this data in my Customer table:
CustomerID CustomerName 1 Steve 2 Andy 3 Brian 4 Allen 5 DevinI run this code:
SELECT
t.CustomerID
, c.value
FROM
( SELECT
CustomerID
, STRING_AGG (CustomerName, ',') AS me
FROM customer
GROUP BY CustomerID) t
CROSS APPLY STRING_SPLIT(me, ',') c;
What is returned? See possible answers