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

Jul
12
comment Overcome MERGE JOIN(INDEX SCAN) with explicit single KEY value on a FOREIGN KEY
Would you oppose disabling page locks in cases where the deadlocks happening upon foreign key validation involve page locks? For example, would disabling page locks be generally unlikely to help in such a scenario, or likely to cause new problems?
Jul
9
awarded  Famous Question
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