For technical questions about the internal workings of the database engine.
13
votes
2answers
551 views
Optimising plans with XML readers
Executing the query from here to pull the deadlock events out of the default extended events session
SELECT CAST (
REPLACE (
REPLACE (
XEventData.XEvent.value ...
11
votes
1answer
392 views
Where are Statistics physically stored in SQL Server?
Where are the Statistics used by the Query Optimizer physically stored inside a SQL Server database file and the Buffer Pool?
More specifically, is there a way to figure out the pages used by ...
8
votes
1answer
237 views
DELETE vs TRUNCATE
I am trying to get a greater understanding on the differences between the DELETE and TRUNCATE commands. My understanding of the internals goes something along the lines of:
DELETE -> the database ...
