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


Top 5 Contributors of the Month
Pankaj Mishra
Shivakumaran
alex morco
Imran Ghani
Meenakshi
Post New Web Links

View performs differently for different users

Posted By:      Posted Date: October 29, 2010    Points: 0   Category :Sql Server
 

Hi,

I've a view that runs much fatser when executed as a windows user than when executed as a sql login.

The view accesses tables via a linked server as well as local tables. there are also a couple of views that are being accessed as well.

I've looked at the different execution plans and there is a sort that is taking up 83% of the effort when the SQL login is used. However I can't work out how to fix this problem.

Any advice on approach would be greatly appreciated.

 

 


Sean


View Complete Post


More Related Resource Links

Page View Count And Users Online

  
Hello forum I have a couple of questions.  How do I go about tracking the number page views for my web page in a sql table?  Secondly, how do I track the number of users currently online? Any help will be greatly appreciated. Thanks  

Calculated date field displays differently in List View and Data View web parts

  
In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due).  The calculation is =[Created]+7.  I'm trying to display this data on a page using a DVWP.  But first, for testing purposes, I also created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created]. In the List View from within SharePoint, the dates show as expected (for example): Created = 8/12/2010 3:45 PM Due = 8/19/2010 3:45 PM TestCreate = 8/12/2010 3:45 PM In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt).  I see the time displayed for the example list item as: Created = 8/12/2010 3:45:30 PM Due = 8/19/2010 10:45:00 AM TestCreate = 8/12/2010 10:45:00 AM I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds).  It seems like the DVWP is returning the date in a different time zone (with no seconds).  The lcid is set right (1033).  I didn't see any time zone settings for the DVWP specifically.  I'm basically stuck.  Could someone help me figure this one out. Thanks.

How to properly configure permissions so users can view, add, edit, and delete list items, but not w

  
I am trying to figure out how to properly setup security so that it can be configured at the top-level, and then inherited all the way through. Here is what I would like to do: Each user can view, add, edit, and delete list items - but, users cannot modify or delete web part pages. The only way I know how to do this is set Contribute from the top-down, and then go into each Site Pages library and set Read access. The problem is that I have 100 sites, and I was hoping there was a way I could set security at the top, and inherit downward. Rather than having to go into all 100 Site Pages library and set Read access. Is there a way to do this? Thanks in advance.

SharePoint Users Behind a Forefront TMG Server Cannot Access Explorer View in Document Libraries

  
SharePoint server via a Forefront TMG server in a separate sub-domain. These users cannot access Explorer View in Document Libraries nor can they map a drive to the SharePoint directory structure, as users who are in the same sub-domain as the SharePoint server can. How do I setup SharePoint and the TMG server so that these users can map a drive to the SharePoint site? Office SharePoint 2007 SP2 Windows 2008 Server SP2

Some users cannot view reports from Reporting Service

  
Hi.

I can view all my reports but the poblem is when I try to view then from another account then I get the following errors:

An error occurred during client rendering.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CapaInstaller'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

can anyone tell me what is wrong?

Some users cannot view reports from Reporting Service

  
Hi.

I can view all my reports but the poblem is when I try to view then from another account then I get the following errors:

An error occurred during client rendering.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CapaInstaller'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

can anyone tell me what is wrong?

grouped view for anonymous users

  

I have a sharepoint 2010 box that has anonymous access enabled. One site manager put a document library view on two different pages (insert web part --> lists and libraries --> documents) On one page, they let it display the default view. On the other, they changed it to display a grouped view (with plus signs, to expand and collapse the list of docs).

The page with the default view works fine. The page with the grouped view asks for credentials when the plus sign is clicked on. If you click cancel, it displays "401 unauthorized".

Any suggestions?

Mike

 


Assign Different View to different users

  

Hello All, I am new to Sharepoint and would like some guidance with the following sitaution.  We would like to assign a different view for different users.

This is the scenario we have a list with 1000 rows and have 5 users.  We would like to split the 1000 rows evenly among them so billy gets 200 bob gets 200 mary get 200 etc.  Can this be done?  Bob should bot see Billys 200.  Can sharepoint assign the rows evenly among users? Is this scenario even possible?

Any guidance would be greatly appreciated.


Users who do not have permissions to access InfoPath 2007 web based form can view the form if someon

  

I have a SharePoint Form Library with an InfoPath form published to the form as the default template. The form library has several forms in it that have line item permissions. This is supposed to restrict who can view the form. If the user who has had their permissions removed navigates to the form through SharePoint the form does not display (this is expected behavior). However if the user is provided a link to the URL for the form then the can view the InfoPath form.

