Viewing 15 posts - 9,586 through 9,600 (of 9,643 total)
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.
March 8, 2004 at 7:45 am
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...
March 5, 2004 at 3:35 pm
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
March 5, 2004 at 3:28 pm
This is why I like this site, I learn something new every day.![]()
March 5, 2004 at 2:24 pm
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...
March 5, 2004 at 1:31 pm
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...
March 5, 2004 at 1:22 pm
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...
March 5, 2004 at 1:07 pm
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. ...
March 5, 2004 at 1:05 pm
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...
March 5, 2004 at 10:45 am
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.
March 5, 2004 at 10:40 am
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...
March 5, 2004 at 10:35 am
I have also ordered The Rational Guide to SQL Server Reporting Services. I will post something when I have read it.
March 5, 2004 at 10:29 am
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...
March 5, 2004 at 8:12 am
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...
March 5, 2004 at 8:06 am
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...
March 5, 2004 at 8:02 am
Viewing 15 posts - 9,586 through 9,600 (of 9,643 total)