Reputation
2,126
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 14 32
Newest
 Yearling
Impact
~169k people reached

Feb
20
awarded  Good Question
Feb
9
comment Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
It's been a couple years since I posted this... but I just wanted to let you know. I still use the term "imperfectly understood" all the freaking time, and I always think of Paul White when I do. Makes me chuckle every time.
Jan
20
awarded  Taxonomist
Dec
12
awarded  Self-Learner
Sep
30
awarded  Explainer
Sep
25
comment Identifying if spid on SQL Server is in rollback after low disk space
Further, the total reads keeps climbing and the duration reports all the way back to the original statement (16 hours now and over 8 billion reads) wow.
Sep
25
comment Identifying if spid on SQL Server is in rollback after low disk space
Thanks for the link... that lines up with what I've seen - which reinforces why I think a rollback due to disk space and a rollback due to being killed don't report the same. I listed the results of your recommended query. It's interesting to me that it has 2 open transactions.
Sep
25
comment Identifying if spid on SQL Server is in rollback after low disk space
spid: 56, reads: 66280626, writes: 44150147, last_wait_type: PAGEIOLATCH_EX, wait_type: PAGEIOLATCH_EX, wait_time: 568, open_resultset_count: 1, open_transaction_count: 2
Sep
25
asked Identifying if spid on SQL Server is in rollback after low disk space
Sep
10
comment SQL Server Core - Installed SQL Server features
More info on what @KenWilson is suggesting: msdn.microsoft.com/en-us/library/ms143702.aspx
Jul
9
comment What is the proper way to store a full table of data outside of a database? It needs to be able to be restored as well
Good idea scripting out schema as well.
Jul
8
comment Why is this simple join taking so long?
You say it has "lot's of indexes". But, does it specifically have an index on just page_views.itemId and playpack_media.media_Id? How about page_views.started_at? I'm not a MySQL guy, so I don't know how to interpret the DESCRIBE result.
Jul
8
answered What is the proper way to store a full table of data outside of a database? It needs to be able to be restored as well
Jul
2
awarded  Curious
Apr
27
awarded  Yearling
Apr
23
revised
added 394 characters in body
Apr
23
revised
added 117 characters in body
Apr
23
accepted SQL Server Audit Specification - filter DML by all but one user
Apr
23
revised SQL Server Audit Specification - filter DML by all but one user
edited title
Apr
23
wiki