(a) ...but system databases msdb and model did get upgraded. Why?

(b) We manually upgraded our own databases, of course

(c) Since we're upgrading "our" databases, why shouldn't Microsoft upgrade "their" databases?...

Yeah, I'd forgotten we had an ad hoc "Hit Technet find out how to cluster SSIS right now" session at 3am. Tricky how the mind works...

I also have a quick...

I do not think that it's possible to lock down SQL Server AND the domain hosting it such that no one could ever access the data contained therein--and if it were...

Updating statistics had no impact, and there is a primary key on the table.

   Philip

Disclaimer: I'm 95% certain that the following is correct, but there could be aspects of the issue I haven't hit yet.

Assuming a situation where most of your text strings would...

Don Peterson, an informed and interesting semi-regular SQL Server Central writer, wrote this article (which I happen to agree with): http://www.sqlservercentral.com/columnists/dpeterson/lookuptablemadness.asp

This, and the 198 "Your Opinion" entries, will probably...

This one threw me in SQL 2000, and I'd guess it hasn't changed in SLQ 2005. You can:

 - Create a unique index

 - Create a "unique" constraint on a column (or...

Assuming:

- 1 instance of SQL server installed on the server

- An "application" uses one or more user defined databases

- You have N applications to support, where you...

Our other DBA gets to tackle SSIS. I figure the more I do of everything else, the better the chance he has of getting them usable. (We're not...

I'll vote with the "it depends" party.

I've come to think of defaults as a sign of "lazy programmer syndrome" (LPS), for similar reasons as noggin. I prefer for the application...

Bitmasking does in many ways break relational integrity, as you end up storing multiple distinct values in one column, as opposed to one value per column. (It's like Joe...

Here's a script that installs two functions in MSDB that I wrote when I got very, very tired of working with these idiot columns. The one is used to...

5 minutes seems like a long time to delete only 750,000 rows. Are the rows big (i.e., how many rows per page)? Might there be issues with having...

"JAR", did you manage to resolve this? Like you, I'm trying to link some SQL Profiler trace data with a specific job. We do not have any master/slave...

Schema locks? Temporary stored procedures? I'll have to look for those--though I've never had much luck in detecting the precence of other logins' #temp objects in tempdb. I figured that...