Viewing 15 posts - 2,206 through 2,220 (of 2,756 total)
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
That's going to be fun...
😉
56 auto-created stats to check, plus one on the primary key. Well, no one said this job would be easy!
Hmm, time to see if I...
October 7, 2013 at 9:56 am
While I do have an Agent job that runs DBCC CheckDB once a week as well (at a time that doesn't impact any other jobs,) I'll manually run it as...
October 7, 2013 at 9:35 am
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 9:19 am
Viewing 15 posts - 2,206 through 2,220 (of 2,756 total)