+1

I doubt if we can control this. As page split and data insertion is not always even.

refer following thread for further detail:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ed3a8e2-214f-441b-ac98-6b9aa42466c9/running-iis-on-the-the-same-machine-as-sql-server?forum=sqlgetstarted

Another good option to start with is sql or windows error log. Try to find out what kind of error message it has captured at the time of the issue...

Refer following two articles which may help you:

http://support.microsoft.com/kb/321822

http://stackoverflow.com/questions/19730218/setup-replication-on-two-database-on-different-domain

Usually collation should be same on Prod and dev. Backup of the database also contain the details of collation and while restore it will keep the same collation. The only...

First find out what are other applications are running on the server alongwith SQL Server. Than refer the Microsoft best practice document to have dedicated SQL Server database instance/server. Produce...

In your query add colum qs.database_id, next to 'SP Name' and you will be surprise to see more than one db_id and when you remove the db_id() clause it is...

After the testing you can change the compitability level of the database to 2014. Also you can use sp_help_revlogin to migrate users. There are two aproach to the upgrade one...

.MDB file is Microsoft Access database file. It could be created by SSIS package or used by SSIS package. Try to find the SSIS job which might related to this...

Thank you, Steve.

Need to go extra-mile to find correct answer. Gain something. Good one.

try this...

sp_helplogins gaurav

All tempdb files are on T: drive and guess it is on cluster using SAN. Hence it will not distribute the load of I/O as LUNs are of same group....

Any deadlock trace is on? Any information related to deadlock in sql log?

Post the result of

sp_spaceused

sp_spaceused <table_name>