Thanks I got your point..Indeed it is having only 2 page table .

i have other table also they were having more than 1000 rows and having clustered index and page...

do you want this

select RIGHT('0'+CONVERT(VARCHAR(2),month(GETDATE())),2)

Hi

I am not getting your question exactly

but do you want this kind of thing

select * from database1.sys.tables

where name not in (select name from database2.sys.tables)

I would say yes you have to rebuild your index after sync dome with server.

Updating table which is having cluster index may face this problem batter to rebuild index once...

U can get rough estimation from

dm_db_index_usage_stats or sys.dm_db_index_usage_stats

depends that you have indexed table

This is ok to me still at the end all depend on ur project requirement and DB requirement,u need to modify as per that only.

but If performance is in concern then go for

select CandidateID, max(YourDateColumn)

from YourTable

group by CandidateID

Add alias name to query like C(or any else ) then try

SELECTL01, LO3, COUNT (*) Counts

FROM(

SELECTA.L01, A.L03, A.L39, B.A04, B.A10, B.A31

FROM[LEARNER_SN05]AS A

INNER JOIN(

SELECTL01, L03, A04, A10, A31

FROM[AIMS_SN05]

WHEREA04 <> 35

ANDA10...

First find fragmentation this query helps you

select a.*,b.AverageFragmentation from

(

SELECT

tbl.name AS [Table_Name],

tbl.object_id,

i.name AS [Name],

i.index_id,

CAST(CASE i.index_id WHEN 1 THEN 1 ELSE 0 END AS bit) AS [IsClustered],

CAST(case when i.type=3 then 1...

I am not getting you.. will you provide some schema of table and sample data and what you

want (result data).

which help us for proper answer

Whats current Log size? and database size?

if its showing Inrecovery then wait for some time let database recover and then shrink database log file or change recovery mode to simple...

What is ur "OrganizationID"(Keys,Constrain)...can you provide script of Organization table.

try this link

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/rowset-string-concatenation-which-method-is-best.aspx

it will consider "older than the 22nd October(today's date) to be 'minus one month'".

true,

it's all depend on what result you want from query.