Here is an example of the link: http://moss.companyname.com/test/_layouts/FormServer.aspx?XmlLocation=/test/InfoPath%20Test/system2009-10-23T12_23_13.xml&Source=http%3A%2F%2Fmoss%2Ecompanyname%2Ecom%2Ftest%2FInfoPath%2520Test%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1

In addition I tried to put the forms into a folder and restirct the permissions on the folder, but the restricted users can still view the form.

When I removed the users permission to the form library then they got an error message.

I also tested this with a SharePoint list item and restricted permissions and this did not allow the user to view the item.

An

--HOW TO -- Only allow logged in users to view Default.aspx, and About.aspx

  

Hello there guys,

First of all, thank you for the attention.


I am having some trouble, I am very new to asp.net, and the last problem I had, I spent about 59 hours trying to solve, Now I have a new one !

:D well, I guess this is part of the learning process...


Well, in Visual Studio 2010, I clicked New Website. @ C# language, ... The template it gives is pretty nice, it creates a database MDF file, and a login/register setup ready to go !...

You guys can see it live AT CLICK HERE ...


Everything is working, well at least here at the local machine...

There are 2 pages in there, Default.aspX, and About.aspx ... I want to allow ONLY logged in users to view those 2 pages...


I tryed a few things, added my account to a role called ADMIN,

In the web.cong I changed Allow"*" to allow"ADMIN" ... still didn't work..

Also, I was trying to avoid using roles for now, and I was trying to find a way to do this for individual pages in the same directory as well... If possible with out touching the web.config file...

But for now, every way will already help me in any future implementations...



Once again, thank you for your attention..


Thanksssss 10000X


SELECT FROM OracleView behaves differently if embedded in a SQL Server View

  

(This forum heading says "access TO Sql Server", but I don't know where else to file this question.)I am running Windows Server 2008 R2 64-bit with SQL Server 2008 64-bit. I am using Oracle Provider for OLE DB for a Linked Server to Oracle 11g with the Oracle 11g client. If I run "SELECT from an Oracle view" in Management Studio it returns data just fine. If that SELECT is used as the definition of a SQL Server view, and a SELECT is done from that view, I get an error:

Msg 7356, Level 16, State 1, Line 2  The OLE DB provider "OraOLEDB.Oracle" for linked server "P101" supplied inconsistent metadata for a column. The column "DATESTAT" (compile-time ordinal 6) of object ""S4250000"."SIGNED_CONTRACTS"" was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 16 at run time.

I am aware of the difficulties of dealing with dates between SQL Server and Oracle. In fact we will probably circumvent our problem by creating a custom view in Oracle with all the CAST functions to make the dates tolerable. I would still like to know more about why the dates are handled when the bare select from Oracle is executed, but they are not handled when the same

Allow non-admin users view site and list settings (delegate control feature?).

  

I wonder if anyone knows of a way to allow regular users to view settings for sites, lists and document libraries (e.g. versioning, navigation, library template settings) without granting them permissions to change these settings?

Why do I need it? 

This is to allow 1st line support to gather some information and identify possible causes of user issues without having to escalate every call to users with admin or site owner permissions. 


Scenario 

A user logs a call saying he's uploaded a document but other users cannot see it. Now,

Truly Understanding View State

  
This article provides a detailed understanding of the ViewState.

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.

GridView Parent Child View with JQuery Effects

  
I was just checked how to add some more cool effects to the GridView control using JQuery. In this post I will display parent-child data in the GridView control with some help of the wonderful JQuery library.

Let's first populate the GridView control.

Enabling Users to Maintain SharePoint Content

  
When SharePoint is installed as a corporate intranet, there is a considerable amount of effort involved in maintaining the content to keep the site relevant. As we discussed in the first few parts of this series, SharePoint has many built-in features to reduce the burden on the site administrator.

Some areas of the site usually contain less-dynamic information. Internal memos and corporate policies are common examples of this information. One option for this information is to post these documents in a document library. Documents in a library are often stored in a few different formats: Word, Acrobat (PDF), or HTML. Each of these formats has its drawbacks.

Model View Controller (MVC) for ASP.NET

  
Model View Controller (MVC) architectures, immediately wonder how the MVC pattern can be applied in an ASP.NET world. This article will demonstrate how the MVC pattern can be applied to an ASP.NET web application and still maintain the basic Microsoft supplied architecture.
Categories: 
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