If your table is in a file group with multi files, the Extent Scan Fragmentation does not reflect the real fragmentation. You can ignore this value.

In your database, are all objects owned by one owner e.g. dbo?

In your webapp, does it only call SPs?

If both are true, you can find all the SPs called by the...

You can turn on the following trace flag

DBCC TRACEON(3605)

DBCC TRACEON(1204)

Next if dead lock happens again, the deatil inforamtion about involved resources will be logged in error log.

You have to redo the transactions that after the update statement manually, i.e. re-enter /modify the data from your client app.

Don't know too much about your business rule. But the following works. You just need to use different FK name for the two references. And based on your information, your...

If the databasse always hang in the same time everyday, there may be some SQL jobs or windows tasks running around that time and caused the issue.

Try this:

SELECT accountID

FROM accountsTable

WHERE archived = 0

  AND accountType = 1

  AND     createdByUserID = 1000251

UNION

SELECT accountID

FROM accountsTable

WHERE archived = 0

 ...

It's too early to talk about any solution without knowing the root cause of the issue. As Ray said, you need to know what action(s) is slow, insert or query (no...

There is a good article about this for SQL 2000. http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp

Maybe it can help.

"General network error. Check your network"

When SQL profiler or SQL Analyzer lose its connection to sql server, it will report this error. It does not matter the server is on...

Yes. You can create indexes on views in SE. But you have to use it in the query directly with the NOEXPAND hint.  For EE and DE, you do not need to...

You are talking about two types of users. One is sql server user (login), another is your application users.

Your app user information can not captured by sp_who2 or even sql...

It's a best practice to always explicitly give the column names in the select and insert statement.

Though you checked everything, either the column order of the table is chanegd or...

No. Indexed view is supported in enterprise and developer edtion.

There is a way to do this:

master..xp_cmdshell N'isqlw -S YourServer -d Master -E -i "FullPathScriptFileName" -o "FullPathOutputFileName"'

FullPathScriptFileName is the script file. The result is in the FullPathOutputFileName.

The drive and file...