No, not really.  That article talks about deleting row.  I'm talking about a table that has been dropped.

Where I work, I encourage people to never write a block of code which has an OPEN TRAN without a ROLLBACK or COMMIT.  So instead of this:

SELECT * FROM dbo.account...

I use the GUI from time to time in unusual cases... a one off restore that I'm unlikely to repeat.  In the case that inspired this post, I was looking...

Just FYI, worked with MS on this and they recommended Trace flag 3451, which changes the scope of the DTC transaction from per database to per instance.

I've been working with SQL Server 2017 Distributed Availability Groups and (cross domain).  I have 2 nodes in a cluster in domain A doing syncronous replication, and two nodes domain...

Do I really get to correct Steve Jones?  Nah, I must be wrong.... SQL Server 2017 doesnt strictly require WSFC for AlwaysOn AGs.  For example, on Linux there is no...

Just in case anyone ends up here in a future search, I wanted to follow up with the end result.  It turned out that I was not compariing apples to...

We have some real problem tables - in every variety... lots of records of large size/ lots of records small size/ "small" record count large size,etc.
For example, we have...

I have always set min and max to the same value... basically we are saying we dont want SQL Server to dynamically manage memory.  Basically, i'm defining a set memory...

We are not taking backups with the SAN.

These are interesting points... It is definitely possible that we are seeing SAN caching ruining our apples to apples comparison.  I'm using diskspd with the -h switch to disable caching,...