Andrew Whettam (8/9/2008)

---

OS & SQL Installation RAID 1

SQL Log files RAID 1 + 0 (not RAID 5 as it has poor write performance)

tempdb RAID 1 + 0 (not RAID 5...

Hi,

yes - you can use EXECUTE AS - see http://msdn.microsoft.com/en-us/library/ms188354.aspx for an explanation

As the why the question is phrased in a rather general way - please forgive the kinda general nature of the answer - if you need something more specific please...

Does the account you are using have appropriate permissions on Master on the target server? Bear in mind thaht datareader and datawriter are not sufficient to access system sp's...

Or alternatively, you could set up an SSIS package to export "TOP 10000000 FROM " set an exported flag on these records and loop until the count on the...

Hi - are you *sure* you don't need transaction log backups? If this is an OLTP database, this would mean if you have a problem during the day, you...

Hi - that's a wide range of things to think about. What are your main aims? Are you a developer in other languages also using SQL, a new...