recommandation for implimating views and trigger | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

recommandation for implimating views and trigger

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"
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.
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>
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
]]>