Lynn Pettis (9/15/2015)

---

Answer me this, who is going to maintain your work when you are no longer around to do so? Are you training others to provide support? ...

erichansen1836 (9/16/2015)

---

Still, I'd probably rather use one of the free offerings to beat that 10gb express limit. I was interested in the OP's decision making why he didn't pick one...

Jeff Moden (9/15/2015)

---

J Livingston SQL (9/15/2015)

---

erichansen1836 (9/10/2015)

---

If you implement a Network database file system of 500 MDB files, each acting as a partial table within the 5 billion row database,...

Wayne West (9/15/2015)

---

To be brutally honest, it sounds like you've done a heck of a job engineering job security for yourself at the expense of anyone else easily maintaining the...

erichansen1836 (9/12/2015)

---

One big complaint I would have in parting is that the users need to have physical access to the DB stores. Sure you can play games and obfuscate, etc.......

Kristen-173977 (9/11/2015)

---

P.S. SQL Server's performance monitoring tools are also useful for our own in-house APPs. We do indeed discover improvements that we can make that we didn't even know needed...

erichansen1836 (9/8/2015)

---

MS-Jet Engine 4.x ODBC enabled, NO SQL, database file systems to 1 Terabyte/5 billion rows

(or) SQL SERVER?

What reasons can SQLServerCentral give for downsizing to a MS-SQL Server database...

biscribbler (9/9/2015)

---

My current proc updates(updates using joins of two or three tables) millions of records as per the condition provided for each department.

However, when the proc fails it writes to...

Steve Jones - SSC Editor (9/8/2015)

---

I think you have to be careful to discard NoSQL as a thing, and also to discard it as applying to situations. NoSQL is a...

That would be my concern also! Thats why...

whenever I am faced with design decisions, I seem to get a bit of confidence by making a list of options. Have you looked at the various ways you could...

mar.ko (8/28/2015)

---

Exactly, another dumb rule.

I...

GilaMonster (8/28/2015)

---

That's not what a CTE...

Luis Cazares (8/27/2015)

---

patrickmcginnis59 10839 (8/27/2015)

---

drew.allen (5/30/2012)

---

dwain.c (5/29/2012)

---

Datetime functions do have their issues though, like the following:

SELECT DATEADD(month, 1, '2012-02-29')

Depending on your point of view, the results this returns looks wrong,...

My first step would be to try the sql statement in sql studio in a test environment (hopefully the same environment you're developing your web app with 😉 and see...