Do you mean data diagram? Click "Database" in the menu, then select "Reverse Engineer..."

Suresh

1) Defragment the indexes.

2) INCLUDE the SELECTed columns in the nonclustured indexes.

>>after some hours log file size increases about more than 2gb. Thats the issue.

May be, there are so many transactions. Check it with Profiler.

Don't shrink the log file, unless you...

select name, is_published, is_subscribed from sys.databases

BOL says:

If ALL is specified and the underlying table is a heap, the rebuild operation has no affect on the table.

Your table is a heap (= table without clustered...

Check whether there is trigger.

>> Transaction is taking more space after truncating also.

What is meant by taking more space? Does it mean log file size is same as before?

Did you shrink the log file?

Check...

The .BAK file should contain full database backup.

If it contains only differential backup, it is not enough.

Suresh

select distinct i.number, m.text1, i.name, i.date

from dbo.Main m

inner join (

select e.number, e.name, e.date

from dbo.Entries e

inner join (

select Number, max(date) as date

from dbo.Entries

group by Number

) s

on s.Number = e.Number

and s.[date] =...

select Number, Text1, [name], max(date) from

(select distinct e.Number, m.Text1, e.[name], e.date

from dbo.Entries e

inner join dbo.Main m

on e.Number = m.Number

) a

group by Number, Text1, [name]

(8 row(s) affected)

64694826363769AbdulS2007-11-28 10:10:40.457

64694826363769MariaC2008-05-06 08:26:27.553

64695495673941HillaryL2008-05-15...

Try Windows Scheduled Task.

Suresh

Yes, Enterprise endition of SQL Server 2005 supports task scheduling.

Except Express edition, all other editions support this.

Suresh

Don't work hard, work smart.

Try PerfMon

Suresh

Hi Chirag,

Run following query and see what is already exising.

select * from sys.objects where [name] = 'PositionInsert_sp'

It is not SP that is already exising. It could be a table, ....

Suresh

Thanks Gail Shaw,

The value of Readahead Pages/Sec is going above 2,000.

There are 50 DBs of different size. Max 30 GB

Not very active in the night. During non business hours also...