Reputation
1,004
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 9 22
Impact
~53k people reached

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
Feb
1
comment Why the simple insert into query allocated a lot of tempdb?
The unit is 8KB pages. sp_WhoIsActive is getting tempdb_allocations from the *objects_alloc_page_count columns in sys.dm_db_task_space_usage and sys.dm_db_session_space_usage. And you can probably get a better answer to the rest of your question if you post the CREATE TABLE statements along with the execution plan.
Dec
31
comment In SQL Server, can I guarantee an order without an explicit ORDER BY clause when an index seek is forced on a table with only a clustered index?
Tangential question: is there any performance or functionality benefit to having SELECT NULL vs SELECT * or SELECT 1 etc on the subquery inside the EXISTS condition, or was SELECT NULL chosen only for clarity?
Dec
30
comment Secondary Clustered DTC will not work when Primary goes offline - SQL Server Issues
To answer your other question, yes, if you wanted to make SQL Server automatically use DTC2 if and only if DTC1 failed, you'd have to delete DTC1 as well as any mappings of the SQL Server instance to DTC1 and make sure DTC2 is next in the order of evaluation listed in the documented I linked to. But I don't see any advantage in doing this versus using local DTC instances or configuring a DTC instance in each SQL Server group. With either of those options, Windows can be configured to bring up MSDTC if it fails, and you don't have to deal with telling SQL Server to use another DTC instance.
Dec
30
comment Secondary Clustered DTC will not work when Primary goes offline - SQL Server Issues
Yes, if a node failed, all resources from the failed node should come back online on the other node, and DTC should resume working.
Dec
30
revised Secondary Clustered DTC will not work when Primary goes offline - SQL Server Issues
Formatted list so that it doesn't appear as a run-on sentence