This should get you started.

declare @sql varchar(max)

select @sql =

'

declare @t table ([objectname]NVARCHAR(1000), seq int not null identity(1,1) primary key clustered )

'

select

@sql = @sql +

'

insert into @t ( [objectname] )

select...

AK = Alternate Key

When the primary key is clustered, table scans are actually scans of the primary key leaf level. It is still a table scan.

I agree that it is better to create you own names, instead of letting the system generate them. In addition to the problem with database compare, there is also...

You should be able to find that information in the default trace.

Check SQL Server 2005 Books Online for information on the default trace.

If you are really valuable to the organization, you should make a point of taking a long vacation every year so that people have to get along without you.

"I’m off...

The cost and benefit of an index is extremely hard to calculate.

Assuming all resources have a cost, adding an index will consume more disk space($) but can reduce disk IO($),...

It is usually much faster (least downtime) to do it this way:

Make a backup of the source database while the source system is still live.

Restore to the target system with...

Process is good as long as it is designed to help get things done, as opposed to being designed to keep things from getting done.

The system time should not...

That is actually an ordinal date.

http://en.wikipedia.org/wiki/Julian_Day

"The Julian day or Julian day number (JDN) is the number of days that have elapsed since 12 noon Greenwich Mean Time (UT or TT)...

As long as it didn't happen too long ago, you should be able to find that information in the default trace.

Check SQL Server 2005 Books Online for info on the...

Plenty of good scripts on the link below, especially the ones where Author = Michael Valentine Jones 😎

Script Library

http://www.sqlteam.com/forums/forum.asp?FORUM_ID=11

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

When your application allocates temp tables at a extremely high rate having more data files in tempdb can help.

There are internal data structures in tempdb data files that can become...