|
|
||||
|
Search
This Month
Recent Articles
Month Archive
Login
|
Wednesday, October 31
Alter the collation to database default
by
Administrator
on Wed 31 Oct 2007 22:34 GMT
/*--------------------------------------------------------------------------------------------------- Purpose: This script generate scripts to alter the collation Author: Carolyn Richardson Date: 05/10/2007 ---------------------------------------------------------------------------------------------------*/ USE{databasename}GO... more »
Identify tables on Server with collation issue
by
Administrator
on Wed 31 Oct 2007 22:26 GMT
This script will identify tables on all databases on a server that have differing collations, collation differences have probably occured between upgrades to SQL Server versions
or where the server default differs more »
Find tables with large logical fragmentation
by
Administrator
on Wed 31 Oct 2007 22:12 GMT
--Quick script to find tables with large logical fragmentation and generate a script to alter the fill factor
CREATE TABLE... more » |
|||