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...

  • Basic Server Information
    SELECT @@VERSION --Returns the version of MS SQL Server running on the instance. SELECT @@SERVERNAME --Returns the name of the MS SQL ...
  • Replication Terminology
    Replication is a way to automate data distribution from a source to one or more destination database. SQL Server replication follows t...
  • Performance Tuning
    1) Missing Index Performance is always associated with Indexes. If your database is missing many indexes, kindly execute the below scrip...