First, consider giving surrogate key identifiers a unique names, and a broadly used standard is to use <tablename>ID (ie: MessageID instead of just ID). I'd recommend making this...

You can leverage the INFORMATION_SCHEMA.COLUMNS system table, which contains one row for each table and column in the database, to build up a SQL select statement into a variable.

To execute...

Sean Lange (9/17/2015)

---

Eric M Russell (9/17/2015)

---

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

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