.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SQL server index

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
Hi All, I am trying to understand some fundamentals in SQL server, I read that indexes (Set of pages) are arranged in B-Tree structure...and if it is a clustered index then we find the row of data at the leaf node or else a pointer to the data in case of a non-clustered index. Now my doubt is clustered index have the row at leaf level that means the entire table is available at the leaf nodes of the clustered index...then where are the non-clustered indexes leaf nodes pointing to  1) Are they pointing to the clustered indexes leaf node, as the rows are there. 2) If they are pointing to some other place then is this not duplicating the records (I do not think this is the case and am understanding things wrong..) Thanks in advance.. Bala

View Complete Post

More Related Resource Links

"Content for this URL is excluded by the server because a no-index attribute." in crawl logs


Hi All,

I am getting following error message in Crawl Logs

" Content for this URL is excluded by the server because a no-index attribute. "

Any help in this regard will be greatly appreciated.



SP2010- Creating an Index server which will host all the Service applications

Guys, Current Environment : 1 Sql server 2008 R2 and 1 SharePoint 2010 Server OS : windows server 2008 all 64 bit (goes without saynig) For better performance i want to seperate out Service application ( expecially Search Service application) to another windows server while keeping the existing one as a WFE hosting CA as well. From the little documentation i found i am creating an Index server(with out CA on it) 2 questions here : 1. Is this the best way to optimize my farm? 2. Is there any online documentation or any knd of link that woudl describe how to set up the index server. thanks in advance. Sameer  

SQL Server 2008 bug with outer join and index

Hello! We found a problem when migrating from SQL Server 2005 to SQL Server 2008. SQL-statements like   SELECT <table1>.<fields>, <table2>.<fields>, <table3>.<fields> FROM <table1> JOIN <table2> ON <table2>.<field> = <table1>.<field> LEFT JOIN <table3> ON <table3>.<field> = <table1>.<field> WHERE (<table2>.<field> = 2 AND <table2>.<another_field> = 'some_text' OR <table3>.<field> = 2 AND <table3>.<another_field> = 'some_text')   give different results on 2005 / 2008. On 2008 I get lots of exessive rows which have NULLs instead of the values required in the WHERE-term. Changing the Compability Level does nothing. It also doesn't matter from where the query is executed (direct via ODBC, in a view or from the Enterprise Manager). 2005/2008 also use different execution plans. (Btw: how can I make an screenshot of a EP larger than the screen?)   After some hours I drilled it down to the existence of a index! By deleting or deactivating the index 2008 gives the correct results like the 2005 did, after activating the index I get these exessive NULL-rows again!   Anyone else ran into this problem? Any tips (dropping all indexes in a 25+ GB DB is NOT an option :-) ?   Thanks in advance! Holger WellenkötterMCTS SQL 2005

remote server problem ; index file cant find my layouts


hi !

i finally managed to finish my first dynamic application with Webmatrix and razor , everything works well locally.

But there are issues online.

i got an index file and a layout file.



in the index file , i've got the following code :

LayoutPage = Href("~/layouts/_layout.cshtml");

when i call the index page with


everything works

but when i try

http://mysite.com/test (without the / at the end )

the server throws this :

Server Error in '/test' Application.

The specified layout page 'test/layouts/_layout.cshtml' could not be found. The following paths have been used: ~/test/layouts/_layout.cshtml;~/Shared/test/layouts/_layout.cshtml;

it seems it cant find the layout file.

any suggestions ?

Enable Full Text Index in VWD 2008 / SQL Server Express 2008


 Hi, I am using VWD 2008 Express and SQL Server 2008 Express. I want to enable full text index in some of my table. How do I do that? I only have  SQL Server Management Studio Express 2008. As far as I know, I cannot use SQL Server Management Studio Express 2008 to update the full text catalog according to : http://msdn.microsoft.com/en-us/library/ms365247.aspx

My tables are also not enable Full Text Search by default. 


 Any help would be very much appreciated!

 Edit 1: Someone had a similar problem to mine on this link: http://forums.asp.net/t/1169961.aspx
I installed the Sql Server 2008 Express with Advance Services and made sure that Full Text functionality is installed. However I don't get a full text menu in SQL Server Management Studio. 

 Edit 2: I uninstall and reinstall SQL Server 2008 Express with Advance Services but still couldn't be able to enable full text index.

 Edit 3: After see this, I guess I have to do it manually then:  http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=3912985

Sharepoint Search Server Express 2008 can not index external domain fileshare with valid account


Since i have understood that sharepoint 2008 search express doesn't do any security trimming i am trying to index an external fileshare (on a non trusted domain) with it. After authenticating with the external domain account I can manually access all the files in that share i need to. Sharepoint 2008 search express somehow is unable to use the crawl rule in which i specified a different content access account (which is the external domain account).It continuously gives the error "Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content."

Exactly the same configuration works fine with sharepoint search server 2010, but that does do security trimming and because of the share being completely external my users could't see any search results.

Any suggestions?

Dedicated Index Server in a SharePoint 2010 Server Farm



