1,736 reputation
725
bio website
location Denver, CO
age 39
visits member for 3 years, 6 months
seen 15 hours ago

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
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
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.
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.
Nov
18
comment I Want to Become a Database Administrator - How Can I Start?
Probably right about it getting closed, but plus one until it does for giving such a thorough answer.
Nov
3
comment Change data capture - how to know who made the change?
Ahhhh, didn't catch that. I get what your saying now.
Nov
1
comment Change data capture - how to know who made the change?
That only gets you the svc account/owner of cdc, you might note that I tried those things and documented the results in my original question way back in Feb.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
We've been running CDC on an async mirror for several months. It's been working great for tbe data warehouse to query the snapshot. It wasn't until we moved the mirror partner to a new datacenter that all this became an issue. Setting up mirror and then CDC, no problem. CDC and then mirroring... not so easy.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
You know what... I just had an epiphany... do a full restore with keep_cdc on the new box. That will build cdc out, then start you multi file restore over the top of it without keep_cdc to do your point in time recovery. Ok, I'm squared away now.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
So restoring to a different database, a new database, or a database that will be a mirroring partner is still a no? I read this same article but it left me wondering about the scenarios above in a multi file scenario.
Sep
11
comment Do you know an easy way to generate one record for each hour of the past 12 hours?
Yeah for number tables - they're all the rage.
Mar
21
comment Upgrade SQL Server 2012 Express to Evaluation Edition
Yeah, sharepoint install makes it a little more fragile for sure.
Mar
21
comment Upgrade SQL Server 2012 Express to Evaluation Edition
How many databases on your express install? How much work to backup, install fresh, and restore?
Mar
8
comment Delete a variable number of records by a chronological order
Also, I was trying to get around deprecation with the sub select but it's a nil issue now. Thanks again.
Mar
8
comment Delete a variable number of records by a chronological order
Apparantly I didn't get the memo about using parenthesis. Thank you SQL2005. Awesome.