Good question on sysobjects table. You could also have added a distinct to the select statement, so I would only get any table having multiple constraints only once.

Question should have been "In SQL Server 2014, which of these is not a valid resource pool argument?".

That happens if you are monitoring a named instance. See my earlier post to modify the script to work in both default and named instances.

Its still a helpful script.

This doesn't work with named instances. It will if you change the where clause as follows:

WHERE ([object_name] = N'MSSQL$' + @@Servicename + N':Buffer Manager '

...

If you are using transactions, you can put the rollback statement at the beginning of the catch as follows:

BEGIN CATCH;

ROLLBACK;

SET @Result = 0;

-- re-raise the...

I think that before we get there storage/RAM on a laptop will become a moot point. We will have virtual machines in a cloud that we will access with...

I would suggest data security. If you combine that with advanced database management skills, you would become very valuable.

I don't think that anyone should be penalized for createing a QOTD even if the answer is not totally correct. At least they were contributing to the SQL Server community....

I believe that the second select statement will return 1 instead of 0 or 2.

Really critical systems: Air Traffic Control System, NORAD.

I thought I learned something, but when I ran the script, I found that my original answer was correct.

It looks like a pretty common problem. I found the following link for it. It doesn't look like anything to be concerned about:

http://social.msdn.microsoft.com/Forums/en-IE/sqldatabaseengine/thread/233da267-7d61-425e-bdce-58241a7769aa

Probably the equivilant of a DBA 100 years ago was a millwright. That was someone that built and maintained machinary for a factory or assembly line.

The statements that you provided appear to be correct. Are you sure that the set command is getting the error? Could you be assigning the PVC_APPLICATION_NAME variable...

Thanks for the information. I was not aware that you could also set the query window color through the connection dialogue box. I did discover a quirk when...