I have used the Sybase...

Thanks Gail, I have to say I didn't know that about the dmv.

I have always been told to try and get a cluster which best suits the business, but I...

The wizard will put 5 source & destinations in to 1 DFT, but from what I know, you can only do 1 table between a source and a destination, should...

The first thing you need to do is create a clustered index, take a look through sys.dm_db_missing_index_details for a list of indexes which SQL thinks you would benefit from, but...

Thanks Gail, I missed that.

Looks like a clustered index is needed to switch it from a heap to a tree.

Just to decide which columns the clustered index is better suited...

Not a problem, always glad to help someone in need if I can.

Thanks to Gail as well, I should of mentioned that 1 is a stupid number to shrink to...

most of the documentation says if fragmentation is less than 30% then a reorganize is the way to go and if its above 30% then rebuild

what is the page split...

its six of one, half a dozen of then other, wizard or code, entirely up to you. personally I like to do things in code, that way I kind...

you will have to use a shrinkfile command to reduce the amount of space the transaction log is using.

so issue sp_helpfile in the db, copy the name of the ldf...

are the databases in full recovery mode?

if so, do you need them to be in full recovery?

if you do need them in full recovery then you need to start taking...

either change the column so that its the same as the original column being imported, or convert the value on the insert, but make sure that when you convert that...

there is a tool from Quest which is freeware and allows you to scan the network, but you need to know IP ranges, what you think default passwords would be,...

In all of my professional experience, we as DBA's have always been given a blank bit of tin, we install the OS, SQL, patches etc.

The only exception to this is...

You would want to do something along the lines of this

--CREATE A NEW BLANK DATABASE

CREATE DATABASE [bcdata_restored] ON PRIMARY

( NAME = N'bcdata_restored', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\bcdata_restored.mdf'...

if you still post the results of sp_helpfile, i will build you a script which restores to a different database and location, that way you can play about with it...