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

RonKyle (9/2/2015)

---

We all just need to come to terms with the fact that application programmers have a need to locally persist things like shopping carts, messaging, or just generic objects....

We all just need to come to terms with the fact that application programmers have a need to locally persist things like shopping carts, messaging, or just generic objects. It...

I've seen cases when someone was attempt to use the Import Wizzard to load a table and accidentally checked the option 'Delete Existing' instead of 'Append', or where a miscoded...