07 August 2019

ALTER USER DEFINED DATATYPE

We cannot alter the User-defined types after creation.

 PROCEDURE



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Resource Governor

Resource Governor  is a feature that you can use to manage SQL Server workload and system resource consumption. Resource Governor enables y...

  • SQL Query Performance
    common issues with performance such as: deadlocks blocking missing and unused indexes I/O bottlenecks poor query plans statistics ...
  • Performance Tuning
    1) Missing Index Performance is always associated with Indexes. If your database is missing many indexes, kindly execute the below scrip...
  • Move Database
    (A) Move USER database : 3 methods 1 Backup and restore on new location 2. attach and detach database 3. Alter Command First check ...