don't think you can do that

RS needs the database engine because it creates two databases

why do you want to backup tempdb?

be careful of schemas, they are always looking to scheme you out of something

some transactions like index rebuilds are fully logged regardless of what your DB is set to

no, i only run index rebuilds so i don't have to worry about updating statistics

reorganize doesn't update stats, only rebuild does

i run a modified version of this and my reorganize command is set to <1

what about using db_mail? just put the external smtp server into the config

maybe it's me, but i like to only do rebuilds. i mostly support EE so online rebuilds aren't a big deal.

rebuilds also rebuild the statistics and with reorganize i have...

i don't do much ETL except for moving some data between servers, but i've started to use SSIS less and less for it and back to the old way of...

you first have to change the IP on the old server and then set up the cluster

for the cluster you will need 4-5 IP's

1 IP for each of the physical...

there is no SQL OU by default. i called mine SQL Access

we create groups and then map sql logins to those groups. then either give db_reader role on replicated copies...

when you install SQL on the cluster it will ask you for the IP. by default when you create the cluster it only creates the default cluster group. when you...

if it's an overflow my guess is that the input is too large for the output data type you are specifying. like taking a bigint and trying to put it...

i get full logs when running alter index sometimes

only solution i found is to increase the threshhold so less indexes are rebuilt

check the NTFS permissions on the drive and the files. should be full control for the sql service account. i think you also have to change a few things inside...