Viewing 15 posts - 32,761 through 32,775 (of 59,102 total)
SwePeso (8/24/2011)
Also see here to remedy the encoding feature http://weblogs.sqlteam.com/peterl/archive/2009/03/05/Extract-XML-structure-automatically.aspxAnd here is how you can filter out certain nodes
http://weblogs.sqlteam.com/peterl/archive/2009/06/04/Extract-XML-structure-automatically-part-2.aspx
Thanks, Peter. I'll have a look.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2011 at 1:23 pm
LutzM (8/24/2011)
Maybe one of Jacob Sebastians Blogs can help.However, I have no idea what the performance counters will display...
But I have not seen any equivalent XQuery solution yet.
I'd already worked...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2011 at 1:18 pm
Ah... lucky me! The requirements for my task have eased up a bit. It turns out that the "data vendors" CAN provide XSD files so I'm definitely "out...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2011 at 12:56 pm
sandhya.msbi (8/24/2011)
can u explain how to create a job step by step and uses of it..
Yes, I can... but I'd just be reguritating what's in Books Online (the help system...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2011 at 11:30 am
Thanks, Lutz. I'll put a couple of samples together tonight.
Understood on the XSD schema files but the clients are actually relatively ignorant of XML and SQL. They're using...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2011 at 8:15 am
LutzM (8/24/2011)
here are some additional sources you might want to have a look at:
Peso@SSC -> a similar approach like the one R.P.Rozema suggested and
Jason Follas blog. Jasons approach is based...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2011 at 7:42 am
LutzM (8/24/2011)
here are some additional sources you might want to have a look at:
Peso@SSC -> a similar approach like the one R.P.Rozema suggested and
Jason Follas blog. Jasons approach is based...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2011 at 7:32 am
R.P.Rozema (8/23/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2011 at 7:21 am
Thanks for trying, R.P. That gives me a couple of ideas.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 10:36 pm
Greg, you'll get better and quicker responses if you format the data in a "readily consumable" format. See the first link in my signature line below for how to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 9:10 pm
henrik staun poulsen (8/23/2011)
What do you think?
I don't know why anyone would think that 0xFFFFF2D7. It's simply a negative integer.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 4:30 pm
Here's a query I wrote a long time ago that makes sp_SpaceUsed look pretty lame...
http://www.sqlservercentral.com/Forums/FindPost730149.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 4:24 pm
Stefan Krzywicki (8/23/2011)
Earthquake in CO yesterday and now one in VA that I felt all the way in Boston.
Rumor has it that it was 6.0. We felt it all...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 4:17 pm
sunny.tjk (8/23/2011)
My read permissions won't let me do that.
Why not write a view and submit it to the folks asking you to do the job so they can "promote it...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 4:14 pm
IceDread (8/23/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2011 at 4:09 pm
Viewing 15 posts - 32,761 through 32,775 (of 59,102 total)