Reputation
1,024
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 9 23
Impact
~56k people reached

May
15
comment The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT'
@DanielHutmacher Interesting. I'll repro sometime and post an answer if I find anything useful.
May
13
comment The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT'
It might also be interesting to see what happens if you try manually merging the XTP checkpoint files with the stored proc sys.sp_xtp_merge_checkpoint_files (example here).
May
13
comment The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT'
Hi Daniel, is there anything in the error log similar to the messages in the link Kin posted? It's probably obvious, but I would also check free disk space on the volume holding the in-memory OLTP filegroup.
May
11
awarded  Famous Question
May
5
awarded  Nice Question
Apr
6
awarded  Popular Question
Mar
27
comment Permissions for executing subscription in SSRS
I've considered it but am not sure how practical it is. They'd need to write a query that checks whether the ETL is completed, but guarantee that the subscription only fires once per day right after the ETL completes.
Mar
27
revised Permissions for executing subscription in SSRS
added 122 characters in body
Mar
27
asked Permissions for executing subscription in SSRS
Mar
17
comment any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server
The innodb_flush_method documentation doesn't explain, but I'd guess async_unbuffered means InnoDB on Windows is opening the files with the flags FILE_FLAG_NO_BUFFERING (for unbuffered) and FILE_FLAG_OVERLAPPED (for async I/O). That is how Windows-oriented RDBMSs do I/O and should avoid any double-buffering of the I/Os in Windows. Personally I'd avoid MySQL on Windows because it's developed, tested, and run largely on UNIX & Linux and MySQL experts are in the UNIX/Linux space. So I agree that you should definitely NOT USE WINDOWS for MySQL, though I'm not sure if your reasons are correct.
Mar
6
revised Is sys.stats_columns incorrect?
added 1 character in body
Mar
6
revised Is sys.stats_columns incorrect?
added 1 character in body
Mar
5
comment Is sys.stats_columns incorrect?
@MaxVernon, swashesk has filed one here
Mar
5
revised Is sys.stats_columns incorrect?
added 418 characters in body
Mar
5
revised Is sys.stats_columns incorrect?
added 1475 characters in body
Mar
5
asked Is sys.stats_columns incorrect?
Mar
3
awarded  Yearling
Feb
1
awarded  Organizer
Feb
1
revised Getting sum result for last year divided quarterly
Removing sql-server tag as this is PL/SQL
Feb
1
suggested approved edit on Getting sum result for last year divided quarterly