Does anyone know of a TSQL statement that will tell you what SQL queries use a particular index?
Thanks in advance,
View Complete Post
Hello i need several queries.
1- auto index suggestion query. dont tell me sql server profiler since it always fails because my sql server processes about 10000 query per second maybe more
2- performance degreading index finder query
3- duplicate index finder query
4- fragmantation rebuild query
Started in middle of a new project. Our design architecture uses an n-tier (not MVC - no controllers) structure with Presentation, Data, Business and Service tiers. However the lead analyst has the majoriety of code all in the Business tier claiming it all contains Business logic. Our data tier is nothing more than a single .dbml model of the primary database to support all of the Linq queries in the Business tier. To my mind Linq queries and classes they use are data access and belong in the data tier but our lead analyst says they contain business logic therefore have to be in business layer.
Hey guys, I have these two queries I'd like to combine into one. Is there any way of doing it?
LINQ's ability to project randomly shaped data into anonymous types can be a blessing and a source of frustration, says Julie Lerman. It's great when you just need to grab a special view of your data, but it can be problematic in certain circumstances. She explains what the limitations are and how to get around them.
MSDN Magazine May 2010
Did you know that by precompiling LINQ queries you might actually be degrading your app's performance if you're not careful? Julie Lerman explains how to ensure you're not re-precompiling queries each time and losing the expected performance benefits across post-backs, short-lived service operations and other code where critical instances are going out of scope.
MSDN Magazine March 2010
This month Toolbox provides help with error logging, finds an app that helps you write LINQ queries, and explores the non-technical side of development.
MSDN Magazine September 2008
Use Parallel Language Integrated Query (PLINQ) to take advantage of multi-processor computers and the newer wave of multi-core processors.
Joe Duffy and Ed Essey
MSDN Magazine October 2007
MSDN Magazine May 2007
MSDN Magazine August 2000
We have a web application using VS 2008, c#. We try to filter siteMap nodes based on security roles. We have our customized the mether GetRolesForUser() in RoleProvider class to determine a user's role. In this method, roles will be returned by querying an SQL Server database.
However, we found that each time a page was loaded/refershed, this GetRolesForUser() was called, and the database would be queried. This is too MUCH and expensive.
We thought the roles should be queried only once when a user logs in. After that, role info should be stored somewhere for this user, rather than query DB all the time.
Any ideas, reference paper, snipet,...,?
Thanks a lot!
I need to create the index for a column and accessing that in sqlserver 2005. Please any one help me.
I have my Linq query in which i need to find time difference(not days difference).
The field in database is datetime.
Dim ldtToday As DateTime = TimeOfDay
Dim SR_RM_InnerJoin = From SR In lcntxRT60Entities.RtSReports _
Join RM In lcntxRT60Entities.RtRMaster On SR.RtRMaster.ReportID Equals RM.ReportID _
Select SR, RM _
Deleting items from the index (custom protocol handler) I created a custom protocol handler. I successfully emit entries into the index. I just can't seem to delete them during an incremental crawl.
1. no emitting child item during the enumeration of child entries in a folder
2. returningÃÂ PRTH_E_OBJ_NOT_FOUND fromÃÂ CreateAccessorEx
doing either 1, 2, or both did nothing. The entries are still there.
what i need to do to delete these entries from the index during an incremental crawl?
I am wondering if there is a way to ingest google search index into SharePoint index such that when people search via SharePoint they see the Google results too… incorporated/federated inline with the SP results (not as a separate "box"
We have Google search in our environment and also share-point search. Share-point search for sharepoint site but Google search is for all other environments. Now i am thinking if we ingest the Google search index into share-point then may be its great deal
to provide user a platform to search everything on one place.
I can't start crawl task. The log says that "Deleted by the gatherer (The start address or content source that contained this item was deleted and hence this item was deleted.)" But I did not change the path of content sources and When I
trie to start crawling job it says "Crawling might be paused because a backup or an index move operation is in progress. Are you sure you want to resume this crawl?"
What is index move operation? What should I do? I'll really appreciate the solution greatly. Thanks in advance.
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.
I'm working with an InfoPath2007 form developed to be filled-out through the browser on a SharePoint 2007 site, and I'm testing using Internet Explorer 7. It's a straight-forward form, with a number of text fields and two Contact Selector controls.
The issue I'm encountering is with the Contact Selector control, where if the actor only enters a partial name into the text-field and then TABs away from the control the form will perform its auto-postback to look-up and resolve the partial name (showing the name resolution dialog is necessary), and afterward the actor's cursor is focused on the next field in the form. The actor can type text into the focused field, but any subsequent pressing of the TAB key returns the actor's focus to the browser's ADDRESS bar, which is incorrect as it should proceed to the next field in the form. I understand that the Contact Selector needs to perform its postback to perform the name resolution (so that there is no way through the InfoPath form designer to disable postbacks for the control), but why does the browser not know how to continue the TAB order of the fields on the form even when a field has focus?