143 reputation
7
bio website
location Stockholm, Sweden
age
visits member for 2 years, 11 months
seen Sep 18 at 7:29

.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.


Sep
24
awarded  Autobiographer
Oct
24
awarded  Popular Question
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