The ALTER answer was misleading, if not outright incorrect, because it did not spell out the required take offline, put back online steps. If that alter statement were run by...

Because the DBA knows that independent auditors will eventually catch up with him/her. Maybe not this audit...

What a great system! What are the requirements for the monitoring server and how many does yours monitor? Can it be done on the cheap with express or...

The solution suddenly came to me after I re-read this sentence: Get the "pedestal" version of the server...

GilaMonster (5/8/2008)

---

Raid type is not dictated by anyone other than the storage team. In [head office] I would be suprised if the DBAs could tell you which system was on...

Ah, well, what do I know? I'm just an ETL guy with access to the DEV databases!

I never 'select *'; whenever I want the complete contents I right click the table name and pick 'open table'. This has the added benefit of the easy 'stop'...

Since you want to select all, the lazy way to do it and remain itemized is to simply script table as select to clipboard and paste it in. This...

For best results sharing one system with 2 software packages that might have issues, VMWare is your friend.

You haven't mentioned whether this is a development/personal/business production or what installation of...

It isn't clear here what your real needs are; do you just need to look up col A on server A when loaded table b on server b and that...

I picked the 312 answer because it was closest to what I calculated and the thing told me I was wrong and that 159 was the correct answer. At...

More than 1 YB is needed, it seems to me. Since the information being stored is within the universe it is storing there must be a mechanism to denote...

I've used SQL on VM and as long as the CPUs or RAM on the host aren't oversold then it isn't too bad. Of course, it could be faster...

I should add that RAID 5 worked for me for my main DW files because I had very generous load windows of almost all inserts and very few updates followed...

I had this exact same situation when I started a job just a couple of years ago! There was a Dell 220 array with 7 disks all as one...