Aumentar o espaço alocado para o ficheiro de log

ALTER DATABASE MyDB
 MODIFY FILE
    (NAME = MyDB_log, SIZE = 20MB);

Visualizar estatisticas de utilização do log

DBCC SQLPERF (LOGSPACE)

 

Verificar se uma coluna tem um Constraint

SELECT  COUNT(*)
FROM    INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS u
WHERE   u.TABLE_NAME = 'Customers'
        AND u.TABLE_SCHEMA = 'dbo'
        AND u.COLUMN_NAME = 'PhoneNumber' ;
 

Verificar se um Constraint corresponde a uma chave unica

SELECT  COUNT(*)
FROM    INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS u
        JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS c
            ON c.TABLE_NAME = u.TABLE_NAME
            AND c.TABLE_SCHEMA = u.TABLE_SCHEMA
            AND c.CONSTRAINT_NAME = u.CONSTRAINT_NAME
WHERE   u.TABLE_NAME = 'Customers'
        AND u.TABLE_SCHEMA = 'dbo'
        AND u.COLUMN_NAME = 'PhoneNumber'
        AND c.CONSTRAINT_TYPE
            IN ( 'PRIMARY KEY', 'UNIQUE' ) ;

Permitir parametros de Stored Procedures opcionais

CREATE PROCEDURE dbo.SelectCustomersByName
  @LastName VARCHAR(50) = NULL
AS  
  BEGIN ;
    SELECT  CustomerId , FirstName , LastName , PhoneNumber
    FROM    dbo.Customers
    WHERE   LastName = COALESCE(@LastName, LastName);
  END ;

EXEC dbo.SelectCustomersByName
 @LastName = 'Hansen';