James

Age: 36

Sysadmin (Windows, Linux) and DBA (SQL Server, MySQL).

7h
comment Using SSIS to move a SQL Server table to a specific MySQL folder
Is it possible that you have multiple MySQL installs running and SSIS is connecting to the wrong one?
12h
awarded Yearling
12h
awarded Yearling
Feb
27
revised How to debug why WAN TCP/IP throughput is lower than expected?
deleted 5 characters in body
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
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.
Feb
1
awarded Organizer
Feb
1
revised PHP database query not working
Removed sql-server tag as this is a question about using PHP with MySQL
Jan
28
comment Why would Sybase not use a functional index?
I know almost nothing about Sybase, but in SQL Server, the query optimizer won't consider indexes on computed columns and indexed views if the client has certain SET options that don't match the object definition. Perhaps Sybase has some similar rules for function-based indexes, and ACE is using different client options than Java?
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
Dec
30
answered Secondary Clustered DTC will not work when Primary goes offline - SQL Server Issues
Dec
29
comment Secondary Clustered DTC will not work when Primary goes offline - SQL Server Issues
Which versions of Windows and SQL Server? Could you also explain the intended purpose of each DTC instance? For example, do you want each SQL Server instance associated with a different DTC instance?
Dec
29
awarded Supporter
Dec
29
awarded Autobiographer
Dec
27
awarded Popular Question
Dec
6
awarded Curious
1 2 3 4 5