Renée (6/23/2011)

---

Hi all,

I'm a SQL newbie who sort of inherited a 2005 db. I've got a query that returns a SUBSTRING of a field value in one column. I need...

Run while "SET STATISTICS IO ON", so we know how many actual page reads.

As for the option of sticking around and "fixing" your current job, unless you're in a position of influence, I find that ideal outcome to be plausible... but unlikely. It's...

So after an initial honeymoon period, even a smart guy...

What are the advantages of using CLR instead of a stored procedure? For performance reasons, programming that processes data should be as close to the data as possible, preferably all...

As for the option of sticking around and "fixing" your current job, unless you're in a position of influence, I find that ideal outcome to be plausible... but unlikely....

Jeff Moden (10/15/2015)

---

As with a clustered index rebuild, the HEAP will be preserved...

timwell (10/15/2015)

---

...

So my questions: What is Access best at? What are data professionals using it for?

I am using Access 2010. Are later versions more useful?

Should I tell our intern to...

timwell (10/15/2015)

---

I...

I believe Excel is more often used for professional data analysis than MS Access. What functionality is missing from Excel that she finds in MS Access?

Here is my proposal.

First, Backup w/ verification and duplicate backups.

o Drop all foreign keys, indexes, including clustered, from OLD tables that will be altered. It will free up workspace, and...

Dale Turley (10/15/2015)

---

I recently left a position I had been in for 6 years - as SQL DBA, Developer and Support - for a new challenge, a bit of extra...

fernando.arias (10/15/2015)

---

Though, would there be any solution for the problem you presented. If there are two persons with the same name one of the will be deleted. Can I avoid...

Kristen-173977 (10/15/2015)

---

How does the APP write to a text file, for later bulk-import, in a multi-user friendly way? Isn't it going to have to open the file, lock it,...

maxlezious (10/15/2015)

---

Hi Eric,

Thanks for your reply. I have made my mind up and have decided to sign the contract with Company A. Hopefully as I get more experienced in the...