Viewing 15 posts - 10,576 through 10,590 (of 49,566 total)
Homework? If so, ask your tutor/lecturer.
Interview question? If so, the correct answer is "I don't know"
December 20, 2013 at 12:52 pm
Complicated?
I'm not sure what you're looking for here. What's the context and background for the question?
December 20, 2013 at 11:59 am
Jack Corbett (12/20/2013)
WayneS (12/20/2013)
December 20, 2013 at 10:58 am
Jonathan Kehayias (12/20/2013)
December 20, 2013 at 10:21 am
Grant Fritchey (12/20/2013)
WayneS (12/20/2013)
For...
December 20, 2013 at 10:13 am
Can you post the entire of one of the error logs please
December 20, 2013 at 10:11 am
It's just asking if you want the changes you made to Management Studio 2008 to be imported into Management Studio 2012.
December 20, 2013 at 7:53 am
william.rees.howells (12/20/2013)
December 20, 2013 at 7:49 am
Can you post the entire of one of the error logs that shows the errors?
December 20, 2013 at 7:06 am
If a process has a Sch-M wait type, then it is waiting to get an Sch-M lock, meaning it is trying to get a schema modification lock and is waiting...
December 20, 2013 at 6:59 am
jasona.work (12/20/2013)
Will the snapshot therefore have to "grow" to keep track of the changed records so it (the snapshot) stays consistent to the moment it was taken?
Yes.
December 20, 2013 at 6:19 am
william.rees.howells (12/20/2013)
Follow up question what do these wait_resources mean?METADATA: database_id = 5 SECURITY_CACHE($hash = 0x2532319d:0x1)
METADATA: database_id = 9 METADATA_CACHE($hash = 0x3317e3d:0x0)
Offhand, not sure.
and also could the compilations cause schema...
December 20, 2013 at 6:18 am
william.rees.howells (12/20/2013)
December 20, 2013 at 6:16 am
Lowell (12/20/2013)
December 20, 2013 at 6:08 am
This may help. http://www.sqlskills.com/blogs/paul/query-plan-analysis-first-steps/
Also, grab a copy of Grant's Exec plans book, should be lots in there, more than you'll get as forum replies
December 20, 2013 at 5:52 am
Viewing 15 posts - 10,576 through 10,590 (of 49,566 total)