Viewing 15 posts - 12,781 through 12,795 (of 39,963 total)
You could call a remote stored proc and return values back. That might allow you to use OUTPUT on the remote side, and then when it returns, insert those into...
February 27, 2013 at 2:17 pm
Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link...
February 27, 2013 at 2:16 pm
You definitely will get implicit conversions, which can be a huge slowdown. I'd fix this first.
The plan shows that the inserts to the AuditLog table, and then the full text...
February 27, 2013 at 10:32 am
Great articles Gail linked to. I'd tend to do this monthly, but YMMV.
February 27, 2013 at 10:26 am
You can use PATINDEX or CHARINDEX to do this. Here's a sample: http://www.sqlservercentral.com/articles/String+Manipulation/94365/
February 27, 2013 at 10:22 am
paul.knibbs (2/27/2013)
February 27, 2013 at 10:14 am
About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.
School cancelled.
February 27, 2013 at 9:44 am
chrisn-585491 (2/27/2013)
As a developer, Microsoft has been really missing the mark. Abandoning technology they were marketing, putting a phone/web interface on the desktop, sending mix signals about OSS, etc...
I think...
February 27, 2013 at 9:44 am
GRE (Gethyn Ellis) (2/27/2013)
February 27, 2013 at 9:37 am
mark.fisher (2/27/2013)
February 27, 2013 at 9:36 am
paul.knibbs (2/27/2013)
I notice you carefully avoided mentioning Windows 8 as Microsoft's current core OS, Steve--I wonder why that was? 🙂
Nothing against Win 8. To me, it's really Win 7 with...
February 27, 2013 at 9:33 am
Are you inserting to a remote table and trying to log it locally?
February 26, 2013 at 5:00 pm
L' Eomot Inversé (2/25/2013)
No QotD yet today? Has everyone stopped submitting them?
My fault. Frazzled from a week in Seattle and a bunch of deadlines on my plate. Since I...
February 26, 2013 at 4:39 pm
Carla Wilson-484785 (2/22/2013)
February 25, 2013 at 10:16 am
I'm actually not sure. We have a few editors, and I haven't commissioned one, but I sent a note around to find out.
February 25, 2013 at 10:14 am
Viewing 15 posts - 12,781 through 12,795 (of 39,963 total)