Viewing 15 posts - 1 through 15 (of 469 total)
A reorg can only move pages withing the file that they're in. I would need to do a rebuild or drop and create to handle this. We're going...
November 22, 2016 at 9:49 am
I've opened a case with Microsoft and I'll update this with what they come up with.
November 15, 2016 at 12:59 pm
We can't empty that file because it has the system objects. That may move the user objects but I'm not sure.
I'm also curious as to why it wouldn't just...
November 15, 2016 at 9:01 am
That shows which objects are in which file group (data_space_id) but since both data files are in the same group it didn't show which objects are in which file.
After some...
November 15, 2016 at 6:39 am
Lynn Pettis (11/14/2016)
What are the settings for growth of the data and log files? What is the full error message you received?
type_descsize ...
November 14, 2016 at 2:34 pm
I can't piece much together from that error message unfortunately. Hopefully someone that knows more about maintenance plans stops by. Another option, if you're not wedded to maintenance...
October 7, 2014 at 12:27 pm
We don't use maintenance plans where I work but if you can provide an error that may help.
Another recommendation, don't use the shrink step unless you have a specific reason...
October 7, 2014 at 10:45 am
I'm not sure how I didn't find this article when I was researching this yesterday but I found Paul Randal's article on this wait:
http://sqlperformance.com/2014/02/sql-performance/knee-jerk-waits-sos-scheduler-yield
It's frequently not a sign...
October 7, 2014 at 10:27 am
Shahin (1/7/2014)
January 7, 2014 at 6:44 am
We have DR plans for our high priority systems but rarely test them. I recently approached the team of one of these systems that I thought would be most...
July 22, 2013 at 2:20 pm
Inserts into a table variable aren't rolled back. "SELECT NEXT VALUE FOR <sequence>" isn't rolled back either. I'm not aware of anything else that isn't but there's likely...
January 11, 2013 at 11:42 am
The environment is a rural hospital I ran stats over our last month for all DBs under my team's purview (which excludes the data warehouse and our Electronic Health...
December 21, 2012 at 9:59 am
While I'm not thrilled with the wording in the question, I took it to mean that the constraint held multiple null values which isn't a confusion anyone else has pointed...
December 20, 2012 at 6:55 am
Based on my experience I'm not sure that I agree with the, "managers shouldn't know," part of this. I fully agree that they shouldn't be the decision makers on...
November 29, 2012 at 6:18 am
paul.knibbs (11/9/2012)
November 9, 2012 at 9:45 am
Viewing 15 posts - 1 through 15 (of 469 total)