How much space does a view take up in Microsoft SQL Server

I have a very large table in SQL Server 2008. It has lots of fields which are only useful to a certain segment of users, some of the fields some users shouldn't be able to see.

The table is huge so I wanted to create some simple views for each user class where I could give them access to the view and they could only see the columns they need.

Does a view take up space in the database, or would it be saved as a simple select statement?

Answers


Unless the view is indexed, it takes up almost no space, except for the definition of the view. The view itself is not like a table in that it physically stores rows in the database (unless it is an indexed view). It is only materialized (retrieves data) when it is called


Need Your Help

How to setup a lot of domain names in one row?

statistics google-analytics analytics web-analytics web-analytics-tools

I am working on a blog factory and we let the final user to use a fully customized domain name like www.myawsomeblog.com. There is a lot of people using this feature, so we cannot do a per case

get data from server using ajax and put it in a datatable

python ajax django json datatable

i have an array of data, in which each element is a dictionary. like this:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.