Secure or fast? Secure, obviously …
By now you have probably seen the news about a major flaw in the design of CPUs from all major vendors (Intel, AMD, and ARM)… Read More »Secure or fast? Secure, obviously …
Home » Performance »
Performance
No moving parts, the story of persistent memory
In November 2017, during the PASS Summit keynote, Microsoft’s Bob Ward (Principal Architect) demonstrated a “diskless database” running on Hewlett-Packard Enterprise (HPE) hardware. The storage… Read More »No moving parts, the story of persistent memory
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
Gimmicks that work: XEvent Profiler in SQL Server Management Studio
[2018-07-03 edit: The original name of this feature was XE Profiler, but it was changed to XEvent Profiler in SSMS 17.4.] I have a favourite… Read More »Gimmicks that work: XEvent Profiler in SQL Server Management Studio
A trillion and one
Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in SQL Server, using a clustered… Read More »A trillion and one
What you need to know about memory limits on SQL Server
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max Server Memory is *not* just… Read More »What you need to know about memory limits on SQL Server
Locks, Blocks, and Isolation Levels
Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what it all means. Isolation levels… Read More »Locks, Blocks, and Isolation Levels
Acids and Databases: A look at ACID and transactions
Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to select, insert, update, and delete… Read More »Acids and Databases: A look at ACID and transactions
Balanced Power Saving T-SQL script
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and install the product on an… Read More »Balanced Power Saving T-SQL script
Look, Ma, No Surprises
Last week I demonstrated at least 30% performance improvement by switching to memory optimised table-valued parameters on SQL Server 2016. This week I will demonstrate… Read More »Look, Ma, No Surprises
How to make your T-SQL thirty percent faster
Last week, I mentioned a feature in SQL Server, and now in Azure SQL Database, called Memory-Optimized Table-Valued Parameters, which makes use of In-Memory OLTP… Read More »How to make your T-SQL thirty percent faster
Memory-Optimized Table-Valued Parameters
November brings me back to my regular weekly posting schedule. I attended PASS Summit 2016 last week, and saw a lot of great sessions. Aside… Read More »Memory-Optimized Table-Valued Parameters
Azure SQL Database Limits
Let’s talk briefly about resource limits with Azure SQL Database. Because we have to share resources with other users, and because Microsoft doesn’t want us… Read More »Azure SQL Database Limits
Speaking at SQLSaturday 507 this weekend in Edmonton
On Saturday 9 April 2016, four days from today, I will be speaking at the first ever SQLSaturday in the province of Alberta. Edmonton is… Read More »Speaking at SQLSaturday 507 this weekend in Edmonton
Lazy Loading and Tries
This post has nothing to do with SQL Server, but if you like performance tuning, stick around. I learn technology by using it, pushing it… Read More »Lazy Loading and Tries
- « Previous
- 1
- 2
- 3
- Next »