Use dynamic SQL to build a string based on the other table, then exec() it.

Use the @attachments parameter. The files need to be on the local disk drive of the SQL Server.

I believe master can only be put into single user mode with the startup parameter.

What's the growth parameter? 10%? Is 10% > 63G?

That might be it. The other issue could be that that particular file in a filegroup is full, but the other files...

No good way. That's what the constraints are there for. You can script them out and drop them, reload, then recreate them.

As someone that's had about 20 interviews in the last 6 years, I can tell you that I've seen DBA salaries as low as 65k and as high as 95k...

All 4 answers are definitely not correct. Each database instance DOES NOT have it's own tempdb. Each database on a SQL Server shares one tempdb. There can be multiple instances...

What everyone has presented is valid. However the question wasn't "how do I solve this", it was a "identify the problem". tempdb being shared is the problem, the solution could...

I disagre, the question states that there is "contention".  It says:

you have a number of databases making heavy use of tempdb on your SQL Server 2000 server, which is...

I think there are definitely some great leaders and those that build companies. But lots of business is luck, it's timing, it's taking advantage or being able to take advantage,...

I'm a little torn here. A SQL Server 2000 instance is an instance of a database server. Maybe it's semantics, but each instance is a server. The confusion above seems...

I think it's a great question. If you are presented with any question in an interview it won't be with a complete understanding of the situation. That's why you ask...

It's a bug, but we're rewriting the aritcle stuff, so be patient.

It appears from my testing, that if a create table is in the sproc, the grant execute does indeed create those permissions. I setup a simple sproc to create a...

You only need the SP for the SQL Server for the base product. The MSDE one is for MSDE installations only. The AS one is for the Analysis Services product...