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

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 snapshot table that...

Hi Jeff, from reading your thoughts I hope I understood all of the points you made. I drew out here a base and audit table as

CREATE Table table1

(

IDINT IDENTITY(1,1)...

Just to note, the DATENAME functions requires a date for the second argument. They way you have it you are expressing 1900-01-01. If...

Eric M Russell (2/3/2015)

---

MMartin1 (2/3/2015)

---

Maybe I missed it somewhere but it seems as though you are reporting from the same system you insert into. You generally want to build a...

Koen Verbeeck (1/19/2015)

---

What I would do:

* Read the flat file like you normally would, i.e. with a flat file source. You can use a for each loop container with a...

Maybe I missed it somewhere but it seems as though you are reporting from the same system you insert into. You generally want to build a warehouse to store your...

The ".." represents the default schema for the security context accessing the data, without you having to type it. Let us say that I am logged in as loginA. Under...

Could the 'safe' plan that incurs a higher cost be helped by updating statistics?

Luis Cazares (1/27/2015)

---

If it's a string column with underscores between each part of the date. This could be an option.

SELECT columns_to_return

FROM dbo.XYZ

WHERE date_column > REPLACE( CONVERT(...

I too like the column on the left and expression on the right. I also like to use the year argument to know I am interested in one year back,...