UPDATE needs to look through the table to find the row(s) that needs updating.  INSERT can just put a new row in the proper place (heap or index) without needing...

I would monitor the logs in that case.  Or long running queries.  If most queries complete in under 5 seconds, but I start seeing a large number of transactions being...

generally, when a stack dump happens, the process that caused the stack dump shuts down.  In this case, SQL Server service is likely no longer running after the stack dump...

My approach - dig into the facts before digging into possible symptoms.  Spikes in CPU don't mean there is a SQL issue.  Monitoring for spikes MAY help or may not...

I'd check in your logs to see what happened.  both windows and SQL Server logs.

A good write up on latch timeout can be found here:

https://mssqlwiki.com/2012/09/07/latch-timeout-and-sql-server-latch/

It includes some steps to troubleshoot...

There is a lot in this question.

First, a "heap" with a "clustered index" is no longer a heap.  A heap is an unordered set of data.  A clustered index orders...

Another thing to add in to what Jeff said is if you are a contractor working on this, make sure to include your support costs for if/when the application fails. ...

I started with CVS then SVN and finally to Git (via GitLab).  My opinion though, terminology needs to be standardized.  GitHub has  "Pull Request" to get the source branch pulled...

I actually really liked the uCertify course for MTA-Database Fundamentals.  That is the one I took for getting my MTA.  That being said, if you have used SQL Server for...

Possibly a dumb question, but are both DEV and PROD using the same account to run the tool that connects to SQLPROD?  I mean an AD account, not a "local...

if the ID field was an IDENTITY, you generally don't include it in your INSERT statements as SQL will auto-increment it.  If you include a value, you need to SET...

I think it depends on your workloads and environment.  For example, if you have a data mart that gets re-loaded nightly using the truncate->reload methodology, and you are doing hourly...

There area  lot that can do it I'm sure.  The first few that come to mind are SSMS and Visual Studio though.  Both of these can see all of the...

An alternate approach would be to look at the files in the file system.  If you select multiple files (in Windows anyways), it will tell you the file size.  And...

First - I'd recommend against crossposting.  I found your post on here, Microsoft and VMWare.  This is the only one with replies though.

I do not have failover clustering set up...