We want to have a dedicated Index server in our Sharepoint 2010 Farm and we have have Query roles on our WFE server itself.

I came across this - http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/f775c95d-4bec-450d-a56c-5114a0f52c0a in which it is written: " By installing WFE on Dedicated index server in SP2007 Farm, you will have benefits"

But as per my understanding , in Sharepoint 2010 Farm Setup, we dont need install WFE role on index server as index server will have to propogate index to query server and we cant avoid any network traffic.

Please validate my understanding and if you have any recommnedations for setting dedicated Index server in SP2010 Farm , please suggest .

Thanks .


Vipin Kumar Tanwar ( Technology Architect )

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Index was ou


Dear All,

I am using a client program(c#) which calls the web service.

I am getting the below error:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Index was outside the bounds of the array.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at KrtoPGMSSQLWebServiceClient.rtowebservice.Service.PostGreDataSync(String StrNonQuery, Byte[] byteRowTimestamp, String TableName, Int32 strUniId, String strRemoteCode)
   at KrtoPGMSSQLWebServiceClient.ManipDataExportClient.InsertManipData(DataSet ManipTablesDS) 

KrtoPGMSSQLWebServiceClient--is namespace name

ManipDataExportClient--is class name

InsertManipData--is function name (which calls the DataSet  ManipTablesDS)


I want to know that  whether i am getting this error at the time of calling web service or while accessing web service and why.

Plzzzz help me solve this...

Thank You

Content for this URL is excluded by the server because a no-index attribute.



Can't seem to find where this attribute is set:


Content for this URL is excluded by the server because a no-index attribute.


This is the warning in the crawl log for an entire subsite.



Sql Server Management Studio->Table Properties->Storage->Index Space


Hello Forum Members,

 I have a table with 10K rows which does not have any indexes.But when I select the table properties,click on storage I see index space has a value and is not null as i thought. Will sqlserver add deafult index space even if there are no indexes on the table?? Please advise.



SQL Server 2008 - why is performance WORSE with xml index?

It's crazy, but query performance is about 50% WORSE after I add a primary XML index to my xml field. 

Here's what I'm doing. I have a table containing an XML field ActivityStepLog (contains LogData, XML, UNTYPED)

I generate sample data to insert into this table by running the following
INSERT INTO dbo.ActivityStepLog (
 LogGUID = newid()
 ,LogContextID = newid()
 ,LogTypeID = 2
 ,LogSourceName = 'test test test'
 ,LogContent = (SELECT top 1 * FROM ##SampleData SampleData1 where DecisionLogID = SampleData.DecisionLogID FOR XML AUTO, ELEMENTS, ROOT('BusinessRule') )
 ,LogDate = current_timestamp
 ,CreateDate = current_timestamp
 ,CreatedBy = 'test create by'
from ##SampleData SampleData
SampleData has 100,000 rows, I run it in a loop 5 times so end up with 500,000 rows. The LogContent field has data such as the following:

MySite crawling warning 'Content for this url is excluded by the server because a no-index attribut


Hi Team,

We have SharePoint farm consisting of 2 WFEs, 1 Application Server and SQL Cluster having 2 nodes.  We are are seeing many of the below warnings in the MySite crawling, more importantly we do not see many of document/s and personal blog not being picked up by the crawler and nothing is searchable. We do not have any Crawl rule on mysite url nor scope rule that points to personal site URL

Can some one help me with finding the reason/cause and solution if any one has come out of this situation.

Advance thank you.


Ramakrishna Pulipati SharePoint Consultant Bangalore, INDIA

SQL Server 2005 Transactional Replication Fails to Publish Stored Procedure Containing an Index Crea


I've experienced a bizarre problem with a SQL Server 2005 Transactional Publication. The issue is this: If the publication contains an article that is a stored procedure that contains a create index statement, then there is an error thrown when attempting to replicate the schema of the stored procedure to a subscriber.

The behavior is very odd, because even if the create index statement is commented out, it still gives the exception, and it will only work if it is removed altogether.

Here is the exact error that's being returned:

Command attempted: GRANT EXECUTE ON [dbo].[usp_Test] TO [CompanyDatabase_access]

(Transaction sequence number: 0x00000170000008B9000500000000, Command ID: 5)

Error messages: Cannot find the object 'usp_Test', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151) Get help: http://help/15151 Cannot find the object 'usp_Test', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151) Get help: http://help/15151

The error is accurate, because when I check on the subscriber, the stored procedure wasn't created as expected... but that was the purpose of the publication...

New index server, not seeing any search results


I recently added an index server to our farm (MOSS 2007, 1 WFE, 1 SQL) and split up indexing and querying duties between the new server and old WFE.  Everything appears to be functioning normally, I see no errors in the event logs, all service accounts are the same as before, but if I try and do a search I get no results returned.  I have been running crawls (current crawl time is 10 hours and counting) but if I look it says that there are 0 items in the index.  I am also getting nothing in the crawl log.  No errors, no warnings, nothing.  I'm stumped without any errors as to what might be the cause.  Search was working fine before I added the new box.  Any help would be appreciated.

call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.

jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend