Schema Binding in SQL Server Views with indexes

There are ways to optimize your views i.e. by adding indexes on your views. In order to achieve this tunning you shoudl first create view with Schema binding.
This is very Simple see SQL below.

CREATE VIEW [dbo].[vw_sampleView] WITH SCHEMABINDING AS
Select * from tbl_Sample

i.e. You just need to add bold text while creating your views. This will allow you to define index on your views which will result as tunned queries to your databases.

Comments

Post a Comment

Popular posts from this blog

Sharepoint 2007 Showing outlook Inbox using outlook active X control

Outlook provides active X interface for displaying out look inbox and simple object tag can be used to show emails from your outlook inbox. It will display your default inbox therefore can even show images that are stored at your pst file. You may also use this Active X control in Share point 2007 using content editor web part to display users emails but following disadvantages should be kept in mind. Security concerns as it is Active X control Different browser specific and deployment specific issues Look n feel will be different and cannot be branded Will not use Share point security but will show inbox based on outlook configuration e.g. of HTML is as follows. <OBJECT classid=CLSID:0006F063-0000-0000-C000-000000000046 id=ViewCtlFolder width="100%" height="430" Codebase="http://activex.microsoft.com/activex/controls/office/outlctlx.CAB#ver=9,0,0,3203">> <param name="Namespace" value="MAPI"> <param name="Folder&q
Read more

IIS Configuration Error Error: Cannot write configuration file due to insufficient permissions

While deploying my custom asp.net application I found it hard to browse through few asp.net pages. I tried to enable directory browsing feature to locate pages. Selecting enabled after clicking on directory browsing gaves me following error Error: Cannot write configuration file due to insufficient permissions Looking at above issue I thought that may be I need to start my IIS as an administrator so I closed my IIS and start IIS console again as an administrator but above error remain as is. I decided to go for some research over the internet and found an unbelievable solution. i.e. My web.conf file was readonly :D.
Read more

Grails - Introduction

I would like to give you a little introduction of grails in newbie term. If you have decided to start doing web development or learning web development in java then Grails is for sure an good candidate for you to pick and learn Grails provide the framework based on following 1. Hibernate - ORM layer 2. Groovy Server Pages - Presentation/Web layer 3. Spring - Controller layer Why I started to learn grails has a different reason ;) but would suggest techies to just have a look if you choose to go with Java Web Project and would like to reduce some development time
Read more