The syntax for creating an index on a partition scheme is

CREATE INDEX ...

ON partition_scheme ( column_name )

You have to specify the column name directly and alone in the partition scheme,...

Depends. If you see frequent fragmentation, you can drop it down slightly (not a lot, bit by bit). There's no value which is always correct for all cases.

The partition function is of the form:

CREATE PARTITION FUNCTION partition_function_name ( input_parameter_type )

AS RANGE [ LEFT | RIGHT ]

FOR VALUES ( [ boundary_value [ ,...n ] ] ) [...

Anyone remember more of Access than I do?

http://www.sqlservercentral.com/Forums/Topic1613613-2799-1.aspx

They're database pages, they're in the database file, like all other database pages are.

No, they're not in TempDB. If they were, then you'd have to restore databases from backup after...

The exec_sql_text DMV has dbid and objectid columns. Use those to identify particular procedures.

Not Page Files. Pages. They're pages in the database, like any other page.

Try this: http://www.amazon.com/Microsoft-Server-Internals-Developer-Reference/dp/0735658560

Gazareth (9/15/2014)

---

GilaMonster (9/14/2014)

---

Sometimes advice on a blog still scares me. Not often, but sometimes. Like today

Consider using a RAMDisk for Index filegroups.

Putting non-clustered indexes on a...

I gave you a solution. Stop copy-pasting existing data, or write up an access form that gives you the behaviour that you want to see.

It's nothing to do with SQL...

Ok, not too bad.

Do you have a clean backup from before the corruption occurred as well as an unbroken chain of log backups up to current time?

It's not deleting it. It's failing to insert it. Duplicate values are not permitted in a unique constraint.

As I just explained, because you're having the insert fail, the identity value...

You're going to have to have a look at the definition of the view and test, on the SQL side, why inserts fail. Maybe one of the fields you're not...

An MS Access database? Or linked tables to SQL Server?

~1.5*the size of the largest index in the database,...

In that case, I usually take profiler traces (well, server side traces) for a couple of hours of peak usage, pull wait stats, locking stats, perfmon counters and whatever more...