999 Non-Clustered Indexes on a Table – a good idea?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) Every index in SQL Server can improve your query performance, if the Query Optimizer chooses the index ...

Read more

SQL Server on Linux – first preview!

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) As you might know, Microsoft announced a few weeks ago that they will release a fully working ...

Read more

SQL Server Quickie #36 – Cross Joins

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) Today I have uploaded SQL Server Quickie #36 to YouTube. This time I’m talking about Cross Joins ...

Read more

In-Memory OLTP and too less Memory

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) I have already blogged a few times about In-Memory OLTP and why I don’t yet recommend this ...

Read more

Crash Recovery & Recovery Models

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) A few weeks ago I released a SQL Server Quickie about Crash Recovery in SQL Server. There ...

Read more
SQLpassion

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