Answer - Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)

Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?

Options:-

a) 1

b) 2

c) More...

[SQL Snacks Video] SQL Server Table Partitioning 101

I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare...

T-SQL Tuesday #53 Why So Serious

This month’s T-SQL Tuesday which is now at a staggering number 53, can it really have been going that long?...

Curation and Performance

I’m trying out a new web site from Microsoft called Curah! that is all about curation. Curation is basically what...

Read Flat File Contents to Variable – Write Variable Value to Flat File

When working with SSIS, you’ll often find the need to read the contents of a flat file to a variable,...

The system_health Extended Event Session

When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created...

T-SQL Tuesday #53: Why so serious

Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....

T-SQL Tuesday #53: Why so serious

Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....

Why So Serious? – #TSQL2sDAY #53

As a child/pre-teen/teenager/young adult, OK, most of my life, I’ve been labeled as “serious” or “grumpy”. Maybe I deserve it...

Improving Query Performance by using correct Search Arguments

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...