You could save yourself a lot of heartache if you put a unique index (constraint) on team_id, player_id and season_id then you could not insert duplicates without an error.

In sql server triggers fire for a statement.  Meaning that if you insert 10 rows in a single sattement the inserted table contains 10 rows.  I am not sure what...

Here is link that explains cross-database ownership chaining and how to configure it.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;810474

This is why I like this site,  I learn something new every day.

I could be wrong here and if anyone knows let me know.  Here is how I think SQL Server works.  SQL Server is an executable that runs on Windows which...

I would consider doing what Noel suggests but I would do it explicitly in 2 transactions.  I believe that would reduce the locks being held.  I would have to guess...

I'm not sure what you are attempting here.  You should be able to point an application to the SQL Server and access the data from there anyway.  Any external storage...

Is the date field being referenced smalldatetime or datetime?  How many rows would you expect to be returned?  I would not consider 50 sec good performance depending on the rows returned. ...

Any delete triggers on the affected tables?  Have you tried using sp_who and sp_lock stored procedures to determine what process is causing the locking problems?  You may also want to try...

CharIndex(string to look for, string to search, [start position).  For example:

Select CharIndex('A', 'ABC') will return 1.  Remeber depending on your SQL server setup SQL Server may or may not be case sensitive. 

Could you post the code? 

I had a similar issue but I was passing the dates in as a delimited string and using another UDF to parse that string into...

I have also ordered The Rational Guide to SQL Server Reporting Services.  I will post something when I have read it.

Clustered indexes are the way to go when queries will return a single row.  Non-clustered indexes are better if retrieving a range of values.  I am pretty sure the clustered index actually stores...

I have never seen tables disappear with replication except once when I cancelled replicaiton in the middle of a rebuild becuase when you sleect initialize the data and schema at...

Certainly there is a valid answer to the question, but shouldn't QOD's be something that pertains to valid sql usage.  On delete and insert this trigger does nothing, but on...