FOREIGN KEY composta, coluna aceitando nulo, verificaçao de todos os valores nao é feita.

Monday, 20 October 2008 19:14 Alex Rosa SQL Server - Constraints

(1 Vote)

NO TRANSLATION AVAILABLE
Uma FOREIGN KEY (FK) é uma ou mais colunas utilizadas para estabelecer um relacionamento de dados entre duas tabelas diferentes ou em um unica tabela (conhecido como auto-relacionamento).

FKs podem ser criadas referenciando a PRIMARY KEY ou uma UNIQUE CONSTRAINT (indices unicos).

Entretanto, se alguma das colunas que compoem a UNIQUE CONSTRAINT e a FK aceitarem um valor NULO, ao inserir um registro passando o valor NULO para alguma dessas colunas, o processo de verificaçao de todos os valores nao é executado.

SQL Server 2000 / 2005 - System Tables and Views

Sunday, 19 October 2008 20:37 Alex Rosa SQL Server - System Views

(2 Votes)

It's very important to know the SQL Server System Tables and Views.

Don't waste your time and get the files here:

Did you know? - Disabling Clustered Indexes

Sunday, 19 October 2008 19:50 Alex Rosa SQL Server - Indexes

(0 Votes)

Disabling a clustered index on a table prevents access to the data, the data still remains in the table, but is unavailable for DML operations until the index is dropped or rebuilt.

Use the script below to check:

Webcast SQL Server 2005

Sunday, 19 October 2008 20:01 Alex Rosa SQL Server - Videos

(0 Votes)

Have you seen the SQL Server 2005 webcast?

I have this webcasts below to share with you:

Administration Tools
Monitoring Tools
Achieving Greater Concurrency
Securing Your SQL Server
Protecting Sensitive Data
Managing Large Databases Using Partitioning
Backup and Restore Minimizing Downtime
High Availability
Moving Data Between Data Sources

I'm posting the weblinks below:

Error 1619 installing MSSQL from Hard Disk

Saturday, 18 October 2008 21:34 Alex Rosa SQL Server - Troubleshooting

(2 Votes)

If you are installing SQL Server from Hard Disk and you’re getting the error message below:

Errors occurred during the installation:
Error 1619 installing Microsoft SQL Native Client. See log file for more detailed information.
This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid windows installer package.

The solution is: