have you run through the reporting services configuration wizard end to end?

another factor as to acceptable loss of data and spending etc is your RTO, you need to know that with your backup routines you can recover within your RTO as...

doh, beat me to it

a bit crude, but you get the idea

create table a (a varchar(10))

go

insert into a values ('123abc');

insert into a values ('1023');

insert into a values ('12dcrttg');

insert into a values ('frtgwef');

insert into a...

Believe this to be a duplicate post

http://www.sqlservercentral.com/Forums/Topic1197945-391-1.aspx

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...