Observability

Blogs

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

Read the latest Blogs

Forums

Protecting Schools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Protecting Schools

SSRS Header not Keeping with report

By rjdineen

Hi all, I have an SSRS report issue is when printing to PDF. i...

Weird redirect after reporting post

By Phil Parkin

I just tried reporting this post: https://www.sqlservercentral.com/forums/topic/fuhrerschein-umtauschen-49-176-44678273-motorbike-fuhrerschein-2 After clicking the 'Report post' button, I...

Visit the forum

Question of the Day

Which is a table?

Of these items, which are tables according to the relational model from Dr. Codd? 

CREATE TABLE dbo.Customers_a
(
    CustomerID INT IDENTITY(1, 1) NOT NULL,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Email NVARCHAR(100) NOT NULL,
);

CREATE TABLE dbo.Customers_b
(
    CustomerID INT IDENTITY(1, 1) PRIMARY KEY,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Email NVARCHAR(100) NOT NULL,
);

CREATE TABLE dbo.Customers_c
(
    CustomerID INT NULL IDENTITY(1, 1),
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Email NVARCHAR(100) NOT NULL UNIQUE,
);

CREATE TABLE dbo.Customers_d
(
    CustomerID INT NOT NULL ,
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Email NVARCHAR(100) NOT NULL,
);

See possible answers