Reputation
1,931
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 12 29
Impact
~138k people reached

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
Apr
23
suggested approved edit on sql-audit tag wiki
Apr
23
suggested approved edit on sql-audit tag wiki excerpt
Apr
23
asked SQL Server Audit Specification - filter DML by all but one user