Viewing 15 posts - 1,111 through 1,125 (of 9,731 total)
Lynn,
Can you look at your XML data in the GUI to get an idea of what nodes you'll need to query and how far down in the nestings...
March 20, 2017 at 10:19 am
Ahhh. I love it when I can reuse code I wrote for an article when I have an urgent thing to fix in my environment. No writing the code from...
March 20, 2017 at 4:54 am
I use nodes because usually we're looking for specific values. Nodes works great if you need a WHERE clause to search the XML. But I'll be honest, I haven't played...
March 20, 2017 at 4:49 am
March 20, 2017 at 4:27 am
March 17, 2017 at 11:36 am
March 16, 2017 at 12:26 pm
March 16, 2017 at 10:32 am
Sigh. So my morning starts off with a Dev asking me to move code that includes some interesting data type definitions... FLOAT (without scale and precision) and VARCHAR(04) or VARCHAR(025)....
March 16, 2017 at 5:16 am
Can I just mention that having a Test database on the same server as a Production database (whether or not they are on the same instance) is a Really Bad...
March 16, 2017 at 4:35 am
March 16, 2017 at 4:31 am
March 16, 2017 at 4:25 am
March 16, 2017 at 4:23 am
Sigh. After all the futzing, it looks like my only option is to take another FULL backup with a TLOG afterwards, then restore those and hope it works this time.
March 13, 2017 at 2:17 pm
March 13, 2017 at 12:02 pm
I could use some help with Availability Groups if anyone has time to take a peek.
March 13, 2017 at 11:43 am
Viewing 15 posts - 1,111 through 1,125 (of 9,731 total)