Viewing 15 posts - 10,951 through 10,965 (of 39,908 total)
The easiest way is to use a trigger and the updated() function on this field to catch changes. I'd build an audit table and record the changes there, adding a...
July 16, 2014 at 4:54 am
Checkpoints are issued regularly by SQL Server to flush dirty pages to disk. You can manually issue them as we'll.
In terms of IO, it depends on the rate of...
July 16, 2014 at 4:50 am
This shows some of the calculations used in the new and old estimators. The 2012 version is the old one:
It's not a complex calculation, but it requires a bit of...
July 16, 2014 at 2:37 am
There isn't a way to restore data without a user being locked out of the table it is stored in. The Online Restore allows you to partially restore a filegroup,...
July 16, 2014 at 12:38 am
Lynn Pettis (7/15/2014)
Steve Jones - SSC Editor (7/15/2014)
Miss me?Welcome back, Steve.
'
Thanks.
July 15, 2014 at 3:15 pm
Back now, a good suggestion.
I'll send it along.
July 15, 2014 at 4:56 am
Checking on this now. Apologies for the delay.
July 15, 2014 at 4:54 am
That shouldn't be the case. Were there multiple answers? If so, you need to include them all.
We haven't changed the QOD engine, so I doubt it's a bug. Potentially someone...
July 15, 2014 at 4:52 am
Likely it was a transient thing, or perhaps we broke something with an update.
Please report it again if it happens.
July 15, 2014 at 4:50 am
Never seen this, but now that I'm back, I'll check around.
July 15, 2014 at 4:49 am
aaron.reese (7/14/2014)
Syntax error, BLEND is no a recognised key word.Do you mean MERGE?
Or maybe he just INTERSECTs
Actually, I'm more of a NOT LIKE person at the events 😛
See you all...
July 15, 2014 at 4:41 am
GilaMonster (7/15/2014)
Steve Jones - SSC Editor (7/15/2014)
Miss me?Who are you? 😉
The absent, semi-available peon.
July 15, 2014 at 4:39 am
I don't have dates or places, but we're looking at one in the UK and one or two in the US.
As Grant mentioned, hope to list something this week.
July 15, 2014 at 4:35 am
Viewing 15 posts - 10,951 through 10,965 (of 39,908 total)