Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

Today, at its Ignite conference in Orlando, Microsoft is announcing the general availability of a new version of its flagship operational database, SQL Server 2017. SQL Server is a product I have ...

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

Python often gets a bad rap in terms of performance. Critics often move the goal posts mid-discussion, either unintentionally or simply to get a rise out of Python developers. Here's a typical ...

See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a ...

As today’s database administrators (DBAs) manage the complexity of modern database environments, particularly containerized systems, they must lean into smart automation to transform database ...

As the largest health provider in the world, the NHS holds an unparalleled amount of health data, which scientists and researchers should be able to draw on to help find them find ways to treat or ...

Maximize your SQL Server performance – right now! Optimizing SQL Server performance is challenging work. And while you can find a lot of info on general performance problems, there hasn’t been much ...