How do you know the last date/time update stats is run on a table?
The nitty-gritty is in sysstatistics. An SP that generates the output
below is my sp_newstats proc in the dba.sql file at
However you better read the Installation Guide first since other procs also
have to be loaded. A quicker way would be to use the code and strip off the
execution of sp_date, etc. that prettyprints the dates.
May 6, 2001 (08:40:53 AM)
THERE ARE 48 STATISTICS ROWS FOR 9 SYSTEM TABLES IN systatistics.
THERE ARE 4...Update stats vs. update all stats
Under 11.9.2 update all stats will build stats for all columns, even those
not used in an index, providing more information to the optimizer. It
seems like we would always want to run update stats with the all option so
that the optimizer has more information to work with. Is this valid ?? I
am wondering if I should change my update stats jobs to use the all option.
Any experiences or suggestions would be appreciated.
Jerry Horochowianka wrote:
> Under 11.9.2 update all stats will build stats for all columns, even those
> not used in...Free Online Dating For You - Love & Dating
Hi Must visit these sites!
http://free-online-da...superreview canceled: [Bug 88454] fast-update.pl: add automatic "last update time" & update whole tree : [Attachment 117305] diffs against brad-fast tinderbox to add few fixes from bbaetz
Serge Gautherie <email@example.com> has canceled superreview:
Bug 88454: fast-update.pl: add automatic "last update time" & update whole tree
Attachment 117305: diffs against brad-fast tinderbox to add few fixes from
...Last Date Updated
I am looking for a module which should show the last date the site was updated. I tried to find old topics related with this issue but the results were unrelated..
I am using DNN212. Can anyone help? I guess this module is in the WANTED list by a lot of ppl...
Thank you for your help!
nobody? i thought it was an interesting topic but..
It is an interesting topic, but the challenge lies in figuring out what updated means in the context of any number of modules. It would require a standard way for all modules to notify the core when their content has been modifi...Last Update Date?
Upon migrating PB 6.5 to PB 8, it seems the Last Update Date is set to
today's date for all functions, windows and user objects. Datawindows are
This has been true since of migrations for all versions since Last
Update Date was introduced. Not much you can do about it, except maybe
document what it was before you migrated. (I know of a tool that will
give you an easy printout of your object list, including the Last
Update Date <g>. See below.)
Terry [TeamSybase] and Sequel the techno-kitten
On Thu, 18 Oct 2001 17:07:2...Update Stats Performance
I have recently built a replacement v 12.0 ASE Server for a production
system and have found
that on one particular database the update stats run(indexes only) is now
taking approx 22hr to run whereas it takes 3.5 hrs. on existing
The config of the 2 Sybase Servers are v. similar except for EBF level, new
server is on 10456 old server is on 9625. The database in question is 10Gb
in size and has 3 v.large archive tables.
The only difference in config is that memory on new server is
substantially higher and also had to change setting ofr open objects & open
indexe...Last updated date
Is there a way to find the date a table was updated.
I can't find anything in the documentation.
Do you mean when the structure was updated or the data? There is nothing
to support the former and the latter would require you to include an
audit column of type DATETIME that is updated on each insert or update.
Jim Egan [TeamSybase]
Sybase Developers Network
This is interesting, Jim. There really isn't any statistic maintained on
when a table was created or structurally changed. This was on purpo...Last Updated Date
Does anyone know of existing code that can get the last date the page/tab/modules was updated?
Daniel StruveDotNetNuke Houston
nice addition ... currently the tab table doesn't have any created, ammended dates... anyone done this?Visit www.dnnnotes.com - index of DNN threads - hand picked quality threads.
TextLayout Module - create multiple column layouts easily
yea, Im have to customize dnn more and more. Im getting worried with the new version coming outDaniel StruveDotNetNuke Houston
I would be willing to do this, I wonder if someone with more exposure to tab settings could su...Last Contact Date Not Updating
I have three workstations where their last contact date is a few weeks
ago, essentially when they were rolled out to the enduser. However,
their last full refresh date is current; their systems were scanned by
the inventory module and last uploaded has the correct dates and times.
I'm just wondering why their last contact date is so far behind. I
know that if I don't reboot my system daily, the contact date falls
behind--for example, I haven't rebooted since 6/16, so my last contact
date is 6/16. But in this case these machines -are-
logged off and shut down every nigh...Page last updated date
Can anyone tell me how to dynamically add a page last updated date to my page footer which is in a master page ? Thanks!
This article may provide you with directionhttp://www.codeguru.com/csharp/.net/net_asp/webforms/article.php/c12301 "If you make it idiot proof, they'll build a better idiot"
Thankyou!The link you provided along with information from http://www.odetocode.com/Articles/450.aspx provided exactly the solution I needed. Regards,David.
HiThe link provided by others will work only on static page. But for pages were the data is loaded ...Indexes & update stats
I understand the table & index stats need to be regularly updated.
Is there a need to run "update statistics" right after creating a new
index? Is the stats updated automatically when a new index is created?
1. Created a new table, table1
2. Created an index on the new table
3. Do I need to run update statistics table1 ?????????
"Cecee Green" <firstname.lastname@example.org> wrote in message
> I understand the table & index stats need to be regularly ...index stats & sp_recompile
I happen to come across this, and was curious.
I can see updating the DB statistics to reflect proper index retrieval.
However, what is the "sp_recompile" function doing ?
How would a stored procedure have "compile time" access
to the array of index statistics ?
sp_recompile is flagging the sproc, telling the server to recompile the
query plan next time it is executed. Query plans are stored in
sysprocedures, the source code in syscomments.
When a sproc is compiled, it uses the current stats to create the query
plan. If the stats become outda...Date Site Last Updated
Does anyone have a module that will display the date a DNN site was last updated?JimMS MVP ASP.NET [VC++/MFC emeritus]Old Dog Learns New TricksPreferred programming language: cuneiform on clay tablets
That certainly would be a nice module, but don't see how that would be possible, unless every module included field for 'LastUpdateDateTime'. Not all modules have anthing like that info.
Hey Jim,Take a look hereDave
Thanks Dave, that looks like a useful module, but not quite what I had in mind.JimMS MVP ASP.NET [VC++/MFC emeritus]Old Dog Learns New TricksPreferred programming ...