quote:

---

SELECT count(distinct( BINARY_CHECKSUM(*))) FROM TableName

The above did run faster at 2:20 (Jonathan's method is 3:03) however, it comes up 145 records shorter....

After creating them, you can use this on PKs:

CREATE UNIQUE CLUSTERED INDEX pk_Table ON Table(PKCol) WITH DROP_EXISTING, SORT_IN_TEMPDB

--Jonathan

quote:

---

I guess there must be some data not in the datetime format in there so will have to pick through and find...

DECLARE @d nvarchar(20)

SET @d = '21/12/2003 15:22:15'

SELECT CONVERT(datetime,@d,103)

--Jonathan

Use a temporary table instead of a table variable.

--Jonathan

Perhaps something like this:

USE pubs

go

SELECT f.Title_Id, p.Pub_Name, f.Type, f.Advance

FROM Titles f JOIN Titles c ON f.Title_Id <> c.Title_id

  AND (f.Type = c.Type OR f.Pub_Id =...

SELECT SD.Permnum AS SDPermnum, SD.Firstname, SD.Lastname, 

SD.Grade, LC.Location2, LC.LocationDesc,

TD.TeacherID, TD.Firstname as TFirstname, TD.Lastname as TLastname

FROM Student_Data_Main SD

INNER JOIN tblLocation LC on SD.Schoolnum=LC.Location2

LEFT OUTER JOIN Teacher_Data_Main TD...

With any application, the scalability curve's slope decreases as processors are added: going from two processors to four processors might increase performance by 50% and going from four processors to...

quote:

---

Well for me - I'd like my end users to learn how to use a * rather than a % for starters...

quote:

---

Thanks F...

I wonder why the different syntax between LIKE and CONTAINS. I guess LIKE is older and may eventually be replaced...

quote:

---

...btw, sorry to the original poster!

I wasn't aware of the PARSENAME function.

Sounds really handy for such situations.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

---