A few scenarios. I have reached the 2b limit before and needed to reseed data. The table held a rolling 50-100k rows, but lots of inserts every day (and deletes).

You...

stormsentinelcammy (5/10/2011)

---

Hey Steve, I'm the Admin to the server and I added my user specifically with all the user rights to run the jobs. Is there something else I should...

Chris,

You are right, and I've altered the question to specify non-heaps.

jcrawf02 (5/10/2011)

---

Jim Murphy (5/9/2011)

---

Ah yes. I do see something in your profile about Orlando. So you probably know a...

Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen, but I did manage to get Gail's,...

cfradenburg (5/10/2011)

---

Eric M Russell (5/10/2011)

---

I'm not sure how many users monitor their guest book or blog posts close enough on a daily basis to notice if one (out of a...

Saw that after I wrote this and was very interested. A...

That error is the same one that you would get if any user typed a path to a file server and tried to run a file they didn't have permissions...

You might read this as well: http://www.sqlservercentral.com/articles/T-SQL/71571/

Talks about solving your issue and how the query above works.

I'd agree with @troubleshootingsql. Set max memory in each instance, with the sum of your settings being 2GB less than the total memory.

Or to make it easy, set each instance...

Added spaces into the code. Should look fine now.

John Mitchell-245523 (5/9/2011)

---

I discounted Page splits/sec because page splits are also caused by INSERT statements, and therefore if you wanted to measure the rate at which UPDATE statements cause data...

Christian Buettner-167247 (5/9/2011)

---

The answer does not sound right to me.

For heaps, there are no page splits, therefore the only counter that gives me the answer for both, indexes & heaps,...

Speed definitely matters. If your software doesn't take a longer access time into account, it can be an issue.

SQL Server doesn't provide you any way to read the backup file and extract only a table. There are third party tools that can do this, but you would have...