We never talk about the missing number 11....

SQL Bits XII has finally been announced http://www.sqlbits.com/.

Would it be possible to post the Stored Procedure code, table definitions and Query Plans from both of the environments?

It's bad enough trying to sort out the original suggestion without fending off 'helpful' bystanders.

I assume this is the one you tweeted about earlier.

As an aside, the date isn't stored just as an 'integer/float equivalent' which is why you're seeing this behaviour.

A couple of years back I wrote an article for the Developers...

Indeed. And somebody has to make the decision which...

Test them.

Measure the performance with and without the indexes that you believe are required for the tasks that are required. Not all recommendations are correct.

mandir.jain (2/17/2014)

---

I saw the correct extension and changed but now am getting the error

Cannot bulk load because the file "E:\BEM_Data\Test\GSP_EVENT_DATA_16.csv" could not be opened. Operating system error code 21(The...

So, the obvious thing is - does 'D:\BEM_Source\Sample' exist in that folder and on the server that the command is...

Show us the command you're using so we have something to work with.

Revenant (2/5/2014)

---

Sean Lange (2/5/2014)

---

They certainly age fast, but grow up -...

http://www.bbc.co.uk/news/world-europe-25922514

Many of the places where I used to work would have had siezures at the thought of that many updates in a week but where I work now it wouldn't...

Yes, we have a similair situation here. We use the replication monitor for 2012 to monitor all versions of SQL server because it can't monitor 'higher' versions.

My favourite resource for date manipulation is https://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/.