did you create the login abc using the same sid as the login from the previous server?

convent

Brandie Tarvin (8/2/2013)

---

How many people (besides Jeff and myself) have written SQL Spackle articles?

How many SQL Spackle articles are there?

Yes, I have a reason for asking. But I want to...

I stopped using windows defrag many years ago after discovering that it seldom defragged properly and often caused more fragmentation.

After that I started using a tool called Perfectdisk - very...

Were the schema and user a part of the database on the old server before you backed it up and restored it to this new server?

sounds like a permissions issue or possibly a double hop issue

I have been able to repro under the following circumstances

two machines not in a domain

user can access the directories of...

any spaces in the network path?

Got it - will do.

That is intriguing. Good find. At least it may be fixed in the CU.

sql spackle?

I'll nab that one

IgorMi (8/1/2013)

---

Hi,

The widely used thresholds are: Reorganize if fragmentation is between 10-30%. Rebuild if > 30%.

Indexes with small number of pages (<1000) will usually not loose fragmentation. Try your...

For a reorg it is < 30% and > 10% fragmented.

Pagecount depends on your environment. A common myth was created due to people wanting a specific number so Paul...

No blocking on that query while it was running (it being blocked)?

What is your service pack level?

Was that the only object in the query? How long was the query running before you killed it?