Performance Monitoring with SQL Server

Imagine you have a well-performing SQL Server. I know that this scenario is almost unbelievable but sometimes it happens. To make sure that your SQL Server remains healthy in the future you have to establish performance monitoring techniques. With this blog posting I want to give you a quick overview ...

Read more

Why I now (eventually) recommend In-Memory OLTP

Around 8 months ago I wrote a blog posting where I discussed the various reasons why I don’t yet recommend In-Memory OLTP to my customers. A lot of people are approach me these days because they have some performance problems and they are thinking about using In-Memory OLTP to solve ...

Read more

TempDb Changes in SQL Server 2016

A few weeks ago the latest CTP version of SQL Server 2016 was released: CTP 3. This preview version contains a lot of different improvements over the previous CTP. There are also some significant changes in TempDb for SQL Server 2016 that I want to cover in this blog posting. ...

Read more

How to prevent SELECT * statements

Everyone of us knows that it is a bad idea, but we still do it sometimes: we execute SELECT * statements. There are so many different drawbacks to that approach: You return every column single from your table, even columns that are added at a later stage. Imagine what would ...

Read more

Heap Tables in SQL Server

Today I want to talk about Heap tables in SQL Server. Heap tables are tables without a Clustered Index. A table in SQL Server can have a Clustered Index, then it’s called a Clustered Table, and without a Clustered Index, it’s called a Heap Table. In a heap table, the data ...

Read more

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top