276 reputation
110
bio website
location
age
visits member for 2 years, 7 months
seen Oct 16 at 16:50

Sep
23
comment Does cmdexec have additional process isolation beyond cmd.exe?
Accepting this as the answer. The big picture is that CMDEXEC is a WinAPI call that behaves a certain way. It's entirely different than starting a command shell.
Sep
23
accepted Does cmdexec have additional process isolation beyond cmd.exe?
Aug
25
awarded  Popular Question
Aug
13
asked Does cmdexec have additional process isolation beyond cmd.exe?
Aug
5
comment How to extend the Central Management Server in SSMS?
A good reference, but it doesn't have any detail about the CMS.
Aug
4
asked How to extend the Central Management Server in SSMS?
Jul
16
awarded  Popular Question
Jul
10
asked Sysadmin tools for SQLAnywhere
Jul
2
awarded  Curious
Mar
27
comment How to analyze incoming DML in SQL Server 2005?
The timing is extremely variable. I may have to leave it running overnight; that's why I want minimize the impact.
Mar
27
asked How to analyze incoming DML in SQL Server 2005?
Dec
29
comment SQL Server not properly using memory?
As to the other point, I do not mean that SQL server has access to some special API. I mean that in anything more than a low-end environment, the expectation is that you will be managing memory and storage in a much more aggressive and hands-on way than a typical app would. It will be up to the DBA to determine what is best, not the operating system. This is not the case with something like Exchange Server. OP had an expectation of SQL server behavior different than what was observer.
Dec
29
comment SQL Server not properly using memory?
OP said his intent was in-memory analytics, not OLTP.
Dec
17
answered SQL Server not properly using memory?
Nov
19
awarded  Tumbleweed
Jun
12
accepted 'skip rows' in a flat file source does not work as advertised
Jun
12
comment 'skip rows' in a flat file source does not work as advertised
Not sure which you are referring to here. If I add two delimiters to the blank line, the source succeeds, meaning it is validating those rows, even if it intends to skip them.
Jun
12
comment 'skip rows' in a flat file source does not work as advertised
I can't do anything in the dataflow, since the source source fails validation.
Jun
12
revised 'skip rows' in a flat file source does not work as advertised
added 230 characters in body
Jun
12
comment 'skip rows' in a flat file source does not work as advertised
I think the meaning of that is 'don't validate at design time'. The validation still happens at execution and apparently that includes the first few rows of the data, including the ones I wanted to skip. In any event, I still have the error after trying it both ways.