1,756 reputation
725
bio website
location Denver, CO
age 39
visits member for 3 years, 7 months
seen Nov 21 at 4:23

Developing, modeling, administering, tuning, troubleshooting, extracting, transforming, and loading databases full time since 1996.

First professional assignment with databases began building CAClipper xBase applications back when a database with 2 million plus records was considered huge. Moved to FoxPro and Borland Visual Delphi in the mid 90's and then SQL Server in '98.

Have also worked with Sybase, MySQL, Oracle, Access, Multivalue Informix, Filemaker, 4D and the Microsoft BI stack.


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 sql-audit wiki description
added 394 characters in body
Apr
23
revised sql-audit wiki excerpt
added 117 characters in body
Apr
23
accepted SQL Server Audit Specification - filter DML by all but one user
Apr
23
comment SQL Server Audit Specification - filter DML by all but one user
Totally get what your saying... but if I can make them happy without having to buy another TB of storage to hold the audit data I would rather. Thanks for info.
Apr
23
comment SQL Server Audit Specification - filter DML by all but one user
Back to original question... so, that's a no then :)
Apr
23
comment SQL Server Audit Specification - filter DML by all but one user
The auditors don't care about what DML the application is doing - only people logging directly into the server. We have controls for storing the service account passwords away from users - managed by security team. So, auditors don't want it - we're going to filter it to report on it - why store it at all?? A year worth of DML on this application would be a HUGE amount of data. Don't get me wrong - I get your statement... but this approach makes the auditors happy.
Apr
23
revised SQL Server Audit Specification - filter DML by all but one user
edited title
Apr
23
wiki created sql-audit description
Apr
23
wiki created sql-audit excerpt