SQL Server Performance

Search Results

Search Again
  1. Clown Kiss

    Help with an Update Trigger

    Thread by: Clown Kiss, Jan 26, 2011, 2 replies, in forum: SQL Server 2008 T-SQL Performance Tuning
    This is my Trigger: ALTER TRIGGER [dbo].[trig_onUpdateLocation] ON [dbo].[Location] FOR UPDATE AS declare @ID varchar(20) select @ID = (select...
  2. Clown Kiss

    SUM()

    Thread by: Clown Kiss, Feb 22, 2005, 3 replies, in forum: T-SQL Performance Tuning for Developers
    I'd like to return a record set that contains a calculated field in addition to all of the fields in a particular table. This is the script that...
  3. Clown Kiss

    Identity Column Usage?

    Thread by: Clown Kiss, Nov 5, 2004, 6 replies, in forum: T-SQL Performance Tuning for Developers
    I have a table that I#%92m using an identity column in. This column (ItemID) is the second column of the key (with the first being "JobID"). I#%92d...
Showing results 1 to 3 of 3
Search Again