be aware that a field in a table can have a different collation than the default collation for a database.

1) find the query/command causing the trouble

2) check all the fields and their...

move the "AND weeklyuserscores.weeknum = 2" to the left join clause, otherwise it will be filtered out.

SELECT

    users.username

    ,weeklyuserscores.score IS NULL AS Score

    ,weeklyuserscores.absolutevaluescore IS NULL AS AbsoluteValueScore

    FROM users

    JOIN groupmembers

    ON users.ID...

Hello,

What kind of technology do you use ADO,DAO?

Anytime my passthrough gave an error Access notified me, unless on error resume setting is on. (in order to process the error in...

Could it be that the saturday backup job is still running because of the ongoing stored procedure?

Are you taking 2 full backups on saturday (one regular, one stored procedure after...

Hello

1. Are there any db parameters for configuring # of processes for the db, simultaneous sessions per user, idle_time for a session etc.

->So far I know this is a...

You can compare the execution plans with query analyzer. (Show (estimated) query plan.

I guess with literals the optimizer immediately figures out is it one date (index seek), with variables an...

declare @datelast datetime

declare @dateprevious datetime

set @dateprevious='20070101'

set @datelast='20070102'

/*find items that are in

inventorylast but not in inventoryprevious

*/

select inventorylast.SKU

,inventorylast.qty int

,inventorylast.invdate

from inventory inventorylast

where not exists

(select 1 from inventory inventoryprevious

where inventorylast.sku=inventoryprevious.sku

and ...

Probably needs some refining since you use dateadd

declare @datestart datetime /*start of period*/

declare @dateend datetime /*end of period*/

set @datestart='19990906'

set @dateend = '19990917'

select roomnumber,rate

from room /*check al rooms if in not...

Always mention the column names when inserting. In case someone decises the names have to be alfabetically sorted.

insert into Sep_92 (Regno,Payment) values (19,'2005/12/05')

You can rebuild indexes with DBCC INDEXDEFRAG OR DBCC DBREINDEX

Shrinking parts of the database can be done with DBCC SHRINKFILE

It is fine to have primary keys with "no meaning". Mark the other unique fields with unique indexes/constraints and eventually a foreign key so later on you still will able...

my guess is an entry in the param.txt file

microsoft released an update of SQLIOStress called sqliosim: http://support.microsoft.com/kb/231619

clustered indexes are more suited to range-seek (like date ranges). (benefit of having a sequential IO feed because the data is ordered sequential). If you only fetch 1 item at...

You could try this with the BULK INSERT command depending on complexity.

You can perform a transaction log backup. It automatically truncates the inactive portion of the transaction log.