in
Eric Vaillancourt on SQL Server...
All Tags » Performance (RSS)

Browse by Tags

  • Insert Query with Subquery

    Hi: I am using Login,Userdetails tables in which UserID is common for both tables.UserId is Primary key for Login .UserId is not a Foreign Key for Userdetails table due to it refers more than one table. Now I have to take UserId from Login table then insert into Userdetails table along with some other...
    Posted to SQL Dev (Forum) by suresh_dotnet on Mon, Sep 29 2008

  • Re: optimisation d'un update

    Salut Sam, j'ai besoin de plus d'info. une chose que tu peux vérifier est ta clause where. Assure-toi que les champs utilisés dans le where ont un index de couverture. A+ Eric
    Posted to SQL Dev (Forum) by Eric Vaillancourt on Wed, May 21 2008

  • Re: Filegroups

    Oui certainement ! Dans mon cas, j'ai 8 disques(SAS 10000rpm), devrai-je utiliser 2 disques en R-1 pour l'OS, 2 en R-0 pour le log, et 4 en R-5 pour le DATA, ou 4 disques séparé pour le DATA? Dans le premier des cas, je crée 4 fichiers sur le disque DATA et les inclus dans un filegroup DATAfg...
    Posted to SQL Admin (Forum) by cyberghis on Thu, Apr 17 2008

  • Re: Filegroups

    Bonne Question ! Premièrement, je vais supposer que vous avez 4 CPU et 4 Disques. Le recours aux fichiers et aux groupes de fichiers améliore les performances de la base de données car cela permet à celle-ci d'être répartie sur plusieurs disques et tout les CPU. Chaque base de données possède un...
    Posted to SQL Admin (Forum) by Eric Vaillancourt on Thu, Apr 17 2008

  • How to Tune a Database Using the Database Tuning Advisor (DTA)

    The Database Engine Tuning Advisor (DTA) is a new tool in SQL Server 2005 that enables you to tune databases and improve the performances of your queries. DTA examines how queries are processed in the databases you specify and then it recommends how you can improve performance by suggesting the creation...
    Posted to MS SQL Admin (Weblog) by Eric Vaillancourt on Sat, Apr 5 2008

  • Avoid using local variables in your Select statements

    People are always surprised when I tell that their queries will run slower when they use local variables in their queries. Let me explain: If you use a local variable in a query predicate instead of a parameter or literal, the optimizer resorts to a guesstimate for selectivity of the predicate. Use parameters...
    Posted to MS SQL Admin (Weblog) by Eric Vaillancourt on Sat, Mar 29 2008

  • Understanding SET STATISTICS IO and SET STATISTICS TIME

    Today, I want to talk about two commands that are often overlooked. SET STATISTICS IO and SET STATISTICS TIME these two commands are very useful when comes time to tune a query. Tuning a query seems simple enough. In essence, we want our searches to run faster. When I teach my class on “Optimizing SQL...
    Posted to MS SQL Admin (Weblog) by Eric Vaillancourt on Sun, Mar 23 2008
Page 1 of 1 (7 items)
©2008 SQLProf.com & Eric Vaillancourt
Powered by Community Server (Non-Commercial Edition), by Telligent Systems