spot7.org logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML Categories

How to Determine the tables are currently in use or removeable


I'm not sure why you're getting downvoted on this, though you could have made your question more specific and provided more information about your DBMS in your original post...or perhaps spent a little more time with Google.

SQL Server does provide dynamic management views that can help you determine which tables are in use. That's not the case for all DBMSes, but SQL Server has a very rich set of statistics to help you keep an eye on database usage.

Take a look at this blog entry: http://www.sqlfingers.com/2014/02/find-unused-tables-in-sql-server.html. The sys.dm_db_index_usage_stats DMV contains information on index usage. By selecting your table entries in sys.objects and joining that against sys.dm_db_index_usage_stats on object_id, you can tell which tables have indexes that have been used since the last DB restart. That will give you some idea of which tables are "in use," though you should consider how frequently you restart your DB and how many infrequently-used features you have in your application before you consider a table "unused."


Categories : SQL

Related to : How to Determine the tables are currently in use or removeable
php and mysql problems with updating two tables, and inserting into two tables with one button
There are a few things wrong with your code. There's VALUES ('$user_id', '$orderIn_id '$invoiceIn_total', ^^ is missing a quote and a comma do VALUES ('$user_id', '$orderIn_id', '$invoiceIn_total', same thing for VALUES ('$user_id', '$orderOut_total '$invoiceOut_total', ^^ do VALUES ('$user_id', '$orderOut_total', '

Categories : PHP
How to determine size of the C# Object
You can get the Length of the object by converting it into array of string. For Example: static void Main(string[] args) { A.Result = new string[] { "il","i","sam","sa","uo"}; //represent as stringArray string[] array = A.Result as string[]; Console.WriteLine(array.Length); Console.Read(); } Your object is Invalid so I rewrite: public class A { public s

Categories : C#
How to determine altitude of a given co ordinate
The API does not provide mechanisms for automatically determining altitudes at any given lat/lon. It only provides facilities to add altitudes to coordinates. By default, if you do not specify altitudes, it is undefined. You will have to use some elevation web service to determine altitudes at your specified locations.

Categories : Javascript
determine string index vb.net
JOIN and INNER JOIN are redundant. You really just need an array like this: {"INNER JOIN", "LEFT JOIN", "RIGHT JOIN"} And once you have that, you'll notice that you always use the word join, and so you can change your code to always supply that part and only look for the first part in an array like this: {"INNER", "LEFT", "RIGHT"} At this point, your index lookup becomes much simpler.

Categories : Vb.Net
How to determine a unified hight for several ui-btn in ul?
give your navbar a id like this: <div data-role="navbar" class="ui-navbar" id="navbar1" role="navigation"> And then just use this css code: #navbar .ui-btn{height:100px}; This only changes the height from this navbar and doesnt affect the others.

Categories : Javascript
Recently Add
SQL - Selection of the oldest order for every customer (join two tables)
Sum two counts in a new column without repeating the code
Creating multiple sum fields based upon criteria in another field in MS access 2007
Grouping by two values in same table
MS SQL last record
Find field existance in more than one group of fields
how to put an img into sql table?
A field referencing two tables - Foreign Key Conflict
Comparing two Access tables identical in structure but not data
How to parse a comma separated string in SQL query if the values themselves contain a comma
SQL - returning average number of items by days of the week.
How to return multiple values from a subquery
Improve performance of first query
SSDT - Is there any way to log deployment history?
LISTAGG: group within group
SQL code subtraction
Update table records with accumulated result
select inside select doesn't work in hive
PostgreSQL 9.3 - How to insert using json_populate_recordset but still get auto ids by sequence
Optimise SQL query: find items that are geographically touching, but without association
SQL-Oracle: Difficulties in resolving basic problems, part2
SQL Server 2012 - Best way to assign incrementing number for differing sets of records, from a specific value
MS SQL Server - convert(datetime, string, code) -> What code for dd/mm/yyyy hh:mm:ss (24hours)?
Left Join with duplicate keys in the right table
Joining multiple tables in SQL Server
Round off to the smallest integer value
How to drop materialized views using EXECUTE statement in PostgreSQL
Sql database on geo redundant storage in Azure
How to select the last 3 rows but the last one
sql server status change time
© Copyright 2017 spot7.org Publishing Limited. All rights reserved.