5,759 reputation
1231
bio website mikefal.net
location Colorado
age 40
visits member for 2 years, 7 months
seen 27 mins ago

I am a database administrator in Denver with a passion for playing music and enjoying sake. I have 10+ years of SQL experience, 3+ of Oracle experience, and a music performance degree from CU Boulder. I also play bass trombone in a local jazz band and occasionally sub in for a couple community orchestras.


Oct
23
reviewed Approve suggested edit on Does the SQL Server backup process use a buffer cache?
Oct
14
reviewed Approve suggested edit on How To Remove Leading Characters in SQL
Oct
10
reviewed Approve suggested edit on postgresql-9.4 tag wiki excerpt
Oct
10
reviewed Approve suggested edit on Working out Duplicated Data in a Customer Data Base
Oct
10
reviewed Approve suggested edit on postgresql-9.4 tag wiki
Oct
9
comment Can not re-set [log_reuse_wait] after log back up
Checkpoints happen periodically within the database engine, usually once every minute. They will resolve this, but once transactions happen within the engine, you'll see the same message, because now there will be new transactions in the log. This is just how the engine works. Regarding size, don't focus on how much is in use at a single point in time. Certain actions (ETL, index maintenance, etc) will use more of the log when they run, but you won't see that unless you watch the log at that moment.
Oct
8
reviewed Approve suggested edit on Writing select result to a csv file
Oct
8
revised Cannot shrink transaction log
edited body
Oct
8
answered Can not re-set [log_reuse_wait] after log back up
Sep
17
reviewed Approve suggested edit on memory-optimized-tables tag wiki
Sep
17
reviewed Approve suggested edit on datadir tag wiki excerpt
Sep
17
awarded  Proofreader
Sep
17
reviewed Approve suggested edit on sql-server-core tag wiki
Sep
17
reviewed Approve suggested edit on ibm-netezza-administrator tag wiki excerpt
Sep
16
reviewed Approve suggested edit on tde tag wiki
Sep
11
awarded  Enlightened
Sep
11
awarded  Nice Answer
Sep
7
reviewed Approve suggested edit on Best practice database design - user rating tables
Aug
27
reviewed Reject suggested edit on What is an audit table?
Aug
16
reviewed Approve suggested edit on SQL SERVER 2012 Express - Can't change Thesaurus Location