Someone had mentioned that the date/time conversions can be expensive. Depending on what you're needing to do with the dates and times once they're converted, it might make sense just...

Whether a Jet based database will scale up to 1 TB depends on how exactly you are partitioning and the case usage of how the users are querying it. Jet...

Jeff Moden (9/4/2015)

---

Alvin Ramard (9/4/2015)

---

Jeff Moden (9/3/2015)

---

So, if...

Andrew_Steitz (9/4/2015)

---

Ed Wagner (9/3/2015)

---

Jeff Moden (9/3/2015)

---

When I was the Director of MIS for a small but nationwide telephone company, someone asked me about my habit of hiring nearly over zealous...

If this is a reporting database with stored procedures that typically run for several minutes or longer, then one thing I do to audit usage and performance is implement something...

To decode the actual reason the login failed, you'll have to look in error log (not client message) for the State code.

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

Note that the message is kept fairly nondescript to...

For a TB+ sized data warehouse there is more of...

Andrew..Peterson (9/3/2015)

---

If you have an old truck that still does the job, you don't buy a new one just because it is new. Upgrades are a cost benefit decision. Microsoft...

bwhiteside (9/3/2015)

---

Grant, I think you called it. It looks like the new cardinality estimator appears to be causing our queries to run much slower. We changed the compatibility mode to...

jckfla (9/3/2015)

---

Oh dear...I feel...

Alvin Ramard (9/3/2015)

---

Eric M Russell (9/3/2015)

---

Years ago I was involved in a SQL Server 2000 -> 2005 migration. There was a 3rd party hardware interface application that would not connect...

ccd3000 (9/3/2015)

---

I suppose you could argue the cost is in complexity and rigidity. Depending on the scenario that can be a good thing (you need structured, efficient data). I think...

Years ago I was involved in a SQL Server 2000 -> 2005 migration. There was a 3rd party hardware interface application that would not connect to SQL Server 2005. From...

The purpose of foreign keys are understood by all here.

But, aside from it's impact on bulk load performance (typically not an issue for OLTP databases), can someone recap what...

Just curious what type of code changes would be needed for a MS Access application originally designed for SQL Server 2005 to support SQL Server 2014 ?

Of course the connection...