sql server 2008
Change in SQLServer the key column of a table to a new one of type integer that is identity using OVER
Submitted by il_masacratore on 21 November, 2016 - 12:58At some point it may be necessary to change the key column type for our table / s because of a poor design or a subsequent change that forces us to do so.
If we do and the new has to be a column of the integer type, maybe identity, we can do it with some criterion so that it is sorted ..
SQL08: Update table statistics dynamically throughout a database
Submitted by il_masacratore on 4 March, 2010 - 12:53As in Oracle there is a table which lists all tables in the database (dba_tables) and we can use it to do maintenance dynamically in SQL Server can do the same querying the table [dataBase].dbo.sysobjects.
In the example below (as in others that I hung up) update the statistics for all tables in a database, SQL Server dynamically querying the data dictionary. This could be encapsulated in a stored procedure or in a job directly execute SQL Server Agent to keep updated statistics on all tables in a database automatically.
