I agree with the advice above, but you might try simplying with a view or CTE for part of the query (either with or without the stock level). Sometimes breaking...

Getting references and using your network is important, but honestly, I'm mostly with Jeff. A good technical interview and my instincts are what I mostly use.

The rule is ALWAYS "It depends"

There are print servers that overload hardware and there are SQL instances that could run alongside almost any other software.

Virtualization is about using more of...

I think Americans in general are a little arrogant, and overall, culturally ignorant. We tend to see the US as the center of the world. There's some basis with our...

I have friends running production boxes as virtual servers, but they watch the loads for SQL Server. The SQL Servers don't float and share physical resources with lower use stuff.

Other...

What is your code?

xp_cmdshell is in master, so you might need to call it as

exec master.dbo.xp_cmdshell

I haven't run them under load, but I tend to view these as Gsquared has mentioned.

I assume you mean login created. By default, only those database that have a guest user will allow the new login to access them. If you create a user (mapping...

Is it the database or the log that's growing?

You need to schedule backups for both of those regularly.

Don't give the users rights to do these tasks. By default, users have no rights to tables. If you do not use db_owner or sysadmin rights as a general rule,...

Please don't cross post. Post your question in only one forum.

You can profile at the statement level, which I think will catch statements inside stored procedures.

I'd go with Jeff's advice here. The other thing to consider is you need tempdb to be this large. Sizing tempdb depends on your application and you need to know...

Management studio doesn't create anything. It submits your code to the server, which compiles and executes it. The server process opens database files and holds them open while it's running....

You cannot move the transacitons from an LDF. That's a log file.

You'd need to do a log backup from production and apply that, but your full restore would need to...