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
View Complete Post
While multi-core processors have become increasingly common, most applications still fail to take advantage of multiple cores. Here's an overview of creating multithreaded applications that benefit from these new processors.
Daan Leijen and Judd Hall
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.
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
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 _
Top 100 sql queries running on all database hi
This is sql server 2008, I am trying to find the top 100 queries on all database that has the high CPU usage.
Trying to find the database, CPU usage and queries.
I have something here, but does not show the query part.
FROM [Data Collection].[snapshots].[query_stats]
I'm trying to figure out the best way to load my main page faster. What I'd like to do is have the bare bones of the master page display right away and on the Default.aspx Page_Load, call some web services that would query the rest of the items, in chunks, and then display. I have 3 or 4 queries, which would be the chunks I am talking about.
How would I accomplish this? I tried putting Update Panels around the repeaters, but that didn't make the page show any faster, and the page still only displayed once all the data was queried.
I found this article, http://msdn.microsoft.com/en-us/library/2e08f6yc.aspx. Could I call a web service and return a Linq Query and populate a Repeater on Default.aspx? Would I need an Update Panel around the Repeater still?
I also found this article, which was very interesting in that it parsed and returned the actual HTML to plug into the page, http://encosia.com/2008/02/05/boost-aspnet-performance-with-deferred-content-loading/.
I've been reading both of these for a while to try to understand which may be the best method to proceed with. I'd really appreciate any a
We have 4 QUAD core processors and we have set max degree of parellelism to 4(as suggested by Microsoft). As of now we are using the default value for "Minimum query plan threshold for considering queries for parallel execution(cost estimate)".
Please suggest how to estimate the best value for for "Minimum query plan threshold for considering queries for parallel execution(cost estimate)"?
Thanks in advance.
Hi, I have a client who we just upgraded to Win 2008 R2 Standard Edition and SQL 2008 R2 Standard Edition
They are complaining about System performance.
Looks like SQl runs only on 1 core, maybe sometime 2 which is maxed out.
"Automatically set Processors affinity mask for all processors" is checked and also
"Automatically set I/O affinity mask for all processors" is checked...
The server was maxed out with memory a few days ago but looks to me that that is something taht SQL 2k8 R2 does. The server has got 16GB ram
Pretty urgent. Got 3 hours to solve it.
I have a windows form with VB and SQL database ,and i find that once i have written some Linq queries that the SQL queries do not work anymore . Is there any reaon for this and if so how can i overcome it?