How do you know there are 113,896 records in that table?

What query gives you this number?

There is no such thing as 1st or last row in relational databases.

You need to store time of recording to know which record was the latest one.

You want to select all dates FROM WHERE?

Where are all dates stored?

select t1.col1 as t1_col1, t1.col2 as t1_col2,

from t1

left join t2 on t1.col1 = t2.col1 and t1.col2 = t2.col2

where t2.col1 is null

OR

select t1.col1 as t1_col1, t1.col2 as t1_col2,

from...

Answer in in the syntax of a query:

SELECT ...

FROM ???

Where have you "all dates" stored in?

Should we say that Yukon does the same to SQL Server?

It makes it too easy for the Java/VB/... developers or other very acknowledgeable persons to build something they can use...

Tables t2-t10 should have clustered index on first column f1 and second column f2.

'C:\Amit\Online\Online.fmt' - is this file on the server or on you local drive?

SELECT O.Name

FROM sysobjects O

INNER JOIN sysindexes I ON I.ID = O.ID AND I.indid in (0, 1)

WHERE O.xtype = 'U' AND I.rowcnt > 0

BTW, you may have 2 or more...

Very badly.

Check your function.

Probably there is a bug.

What you are getting if you are removing GROUP BY?

select dbo.GetDescription(lvl_id,6),dbo.GetDescription(lvl_id,8)

from tblHierarchy

How many Cards your system inserts per second?

Because if you've got 1 new Card per second (3600 per hour, 86400 per day) you gonna reach the limit of "int" capacity...

Based on this query you need clustered index on 2 columns: (purchaseorderid , serialnumber )

John, you're using quite freaky representation, so I doubt there is any ready made tool for this exercise.

You need to get binary string (0's and 1's), reverse it and get...

I believe you need to read topic CREATE INDEX in BOL.