Viewing 15 posts - 826 through 840 (of 1,179 total)
Also you can rebuild the indexes which are poor i.e. run dbcc showcontig and if Scan Density is below 80% reindex.
Thus you can save time as well as reduce burden...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 22, 2009 at 11:11 pm
I guess hosted team is still under impression that Microsoft OS needs reboot at a specific period.
The fact is those days are gone. I also used to reboot the server...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 21, 2009 at 4:38 am
You can use profiler if you do not have any third-party tool.
Capture the live data with the help of profiler during peak hrs and re-run the same into test environment...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 13, 2009 at 5:45 am
Yes, You are verymuch correct Silverfox.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 13, 2009 at 5:01 am
Hello Sarvesh,
If your database is not on production or if you can manage little downtime on weekend. I suggest detach and attach would be better option to move your data...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 13, 2009 at 3:53 am
Silverfox
Thank you for understanding.
----------------------------
Give Respect & Earn Respect
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 13, 2009 at 2:16 am
Silverfox
This is with reference to doubt of k.przewozniak that...
"I wonder if everything is fine with this server... "
Can you please tell me how you can find out if everything...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 13, 2009 at 1:59 am
To make sure every thing is fine run
dbcc checkdb (msdb)
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 13, 2009 at 1:21 am
Hello Krishna,
You can ask you vendor to have brief technical session. You just than download the trial version and test thoroughly into your test environment before going further.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 12, 2009 at 6:41 am
check the service account password.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 6, 2009 at 6:32 am
All these Int. questions are very tricky and having multiple answers. It's all about matching the wavelength with the interviewrs. There are many int. I have faced in which I...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 1, 2009 at 7:47 am
use this command to start sql server from command prompt:
for default instance:
sqlservr.exe -m
for named instance:
sqlservr.exe -m -s <instancename>
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 29, 2009 at 6:03 am
Try... sp_monitor
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 29, 2009 at 4:53 am
San,
There are multiple way of doing the same things...
You can easily delete the unwanted database.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 25, 2009 at 4:20 am
Refer following link for Physical design of DB.
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/PhysDBStor.doc
If you do have only one application with one sql instance Active - Active will not be possible. You can go with Active...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 25, 2009 at 2:21 am
Viewing 15 posts - 826 through 840 (of 1,179 total)