https://wiki.chongtin.com/ 2026-04-09T00:02:53+00:00 https://wiki.chongtin.com/ https://wiki.chongtin.com/ttps://wiki.chongtin.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2019-11-25T15:05:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.chongtin.com/ms_sql_server/alter_nvarchar_size_for_a_column?do=revisions&rev=1574665507 Alter nvarchar Size for a Column TABLE is the table of your database, and COLUMNis a column on the table. ALTER TABLE Customer ALTER COLUMN Address nvarchar(100); text/html 2020-10-20T09:57:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.chongtin.com/ms_sql_server/check_field_type_of_a_table?do=revisions&rev=1603159067 Check Field Type of a Table You have to change YOUR_TABLE_NAME to the table name you are interested in. SELECT c.name 'Column Name', t.Name 'Data type', c.max_length 'Max Length', c.precision , c.scale , c.is_nullable, ISNULL(i.is_primary_key, 0) 'Primary Key' FROM sys.columns c INNER JOIN sys.types t ON c.user_type_id = t.user_type_id LEFT OUTER JOIN sys.index_columns ic ON ic.object_id = c.object_id AND ic.column_id = c.column_id LEFT OUTER JOI… text/html 2020-10-11T10:35:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.chongtin.com/ms_sql_server/exec_stored_procedure?do=revisions&rev=1602383708 Exec Stored Procedure EXEC procedure_name @param_name1 = value_1, @param_value2 = 'value_2'; where the value with quote is string type or datetime, and the one without could be int, float,... and you might have any number of parameter as the procedure needed. text/html 2019-01-23T10:39:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.chongtin.com/ms_sql_server/list_out_all_tables_and_fields?do=revisions&rev=1548211155 List Out All Tables and Fields SELECT TABLE_SCHEMA , TABLE_NAME , COLUMN_NAME , ORDINAL_POSITION , COLUMN_DEFAULT , DATA_TYPE , CHARACTER_MAXIMUM_LENGTH , NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION FROM INFORMATION_SCHEMA.COLUMNS; text/html 2020-11-13T09:02:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.chongtin.com/ms_sql_server/microsoft_clustering_fail-over_have_downtime?do=revisions&rev=1605229328 Microsoft Clustering Fail-over Have Downtime According to <https://www.mssqltips.com/sqlservertip/1882/understanding-why-there-is-still-downtime-for-sql-server-with-microsoft-clustering/>, Microsoft clustering fail-over solution involve the following steps that cause the downtime. * Stops the SQL Server Agent service and any services dependent on the SQL Server service. * text/html 2018-10-16T09:29:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.chongtin.com/ms_sql_server/performance_tuning?do=revisions&rev=1539653342 MS SQL Server Performance Tuning Allow create, read from snapshot Run these two line while anyone else log on to your database. Check the name YOUR_DATABASE_NAME as the name of your database. ALTER DATABASE YOUR_DATABASE_NAME SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE YOUR_DATABASE_NAME SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT