AtoZ67 (2/6/2015)

---

Converting a database from Access 2007 to SQL Server 2014.

When I run a query it takes about 25mins in SQL Server while Access takes about couple of mins.

When converted...

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from...