Viewing 15 posts - 36,226 through 36,240 (of 49,562 total)
mr_adeelalisyed (10/19/2009)
You were right I’ve notice Service Broker start but then stop. And this is why Server is not able to start.
Nope, other way around. Service broker is stopping because...
October 19, 2009 at 10:31 am
What happens if you try and start SQL from the command line? For the default instance, go to the directory with the executable and just run sqlservr.exe
October 19, 2009 at 10:24 am
Eddie Hendrix (10/19/2009)
Does anyone know why MSDB is having this issue and nothing else?
What are the messages in the error log relating to MSDB?
Please in future can you start a...
October 19, 2009 at 9:59 am
No. Moving any of the files of a database require that the database is offline or detached.
October 19, 2009 at 9:57 am
Avg disc sec/read?
Avg disk sec/write?
Queue length isn't a great measure with a SAN. Is 500 MB/sec a good throughput for your SAN?
October 19, 2009 at 9:23 am
endeavour (10/19/2009)
has anyone actualy hired a consultant to advise on SQL performance issues or to help your SQL database scale?
My introduction to performance tuning was when the company I...
October 19, 2009 at 9:19 am
Philip Millwood-419646 (10/19/2009)
Recovery is progressing-- albeit slowly. It is now at 50%
Ok, so you are seeing the "recovery is 50% complete..." messages?
Last time I saw a recovery taking this...
October 19, 2009 at 9:07 am
Check the SQL error log as well (text file called ERRORLOG). It will give the reasons why the service failed to start
October 19, 2009 at 8:43 am
To restore a database to a particular point in time you need a full backup from before that time and all the log backups from the time of the full...
October 19, 2009 at 8:43 am
Check error log before you try a reboot. If there's something wrong with the database that a reboot won't fix, then rebooting isn't going to help. Check what's wrong first,...
October 19, 2009 at 8:19 am
Have a look in the SQL error log, look for messages relating to that database.
If you have entries like this, then the DB is in restart-recovery and you'll have to...
October 19, 2009 at 8:09 am
Mr. Andersen (10/19/2009)
Anyone have a good idea on how I can maintain my log entries, even though the transaction has rolled back ?
Log to a table variable, they're unaffected by...
October 19, 2009 at 8:06 am
endeavour (10/16/2009)
Would you consider hiring a specialist consultant for performance and scalability issues in SQL?
Yes, absolutely. If you have no idea where to start and you have a performance/scalability problem...
October 19, 2009 at 5:23 am
namrata.dhanawade-1143388 (10/19/2009)
Even if there are duplicates in the select, will it not get caught in the if exists for the second insertion/ duplicate insertion ??
Insert ... select does not work...
October 19, 2009 at 5:18 am
Viewing 15 posts - 36,226 through 36,240 (of 49,562 total)