Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2014-07-16 : 01:10:07
|
Good day. Tell me how to calculate the tables in which, for example, there is a record for the last 20-30 minutes? The database consists of tables, functions, triggers, and ensures that itd program for the design of complex and large objects, such as plants.http://sql-az.tr.gg/ |
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-07-16 : 07:46:17
|
Check out this article: http://blog.sqlauthority.com/2009/05/09/sql-server-find-last-date-time-updated-for-any-table/ |
|
|
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2014-07-17 : 02:43:16
|
thanksbut my server mssql server 2000have equivalent sys.dm_db_index_usage_stats in sql 2000?http://sql-az.tr.gg/ |
|
|
|
|
|