Viewing 15 posts - 4,336 through 4,350 (of 19,564 total)
did you create the login abc using the same sid as the login from the previous server?
August 2, 2013 at 10:11 am
Brandie Tarvin (8/2/2013)
How many SQL Spackle articles are there?
Yes, I have a reason for asking. But I want to...
August 2, 2013 at 10:04 am
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...
August 2, 2013 at 10:02 am
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?
August 1, 2013 at 8:17 pm
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...
August 1, 2013 at 8:07 pm
any spaces in the network path?
August 1, 2013 at 5:52 pm
That is intriguing. Good find. At least it may be fixed in the CU.
August 1, 2013 at 4:01 pm
IgorMi (8/1/2013)
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...
August 1, 2013 at 3:57 pm
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...
August 1, 2013 at 3:55 pm
No blocking on that query while it was running (it being blocked)?
August 1, 2013 at 1:09 pm
What is your service pack level?
August 1, 2013 at 1:05 pm
Was that the only object in the query? How long was the query running before you killed it?
August 1, 2013 at 12:50 pm
Viewing 15 posts - 4,336 through 4,350 (of 19,564 total)