Reputation
1,134
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
3 10 24
Newest
 Caucus
Impact
~65k people reached

37m
revised Azure: Many Failed Login Attempts Logged
added 19 characters in body
4h
answered Azure: Many Failed Login Attempts Logged
2d
comment How is an idle SQL Server connection causing blocking?
You might find dumping the output of sp_WhoisActive to a table every 15 seconds or so more helpful than the blocked process report. @get_locks=1 will give you an XML document showing which locks were acquired and being waited for, which might give a clue about what statements were run in the idle session. @get_additional_info=1 will also give you the isolation level.
Aug
25
comment incremental update in HBase using sqoop
Is this not answered in the Sqoop documentation here?
Aug
24
comment SQL DatabaseMail smtp error 5.7.57 at one site, email works at another with the same details
Yes I believe you'll need to add @port = 587 per the information here. If that doesn't work, do you get any further details in the Database Mail log if you enable verbose logging?
Aug
23
comment Stuck in “query end” status every 5 minutes
You may want to have a look at this similar question. Your situation might be somewhat different, but the question has the sorts of details (and links to more) that you'll need to figure out InnoDB write stall problems.
Aug
3
awarded  Caucus
Aug
3
awarded  Constituent
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.