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...
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

Sharepoint 2007 - Survey removing save button

You will notice save botton in sharepoint surveys when using sharepoint surveys with branching options. It confuse most of surveys users as generally user select save instead of next or finish which result in in complete surveys. We have checked a lot in sharepoint options and failed to find any option thay may allow admisitrator or pulisher to disable this buton and find that there is one work around using sharepoint designer for removing it. 1. Open site in sharepoint designer 2. Go to you subsite and expand pages under survey (created earlier with branching option) 3. Open newform.aspx and find following <asp:content contentplaceholderid="PlaceHolderMain" runat="server"> 4. Add following javascript before closing tag of the content place holder searched in last step <script> var x=document.getElementsByTagName("input"); for (var i=0;i<x.length;i++) { if (x.item(i).type=="button"&&x.item(i).value=="Save...
Read more