Viewing 15 posts - 2,176 through 2,190 (of 2,729 total)
Gads it takes a long time for an Oracle patch to apply...
I probably could've just installed a new, updated instance by now...
October 18, 2013 at 9:09 am
You know, people may complain about the hassles of installing SPs and CUs and updating the OS of their SQL servers, but that's nothing compared to doing Oracle Quarterly patches...
Having...
October 18, 2013 at 6:36 am
Listening to commentary about the Tigers / Red Sox, they commented that it seems recently when Verlander is pitching, the offense takes the night off.
It sure seemed like that was...
October 17, 2013 at 11:12 am
Was just reading Grants' recap of the PASS Day 1 Keynote, and comparing it mentally to the recap Ozar had put up...
Might be fun to lock the two of them...
October 16, 2013 at 1:23 pm
rodjkidd (10/15/2013)
GilaMonster (10/15/2013)
rodjkidd (10/15/2013)
You up to speed yet, by your tweets sounds like a long set of flights.
Awake. Mostly. The pot of coffee that came with breakfast helped.
8 hours...
October 15, 2013 at 1:53 pm
How come, if all the smart people took today off to get a 4 day weekend where I work (we've got Monday off,) I'm still here?
Oh, wait...
I think I answered...
October 11, 2013 at 9:42 am
It's always somewhat interesting to see how long some blogs have gone without updates, yet are still around...
I was looking for information on a SSRS issue (in QA so nothing...
October 11, 2013 at 7:30 am
Yeah, the deattach and send the MDF is what's been marked as the answer.
I guess part of me is rather averse to deattach / reattach for some reason, even if...
October 10, 2013 at 7:49 am
I'm presuming that such a trigger would have better performance than the function (function has to work on every row where the computed column is selected, trigger catches the problem...
October 8, 2013 at 9:18 am
GilaMonster (10/8/2013)
A better solution might be to change the column to numeric. Or is that not possible?
That was my first suggestion, but according to the Dev, the people who send...
October 8, 2013 at 8:53 am
Once more, thanks Gail!
The Dev put together a function to check for non-numeric characters, and if found, not create the computed value. In theory, the application which uses this...
October 8, 2013 at 7:27 am
Stefan Krzywicki (10/7/2013)
jasona.work (10/7/2013)
Stefan Krzywicki (10/7/2013)
Greg Edwards-268690 (10/7/2013)
Steve Jones - SSC Editor (10/7/2013)
Stefan Krzywicki (10/1/2013)
Grant Fritchey (10/1/2013)
October 7, 2013 at 11:23 am
All hail the great and powerful Gail!
With a couple suggestions, she put me on the right track to find what was breaking an update stats maintenance plan!
Which I was then...
October 7, 2013 at 11:22 am
OK, found a better way then the cursor, and already tried it.
Used this:
select
name
, STATS_DATE(object_id, stats_id) as LastUpdated
from sys.stats
where object_id = 735341684
order by LastUpdated asc;
to see which stats hadn't been updated...
October 7, 2013 at 10:46 am
Viewing 15 posts - 2,176 through 2,190 (of 2,729 total)