THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences the Microsoft Data Platform

“sys2” scripts are growing

I’ve just released a new script, and now the sys2 scripts are reached the double-digit number: 10!

http://sys2dmvs.codeplex.com/

The latest addition is the sys2.tables_columns scripts that helps me to detect which tables uses LOB column so that I can also check if that LOB data resides on a dedicated filegroup or not. Usually when I have such situations and the LOB data is seldom accessed (say, 1 time each dozens of requests) I create a specific filegroup and use that for LOB data, so that the standard data pages will only hold a 16byte pointer to that data, helping to keep data pages dense and thus extremely efficient from a caching and (read) I/O access point of view.

Published Sunday, February 7, 2010 5:33 PM by Davide Mauri
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About Davide Mauri

Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

This Blog

Syndication

Privacy Statement