The Database log will show users, however its hard to work with so I suggest something else. Remove all all individual users and replace them with active directory groups....

if you are going the VM route, search the web for best practices for the VM vendor for SQL, for instance: http://www.vmware.com/files/pdf/solutions/VMware-SQL-Server-vSphere6-Performance.pdf

I'd stop using VS 2010 altogether.

Here is the link to download SSDT-BI templates for Visual Studio 2012, its a different product:

Update, if you are using SQL Server Business Intelligence...

If you have multiple databases you would naturally have less data in each. Also, the common database with the IF statements and schemas will require more indexes.

As...

Don't dismiss this too quickly, you may be able to eliminate the need for manual stats work altogether. Just sayin.

Good luck

You seem like you may be new to the role, possibly an "accidental DBA."

While most answers in DBA land are "Maybe," if you are not really at the level to...

Open SSRS and browse to the data source. Rename it. View dependent items and check a few to make sure it worked. If it didn't work, rename...

I give about 2gb to windows by setting the max memory setting. SQL is designed to use all available memory, and giving it as much as possible is a...

DBCC CheckDB operates on an internal snapshot of the database created when the command is executed, so it is highly unlikely to be the problem.

What is the size of the...

From what I have seen, if the report has been fast (in SSRS) and now suddenly is slow (still in SSRS) then an index has become too fragmented or statistics...

Is your service account locked?

net user TheAccount /DOMAIN

I suggest they start using SSDT and allow you to re-publish their stored procedures from the database project, or use the compare functionality to synchronize to their SSDT project.

Its possible,...

Multi-tenant usually means there is some requirement for separation of data. If you have to do that, then you should look at using a source control system and separate...

Search google for Database CASE tools. There are some available as google apps. http://erwin.com/products/ is popular

What are the row counts of the affected tables? If the tables are large, and the rows changing are under certain threshold (20%?) then stats may not auto-update. ...