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

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

Antivirus Exclusion Policy for SQL Server

Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...

Colorado SQL Events for April 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...

Curation and Performance

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

Currys having apostrophe trouble

Before I start I just want to say that much of this post is mere speculation on my part and...

Data Collector in SQLServer 2014 – What’s New !

Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...

Manipulating Dates and Times in T-SQL

In SQL 2008, Microsoft introduced some new date and time data types to augment the options available in prior versions....

One week to SQL Intersection

You still have time to grab the boss and convince him to invest in you. Show what you’ve learned in...

Question of the Week -08/04/2014

Suppose we need to find out the name of all the months in a given year (Year will be given...