How are you checking memory usage?

Lynn Pettis (1/31/2013)

---

And no, it didn't go missing. It just died with a loud pop. Could be the power supply, the system is 8 years old.

Question for those...

No, don't mess with the IP on the mirror.

Read up on transparent client redirect first. You could also give the app both server's names to try, or do a DNS...

It's not an automatic clustered index. It's by default clustered, that's all. Trivial to have a nonclustered primary key or a clustered unique constraint

PK disallows nulls.

This is more a...

How do you have a single table in multiple filegroups?

As the previous poster stated:

DBCC SHRINKFILE (N'FILENAME' , EMPTYFILE)

That's assuming it's a single filegroup with multiple files

Read up on "Transparent Client Redirect". If you're using ADO.net or SNAC to connect, you don't need to do any of what you're suggesting.

dave-L (1/31/2013)

---

Incidentally, I'm wondering about this for Foreign Keys as well. Beyond enforcing referential integrity and documentation, are there any advantages to actually declaring these constraints in the schema?...

Dave62 (1/31/2013)

---

This quote from the MSDN page I referenced seems to indicate some relation.

"Counts the total number of inserted,...

The row count in sysindexes is not related...

Lowell (1/31/2013)

---

i thought you had to get the actual counts from sys.indexes; since the index must have a heap/PK index for every table, teh row counts are materialized exactly correct...

No, not at all.

Just like you wouldn't randomly drop the clustered index (unless you want your table inaccessible for a while and your log to bloat), you wouldn't randomly disable...

SQL MOD (1/31/2013)

---

If SQL is still taking 100% of the CPU, then you haven't tuned all the CPU consuming queries. Keep going, not something you're going to solve in 5...

Nope. Corruption is something outside of SQL mangling the database. Check your IO subsystem

You need to do a full DB repair, there's corruption not associated with an object as well....

You really should have both on a permanent table. Maybe as one and the same thing, maybe different.