| bio | website | techgineer.blogspot.com |
|---|---|---|
| location | Amsterdam, Netherlands | |
| age | 26 | |
| visits | member for | 1 year, 6 months |
| seen | May 27 at 18:51 | |
| stats | profile views | 4 |
Data Warehouse developer at Info Support B.V., with a background in Computer Science. Love to discover new things in code, platforms and more.
When I'm not working, I like playing the piano (& hammond organs - I LOVE those), spending time with friends (going out, having some beers, discussing Deep Thoughts about Life And The Universe) and travelling.
|
May 27 |
awarded | Caucus |
|
Apr 29 |
awarded | Popular Question |
|
Oct 17 |
awarded | Notable Question |
|
Sep 14 |
revised |
Running an SSIS package owned by a domain user from SQL Server running on a local service account Update in response to several proposed answers |
|
Sep 14 |
comment |
Running an SSIS package owned by a domain user from SQL Server running on a local service account @Justicator: Maybe, as a last resort. But whenever domain logins are possible, I prefer not to use SQL Authentication. |
|
Jul 23 |
awarded | Popular Question |
|
Jul 16 |
revised |
SQL Server Decimal(9, 0) vs INT Further clarified the title |
|
Jul 16 |
awarded | Editor |
|
Jul 16 |
revised |
SQL Server Decimal(9, 0) vs INT edited title |
|
Jul 16 |
asked | SQL Server Decimal(9, 0) vs INT |
|
Jun 25 |
awarded | Critic |
|
Apr 4 |
comment |
Running an SSIS package owned by a domain user from SQL Server running on a local service account Yes, but I don't know which reason (I guess something with the DTAP cycle and the domain being not everywhere available). Anyway, it's a given environment which I'm not allowed to alter. |
|
Apr 2 |
awarded | Announcer |
|
Apr 2 |
asked | Running an SSIS package owned by a domain user from SQL Server running on a local service account |
|
Jan 23 |
awarded | Scholar |
|
Jan 23 |
accepted | SQL Server Linked Server performance: Why are remote queries so expensive? |
|
Jan 18 |
awarded | Supporter |
|
Jan 18 |
awarded | Student |
|
Jan 18 |
comment |
SQL Server Linked Server performance: Why are remote queries so expensive? Using a temporary table works right with 54 rows; but in cases with large tables on both sides it isn't feasible anymore. What would your solution be for two equally-sized "huge" tables? Creating a UserTable, in another database? |
|
Jan 18 |
comment |
SQL Server Linked Server performance: Why are remote queries so expensive? Ok, so it has high startup costs to set up the connection. The query needs to be sent, processed remotely (no network needed for that one), and finally the results sent back and processed. But it won't take minutes to send data over a network connection, will it? |