btio_3000 (9/10/2015)

---

Hi Lynn,

That's probably the case... so, basically there is no way to avoid it, except for such common sense things like keeping transactions short, read uncommitted, update statistics, right?...

Most likely you are running this while users are active on the system, so you are probably encountering blocking during some of the runs through the loop. I would...

erichansen1836 (9/10/2015)

---

It is NO SQL if the end-user does not use SQL.

The ODBC enabled application (Win32 PERL, etc.) would build/execute the SQL statements.

This is necessary for two reasons.

(1) The end-user...

Here is a new one: SSIS is a cash cow add on to SQL Server.

Really, cash cow? It comes free with SQL Server.

erichansen1836 (9/10/2015)

---

Thanks for the link to my post at Microsoft Developers Forum regarding Jet (Red) Engine Databases.

Also, FYI, I have issued 510 concurrent independant SQL processes on Windows 7 Home...

Must be talking about the Jet vs SQL thread.

Like I said there, "it depends."

Alvin Ramard (9/10/2015)

---

Lynn Pettis (9/10/2015)

---

It isn't that the questions are getting worse, I really think it is that the people working against the databases really have no business working without...

I have been asked if I could provide samples of some of my code during an interview, and I've seen it requested in a few job postings. My answer...

It isn't that the questions are getting worse, I really think it is that the people working against the databases really have no business working without an on-site mentor that...

If any one is interested in a philosophical debate over the pros and cons of a File System based DB and a RDBMS, feel free. Not really sure if...

Luis Cazares (9/10/2015)

---

LoudClear (9/10/2015)

---

Yes, my argument has heretofore been

From above article: "Invariably, someone at some point is going to come in and add a column, remove a column,...

I'd also be looking at how SQL Server was installed at the clients where things are failing versus where it isn't failing. It is peculiar that it is failing...

erichansen1836 (9/9/2015)

---

Yes I stand corrected. It does appear that SQL Server has grown in recent years from 1 Terabyte to 1/2 Petabyte capacity.

SQL Server Express has a 10 GIG...

erichansen1836 (9/9/2015)

---

I consider it downsizing to go to SQL Server from Jet Engine because my understanding is that SQL Server cannot match Jet Engine for size and speed. Can...