James

Age: 36

DBA/developer. Mostly SQL Server. Ex-sysadmin.

May
18
awarded Excavator
May
18
revised How to check if SQL Server Agent is running
Updated case of 'master' so that this won't fail on a case-sensitive collation
May
18
revised How to check if SQL Server Agent is running
Corrected case of 'master'. May seem trivial but otherwise the query will fail on a server with a case-sensitive collation (e.g. SAP).
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
22
comment ggplot graphing of proportions of observations within categories
Thanks, this is a very good but also very simple answer that should help a lot of people who are confusing themselves and overcomplicating things (like me just now).
Mar
18
comment How to interpret values of Perfmon counter Hyper-V Hypervisor Virtual processor\CPU Wait time per dispatch
Thanks David. I was thinking I could do something like this but got thrown off by the 'per dispatch' part. Does this imply I need to know how many dispatches there are before I can convert this to a percentage of time?
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
17
revised How to interpret values of Perfmon counter Hyper-V Hypervisor Virtual processor\CPU Wait time per dispatch
Removed sentence with bad reasoning
Mar
17
asked How to interpret values of Perfmon counter Hyper-V Hypervisor Virtual processor\CPU Wait time per dispatch
Mar
15
awarded Supporter
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
1 2 3 4 5