I got it wrong... but for a different reason. The question said to pick 4, I probably would have picked all of them otherwise, since I know SSRS Report...

While it would be nice to have a format that meets all of Phil's expectations, I don't know how practical it would be for vendors to create and support such...

I selected 2 because that's what our RAID 10 arrays actually are, 2 disks, on our SAN, oh well 😉

Indexes in Oracle don't quite work the same as they do in...

Thanks for the feedback folks. In my previous attempts I had copied the service pack install file to the C:\ drive of the individual nodes to avoid any network...

Steve,

Yes, out of despiration yesterday I did try running the service pack on the active node and it looks like it got stuck at the same point:

2011-01-16 10:30:39 Slp: v:\32cf33b380ccdcc7d679ca\x64\FixSqlRegistryKey_x86.exe...

In my previous life as an Oracle DBA / Developer, I think I understand this question better than people with just a SQL Server background. Other database systems have...

Actually I have a few other concerns with these scripts:

- unicode columns will show up as double length, and numeric columns will be unobvious because the max_length column used...

While I've never quite worked with anything as drastic as the "One True Script" described here, I have seen some pretty odd things, including a software company who's new client...

Unfortunately it is possible for TempDB to not be in simple recovery mode. Where I recently started as the DBA, they have an instance where someone in the past...

On the software side I'd have to say it's the office suite. Doesn't matter to me if it's using MS Office at work, OpenOffice at home, or any other...

Having been a database professional for almost 16 years now, it seems the vast majority of that time has been spent dealing with or fixing those corners that other people...

yep it is too early in the day, I've got to stop answering these before I've had some caffiene 😉

I think the problem the SQL Server team at Microsoft has had with deciding what features to put in what tool could be partly because of the way so many...

I typically just use a bunch of UNION ALL statements in my script building scripts