SQL Server Performance

recommandation for implimating views and trigger

Discussion in 'Getting Started' started by sponguru_dba, May 10, 2007.

  1. sponguru_dba New Member

    Hi all

    please some body provide recommanadation while implimating Views and Triggers

    This is my New job as a DBA and new task also please don't mind some body provide the deatils

    like i know while implimanting trigger we have to put SET NOCOUNT ON like other recommandation please provide





    Thanks in Advance



    SPONGURU
    "If Iam Wrong suggest me Right"
  2. MohammedU New Member

    Implementing Triggers in SQL Server 2000
    http://www.sql-server-performance.com/nn_triggers.asp

    Tips for Performance Tuning SQL Server Triggers
    http://www.sql-server-performance.com/trigger_tuning.asp

    Views in SQL Server
    http://www.sql-server-performance.com/sm_views_in_sql_server.asp
    http://www.sql-server-performance.com/nn_views.asp

    http://www.sqlteam.com/item.asp?ItemID=1015



    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    The best option for you at the moment is to read through the books online (BOL)(updated) in order to get first hand information and clear very basic doubts or even take your time to search thru the forums (bear in mind it might timeout [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]) too.<br /><br />We all here started from scratch only and using the best available resources such as BOL and site like this you would be at better side.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  4. FrankKalis Moderator

    quote:Originally posted by sponguru_dba

    Hi all

    please some body provide recommanadation while implimating Views and Triggers

    This is my New job as a DBA and new task also please don't mind some body provide the deatils

    like i know while implimanting trigger we have to put SET NOCOUNT ON like other recommandation please provide





    Thanks in Advance



    SPONGURU
    "If Iam Wrong suggest me Right"
    Pardon, no offense here, but when you're the DBA, shouldn't you already be familiar with these concepts?
    You should really get quickly familiar with them. Use BOL for that!

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de

Share This Page