network profile
| bio | website | |
|---|---|---|
| location | Stockholm, Sweden | |
| age | ||
| visits | member for | 1 year, 5 months |
| seen | Mar 16 at 5:40 | |
| stats | profile views | 9 |
.NET/C# consultant with previous VB6 experience.
Currently employed by Kentor IT.
Fun stuff:
- Performance
- User interaction / application flow
Pet project: #KOM
Some things require hard work to do. Let's roll up the sleeves and have a jolly good time.
|
Mar 16 |
awarded | Teacher |
|
Mar 15 |
answered | Database Tasks in C# |
|
Sep 21 |
comment |
Sql Server agent can not start Voting for migration to serverfault.com Besides, you might want to start by reading the message and follow the instruction. Check the event log and if that does not help you, post relevant entries here. |
|
Nov 28 |
awarded | Scholar |
|
Nov 28 |
accepted | Performance issue with xpath in SQL Server 2008 |
|
Nov 27 |
comment |
Performance issue with xpath in SQL Server 2008 I'm planning to running those queries once to build relational tables containing the data I want to search for. The reason I need speed is that we want to minimize the disturbances in our production database when we extract the data. Building an XML index takes a lot of time too. |
|
Nov 27 |
awarded | Supporter |
|
Nov 27 |
comment |
Performance issue with xpath in SQL Server 2008 You are right in that the second query uses parallelism. But I can't figure out how that could account to such big difference on my quad core machine. I edited the question with numbers from the SQL profiler, the total CPU time spent is more than 50% lower on the second query anyway. Is the lowered CPU consumption an effect of that the parallel query plan happens to be more efficient too in addition to be parallel? |
|
Nov 27 |
awarded | Editor |
|
Nov 27 |
revised |
Performance issue with xpath in SQL Server 2008 added performance numbers |
|
Nov 27 |
awarded | Student |
|
Nov 27 |
asked | Performance issue with xpath in SQL Server 2008 |
