Viewing 15 posts - 601 through 615 (of 2,038 total)
Did you try using XML as Piotr Rodak recommended?
If you look to Acitivty Monitor, which process generates the 100% CPU and what's the current action done by this process?
June 19, 2009 at 4:56 pm
Mark Chimes (6/19/2009)
My apologies. I see my connection string did not copy and paste correctly into my last post.
Nothing to apologize and thanks for this hint. I saw your post...
June 19, 2009 at 4:51 pm
cthorn112 (6/19/2009)
What if you have multiple columns with the same name in the xml file. how can those be concatenated into one field
You cannot concatenate different node values into one...
June 19, 2009 at 4:42 pm
If your query does not require to check multi-level circular loops you can do this:
SELECT
t1.*
FROM #Tree t1
...
June 19, 2009 at 4:35 pm
This part of your posted statement is not marked as deprecated. 😀
Using OPENROWSET is the absolutely correct way:
DECLARE @xml XML
SELECT
@xml = BulkColumn
...
June 19, 2009 at 4:18 pm
As first for all the non German guys and gals. From attached error message:
Der Server 'srsql1' wurde in sys.servers nicht gefunden. Pr?fen Sie, ob der richtige Servername angegeben wurde. F?hren...
June 19, 2009 at 4:15 pm
Nope. In SQL Server 2000 it was needed to use sp_xml_preparedocument to create a XML document in server memory and work with it.
In SQL Server 2005 new data-type XML was...
June 19, 2009 at 4:05 pm
May depend on some locking issues with other transactions. Try to use a WHILE loop around your UPDATE statement and work in 1000 row blocks. You can use "SET ROWCOUNT"...
June 19, 2009 at 3:59 pm
Let me tell you that you should avoid using sp_xml_preparedocument and sp_xml_removedocument. Both are marked as deprecated in SSE2k5 and much less powerful than newly introduced XML methods.
Does this fix...
June 19, 2009 at 3:48 pm
Hi Chris
Let me start with some formatting of your post to make it easier to read for me and other guys and gals here 🙂
Your expected Result:
App id ...
June 19, 2009 at 3:36 pm
Jeffrey Williams (6/19/2009)
Steve Jones - Editor (6/19/2009)
June 19, 2009 at 2:23 pm
Jeff Moden (6/19/2009)
June 19, 2009 at 10:16 am
Question to anybody with OODB experiences:
Don't they become a little bit obsolete with today's and with tomorrow's editions of OR-Mappers like (N)Hibernate and Entity Framework 4.0 (next year)?
June 19, 2009 at 9:51 am
David,
Great article!
Exactly what I'm currently looking for.
Flo
June 19, 2009 at 7:58 am
Grant Fritchey (6/18/2009)
Nope. Never mind. I was wrong (again). Showplan XML Statistics Profile does include the actual execution plan. Whew. I feel a little better now.
Just tried with Profiler:
Estimated Execution...
June 18, 2009 at 1:29 pm
Viewing 15 posts - 601 through 615 (of 2,038 total)