Software Maturity with Release Management
Adding a release management tool to your software development is a sign of maturity.
SQL Server RTM - June 1
The next version of SQL Server 2016 will be released on June 1, 2016, which means you can start planning those upgrades.
Implementing SQL Server In-Memory OLTP
How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step-by-step guide to implementing an in-memory OLTP solution .
Join Operations – Hash Match
The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.
The SQL Server 2016 Query Store: Analyzing Query Store Performance
There are some obvious advantages to having the Query Store, but what is the performance impact that it is likely to have on a busy OLTP database server? It is early days, of course and until we get more experience we have to rely on Microsoft's estimate of a performance impact of 3-5% on average. However, this will depend on a number of factors such as usage an the way it is configured. Enrico explores some of these factors in order to give a clearer picture of what you should expect.
Adding PK Exceptions to SQLCop Tests
In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.
Solving Tempdb Issues
A simple change might solve some of those tempdb issues various customers experience.
Performance Surprises and Assumptions : DATEADD()
Aaron Bertrand explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.
Use Tools
One of the great things about IT is that we have so many tools to help us do our jobs. We can even build tools as needed. So why don't more IT people take advantage of this?
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Cara refund tiket di Tiket.com
Cara refund tiket di Tiket.com silahkan Hubungi CS Resmi Tiket.com di 0821,6290-9071 Bisa Via...
Bagaimana cara menghubungi CS Tiket.com
Anda cukup menghubungi CS Tiket.com di nomor resmi (0821)62909071 atau melalui whatsapp resmi Tiket.com...
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers