Viewing 15 posts - 1 through 15 (of 18 total)
Depending upon what kind of problem you are facing you need to set your own counter.
Below query may help you whic is for buffer cache hit ratio ,you need to...
October 4, 2012 at 8:26 am
When SQL engien traversing through Clustered index , the engine will start from Root page and traverse over non leaf nodes until it reaches leaf level page (data page).
October 4, 2012 at 7:49 am
May below links helps you:
October 2, 2012 at 3:22 am
If log says nothing about this problem there is way through which root cause can be trace out with using profiler.Lets on profiler when you going to run checkdb and...
October 2, 2012 at 3:19 am
If you are able to make connection with using port no and without port you are not then browser service is not running and if it looking running then port...
October 2, 2012 at 2:21 am
It looks like consistency errors.If database is not start the rebuilt it and restore from latest backup.
Master will restore when SQL start in single user mode and when you going...
September 6, 2012 at 2:41 am
Restore from backup:
1) Restore in dev enviroment
2) Script out the table
3) Create that table in Prod enviroment.
3) Import all data from Dev table.
September 6, 2012 at 2:28 am
I also agree with that never go for detach option if database is in suspected mode it will make situation more worse.
You can rebuild new log file if there...
September 6, 2012 at 2:24 am
Log will not reclaimed only in that case if that space is involve in active portion of log. so something is hang on in transcations.....
Check if there is any transcation...
September 3, 2012 at 6:09 am
If xp_delete_file is deleteing file localy and not able to delete on network then sure this is permission issue.
Are you able to see that files?
You can check to give access...
September 3, 2012 at 6:03 am
I think there will be conflict when you will create using same table(Articles) in database.
September 3, 2012 at 5:50 am
In SSRS there is feature for automating the reports
but calling time you can cofigure one time.
Or
If you are using Crystal report in .NET interface then user can run report...
September 3, 2012 at 5:18 am
If your SQL is running with service account or any service account which have SYSADMIN privilages you can enter with that account and reset then SA password.
September 3, 2012 at 4:46 am
I think DBCC SHRINKFILE is worth to use.
It will make some space because in log file there is active and inactive portion.You can reclaim inactive space in log file.
September 3, 2012 at 4:41 am
As per my expirince you can't roll back SP using Resource database as it is read only and hidden.
August 7, 2012 at 3:05 am
Viewing 15 posts - 1 through 15 (of 18 total)