Browse by Tags

Related Posts

  • Order of INNER JOINS

    Hi all, Is the order of INNER JOINS important when it comes to better performance when writing and executing queries? For example if we use the familiar tblUser, tblRole and tblUserRoles structure,is there a performance difference (or even right way or wrong way) of the query below... SELECT tblUser...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ElCapitan on 10-30-2008, 12:00 AM
    Filed under: Database, queries, Performance
  • should i reuse objects?

    here's the situation: in a function, i create a sqlcommand object, and set its properties and datareader and so on, and execute it and get the result. now here's the question, when i want to make another call to the database and execute a different query with different parameters, should i reuse...
    Posted to Data Access and ObjectDataSource Control (Forum) by ScobY9 on 07-26-2008, 12:00 AM
    Filed under: sql, sqlcommand, .net 2.0 c#, ASP.NET, Asp.Net 2.0, Database, .net 2.0, performance
  • Assess .Net Intranet Application

    I am assessing whether a .net intranet application system is of acceptable, reasonable quality. My criteria so far for this is on several fronts: - Architecture (e.g., is the architecture n-tier?) - Is the code easy to maintain? - Has the code been written with reuse in mind, or refactored? - Are there...
    Posted to Free For All (Forum) by dbrook007 on 01-04-2008, 12:00 AM
    Filed under: ntier, partial classes, persist changes, Report Viewer, solution project, system analysis", System Design, Technical Specification, UI Architecture, UI Framework, UI Process Components, VB, VB Class, VB Classes, vb.net, Web Forms, .NET, 3tier, 3-Tier Architecture, 3-tier programming, approach, architecture, Asp.Net 2.0 : java script, ASP.NET 2.0 NET SQL Server 2005 database connection error, asp.net tuning, assembly, authentication, Basic Architecture Design, Best Practices, bug, business logic layer, caching, Class Design, concurrentcy, Consistency in UI, css, CustomErrorPage, DAL exceptions, data access layer, data access object relational mapping, Data modeling, datagrid, datalogic layer, dataobjects, design pattern, Events, Generics, Globalization, database object, xml, entity, IIS, application state management, performance, Exception Handling, Exception Handling Application Block, Exception Handling Application Block Tutorial, ASP.NET Architecture, sql server, OOP, "system Design", arcitecture, business model, data serialization, GridView, Patterns & Practices, N-Tier, optimization, Reflection, web service, ADO.NET, Asp.Net 2.0, assemblies, Data Concurrency, database, http, methods, Website Problem
  • Performance tips for Database access

    1.Use Stored Procedures whenever possible stored procedures are highly optimized tools that result in excellent performance when used effectively. 2.Use the Optimal Managed Provider Make the correct choice of managed provider, rather than relying on a generic accessor. 3. Pick Data Reader over Data Set...
    Posted to Tips & Tricks (Forum) by swap on 02-09-2007, 12:00 AM
    Filed under: SQL, Access, ADO.Net, Database, Performance
Page 1 of 1 (4 items)
Microsoft Communities