The constraint is declarative and is portable to other ANSI compliant database platforms.

The index is a physical implementation which may or may not be portable to other RDBMS's.

Reasons against a clustered index:

- Fragmentation. If the indexed column(s) are subject to updates this can cause page splits & fragmentation.

- Size of non-clustered indexes. Every key value in the clustered index...

>>To a user, they don't want to see the word NULL!

Of course not ! That's why it's called the 'presentation' layer.

The value is unknown/indeterminate, so you you 'present' it to the...

Is this on a busy server, with other processes using tempdb at the same time as this query ? Consider creating the #temp table, then inserting into it, instead of...

Difficult to answer without seeing the offending query(s).

What does QA tell you when you analyse the query ? Is it table scanning this table ? are statistics up to date...

Sql Server has different syntax than MS-Access.

Try:

UPDATE Table1

SET Saved = 1

FROM Table1

INNER JOIN table2 ON Table1.PrimaryKey = Table2.PrimaryKey;

You can only update 1 table at a time, so you'll need...

>>ISNULL(CI.InsuranceStartDate, '00-00-00') AS 'InsuranceStartDate'

'00-00-00' is not a valid date. You have 2 choices:

1) Return the column as a varchar in the result set

ISNULL(Cast(CI.InsuranceStartDate As varchar), '00-00-00') AS 'InsuranceStartDate'

2) Choose a...

I have also run across this and gave up on fixing it. There are articles out there that explain what causes it - can't recall, but it can happen if...

Also ...

>>it shows that the non sql server page faults are average 1321 a second!! 

What switches are in effect in your server's BOOT.INI file ? Looking for info on...

Given the complexity of the expression, you might consider creating a UDF for it. In a UDF, you can assign results of the 1st CHARINDEX() to a locally scoped variable,...

SUBSTRING() function is equivalent to Mid()

 AND         order_date BETWEEN ' + @startDate + ' AND ' + @endDate + '

 You aren't single-quoting your dates.

Anytime you have a problem with dynamic SQL, PRINT it instead of EXECuting it...

>>What is the proper way to use a prepared statement across multiple threads?

What are you using for data access. Since it's Java, can we assume JDBC ? If so, are...

You could continue concatenating as now, and wrap the completed string in a coutple of calls to REPLACE() that replace any occurrence of 2 spaces with 1 space. The number...

Personally, I'd be asking for a refund of tuition fees. Any Sql Server class that doesn't start by showing your where to find & how to use the online documentation...