Viewing 15 posts - 1,081 through 1,095 (of 9,703 total)
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 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
Given your reply, it makes sense to batch reports that are logically close to each other, but I would still look at (if you can) report size and use that...
March 10, 2017 at 4:27 am
Viewing 15 posts - 1,081 through 1,095 (of 9,703 total)