I did like the article basically promoting thinking things out at design time to see if the state you want to represent with a BIT data type is truly a...

SSIS has a deployment utility to help with these sort of things. Right click your project name at the top in BIDS > properties > deployment utility.... set CreateDeploymentUtility =...

This works with TRUE or FALSE >

DECLARE @mybit bit;

SET @mybit = 'true';

SELECT @mybit

Though yes/no , on/off do not. Just want to add to this post.

Borrowing the table and data creation

CREATE TABLE SampleData(

FIRST_NAME varchar(20),

MIDDLE_INITIAL varchar(20),

...

As the main question asked is if there is a way to automatically blow off into oblivion queries running over n minutes:

I have to agree that is not the way...

You could add a identity column to the table, IDENTITY(1,1). This can be your guide for doing the updates in the table one batch at a time.

Borrowing on Jeff's...

The first principle of ISO-11179 and all data element names is that you name a thing for what it is by its nature, not how or where it is used...

Eric M Russell (2/9/2015)

---

Jeff Moden (2/9/2015)

---

Eric M Russell (2/9/2015)

---

axc_67 (2/9/2015)

---

No I am not joining any tables in the remote server.

I am just pulling a simple data extraction from remote server...

I for one like the yyyy-mm-dd notation. In other countries a '20140711' could be interpreted as Nov 07, 2014. If you changed the default language setting on your machine then...

CELKO (2/12/2015)

---

...

Luis Cazares (2/12/2015)

---

sonchoix (2/12/2015)

---

dwain.c (2/11/2015)

---

In the TOP 2 or 3 or 4 you are listing (outside of the Others group), what do you want to do if there are ties?

This...

Running the command

EXEC DBCC FreeProcCache

and witnessing the expected performance makes your case for parameter sniffing.

To handle the non date values, incorporate the use of a conditional split transformation. You are the best judge on what the non date values are like. You can state...

I use this when I am developing and want to set up the structure to easily comment out conditions in the WHERE clause if needed. It was weird to me...

Jeff Moden (2/17/2015)

---

MMartin1 (2/17/2015)

---

Using tables like a Calendar, Course, TimeOfDay table (separate from Calendar which implies a day as the primary key) or Period ...

you could employ a simple...