|
Comments
|
|
rock
|
|
|
Presentation cutoff prematurely.
|
|
|
Nice job--short, sweet, very helpful.
|
|
|
Good... Need more XML beginer videos
|
|
|
Did not open
|
|
|
Would have been nice to see what XML in the table does and how it is usedd.
|
|
|
Pretty simple, but it was well done.
|
|
Sara Karasik on
6/19/2009
too short. I'd like alot more about this new datatype, and how it can be used, and parsed
|
|
|
the guy is a very good, clear speaker. not to fast or slow.
|
|
|
If the table is big (too many rows) is there any easy way to get a list of all ROW(s), that fails ALTER COLUMN TO XML type. If YES, can you please let us know the command. This will help us identify the BAD rows, fix the data & then APPLY ALTER column... XML type...
|
|
|
Need more detail as you mentioned in your video how to check XML before conversion.
|
|
Carla Wilson on
6/22/2009
A tip for how to go about finding the rows that have xml errors would be good.
|
|
|
Great video, thanks for explaining how to do it and some caveats!
|
|
Scott Taylor on
9/24/2010
should also include examples for (1) timing operation against samples of full data set to convert and (2) how to work around bad data in new xml column
|
|
|
More on XML datatype please
|
|
|
next time you do a quiz at the end of a video, you may want to remove the answer from view (in this case, you asked "what is the syntax to convert a column to xml datatype" while the "alter table" command was still in view...)
|
|
|
The author just scratched the subject..
|
|
|
Would like to see a section on how to actually identify and fix the bad XML data in the TEXT field prior to altering the column type.
|
|
|
What are some techniques that can be used to clean up the format of your text data before converting to an XML column?
|
|
|
Some clues about how to identify rows with bad XML would have been helpful.
|
|
|
Short and concise which is great.
|
|
|
Didn't really address my problem: unstructured TEXT fields.
|
|
|
Didn't really learn anything here. I was hoping for methods of actually cleaning up the data or validating.
|
|
|
excellent demo
|
|
|
A bit to simple and too fast...
Maybe next time we should see a way to do the cleanup as you mentioned. If I have 1000 rows and I have to go over all of those rows and look for good or bad XML it will take me forever... we should have a script that will help doing this cleanup.
Thanks anyway.
|
|
|
like the XML education
|
|
|
good, informative
|
|
|
good, informative
|
|
|
the suggestion for evaluating the duration was a nice addition to the basic instruction
|
|
|
A bit too quick and dirty. Should have mentioned WHY you would want to convert to XML.
|
|
|
good tip
|
|
|
It would be nice if it touched on the advantages to the XML column.
|
|
|
While it can be a disk space issue and it raises the time to convert, I prefer appending a new XML column and then performing a row by row update to move the data from the text column to the XML column. This way you can identify which columns will not convert and you never grab a table lock.
|
|
|
nice video
|
|
Eric Moreau on
11/29/2011
the video is cut when it becomes intesting!
|
|
|
Even though this video talked about upgrading from sql 2000 to sql 2005, it's still applicable to 2008 / 2008 R2.
|
|
|
Unfortunately, I cannot evaluate the content because the video quality was awful
|
|
|
yes to short
why not explain abit more on the data type xml
|
|
Steve Harris on
12/2/2011
maybe mention the other video name for reference or talk about what the conversion problems could be again
|
|
Maurice Ivory on
1/11/2012
I think I understand what's going on here....Before you use alter, figure out how many rows you are returning.
|
|
|
a little simplistic
|