good stuff, we're not under the same constraints here but using this we can build a deployment pack and execute it. the way it is now it's a manual process...

yes, my PK is a generic identity/bigint column and my clustered index is the timegenerated of the event. reason i'm using a datetime column is my query looks 3 days...

it's in BOL under one of the DMV's. there should be one about CPU

i have it in my email, but can't find it in my code archive. PSS sent it...

i would add more disks

only thing we ever leave on the physical disks that host the OS are the tempdb files if we don't expect heavy usage. i had the...

do you have any database files on drive c?

and the RAID 0? is it on another channel of the RAID controller or a whole other controller?

but we did have similar...

we do this, we have a few archive databases and back them up once a month or once a quarter. the next backup is on the same tapes as the...

Profiler

A snapshot is just a select * from a table into some text files on the distributor. Going to the sub it is a bulk insert

we bought into Evault back in 2005 or 2006 and have been using it for files/exchange. for SQL we are still using Netbackup Enterprise Server with an ADIC Scalar 1000...

we do all of our backups to tape via Netbackup

we also tried EVault disk backup, but there are a few issues with it that we don't like

in the profile, specify a fully qualified smtp server name

what we did was years ago when we started changing the email system around we created an alias that points to...

1TB hard drives are pretty cheap

we use tapes and are looking to buy a LTO-4 library soon. the LTO-4 tapes are 800GB/1600GB in capacity and cost only $55 each

most of my full log issues have been because of replication. for some reason it didn't truncate the log. so the solution is to reinitialize the publication and it almost...

how big is the table, if you have a problem it may be easier just to run a new snapshot

our QA servers are usually at a higher build than production. we'll let them run a month or so and then upgrade production every few months to the build that...

we use Netbackup Enterprise Server to backup SQL, but all it does is use the MS API to run the backups to tape. same with almost every other 3rd party...