Viewing 15 posts - 7,321 through 7,335 (of 49,571 total)
No. Because
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous...
November 12, 2014 at 12:07 pm
Before you change maxdop, could you look through the startup messages in your error log and post any that reference NUMA?
November 12, 2014 at 11:30 am
zedtec (11/12/2014)
So to use extended events would I just create a new session in SSMS 2012?
Create a new session, pick the events, add filters, run session. That's the basics, but...
November 12, 2014 at 5:12 am
Well, three jobs. You don't need to use maint plans for Ola's stuff.
Why is that a problem? Every single prod SQL instance I set up maintenance on gets 4 jobs...
November 12, 2014 at 4:46 am
Please post EXACT descriptions and all error messages encountered, along with a precise timeline of exactly what happened.
Alternately, restore from your last good backup.
November 12, 2014 at 4:42 am
There's always at least one filegroup in a database. If you haven't created any filegroups, then all files will be part of the PRIMARY filegroup and data will be written...
November 12, 2014 at 4:39 am
That's not how SQL Server works. You enter passwords to connect to the instance and then the login's permissions determine whether or not it can access the databases.
November 12, 2014 at 1:24 am
I suppose that has to do with possible corruption in the file rendering all the backups inside unusable, point taken.
No, I was more thinking about someone accidentally deleting a file....
November 11, 2014 at 3:16 pm
Try working through this: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Alternatively, if you want advice, please post exact error messages and detailed description of exactly what happened.
November 11, 2014 at 3:13 pm
You need to google and do some research because it's not clear what edition you need, whether you can use the free Express or not, and we don't know your...
November 11, 2014 at 1:16 pm
Luke L (11/11/2014)
Since its a parralelism wait is there any way you know of to force the issue to make it repeatable. ..
Not offhand, and gut feel is that...
November 11, 2014 at 12:29 pm
Quote from Steve's post
You can google for those editions and the download locations.
November 11, 2014 at 12:14 pm
You'll probably get Oracle questions answered faster on an Oracle forum
November 11, 2014 at 12:08 pm
Those latches are to do with parallel table scans. Two steps I would suggest
- Increase cost threshold for parallelism (especially if it's at the default of 5) and consider changing...
November 11, 2014 at 12:04 pm
ahfb (11/8/2014)
if i have another admin user ,is it possible to recovery sa password ?
Let me quote the post right above yours
SQL passwords are stored with a on-way hash. They...
November 11, 2014 at 12:02 pm
Viewing 15 posts - 7,321 through 7,335 (of 49,571 total)