RCSI/SI doesn’t work with rows larger than 8046 bytes

(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.) During this week I have prepared a workshop about Locking & Blocking for one of my customers. ...

Read more

How SQL Server stores indexes on variable length columns

(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.) In the last months I had done a lot of performance tuning workshops, and there is almost ...

Read more

2 of my favorite new T-SQL features in SQL Server Denali (SQL 11)

(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.) Microsoft released the first CTP version of SQL Server Denali during the SQLPASS Community Summit in Seattle ...

Read more

I’m speaking for the Performance Virtual Chapter of PASS

(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.) On January 4, I’m speaking about index internals for the Performance Virtual Chapter of PASS (http://performance.sqlpass.org). Here’s ...

Read more

I’m starting my own SQL Server Consulting business!

(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.) Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting my own SQL Server ...

Read more
SQLpassion

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top