Viewing 15 posts - 961 through 975 (of 1,179 total)
Hi Paul,
I guess I am failed to express what I want.
I do understand that in addition to the performance; if small extent is set to autogrow i.e. 250 mb or...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 20, 2009 at 11:57 am
Hello Paul,
I guess operation may not fail in most of the case but yes it might fail due to unavailability of the space. I guess mostly it get delayed and...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 20, 2009 at 11:36 am
Use windows performance monitor.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 18, 2009 at 5:54 am
Hello Brad,
It's always good to have proactive work.
Also I suggest that instead of running select @@version you can check the services of the sql server instance. You can refer the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 15, 2009 at 11:09 pm
What if you do finetune the development things like SP, Triggers, Business logics/Rules etc... does it improve the performance???
I guess if everythings are scattered and not maintained; it's always better...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 9, 2009 at 3:37 am
Hello Duran,
Yes it's quite possible....
Modify the Maintenance plan... in the design right pan top tool bar click 'Reporting and logging' (beside Manage Connections) and specify the path in 'Reporting'.
HTH
Cheers!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 5, 2009 at 3:23 am
I do agree with Glenn only users need to be mapped elase do nothing.
When you will do reindexing and update statistics the environment will change compare to production and what...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 4, 2009 at 11:05 pm
While you change the compatibility level of my database from 80 to 90. It's always good to test each and every Stored procedures, function, triggers, Buisness rules etc. in your...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 4, 2009 at 5:41 am
Hello '2 Tim 3:16',
Nice solution We can cerate the link server and surely it works but what if customer do not agree for link server?
Also due to some security issues...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 4, 2009 at 5:26 am
Thank you, John.
Your query works but in case if SQL server is down we won't be able to track it.
So any solutions are welcome; when SQL server stops 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 1, 2009 at 10:55 pm
Thank you Adiga & rlondon.
Yes both of your reply will be useful.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 27, 2009 at 4:45 am
😀 You made my day!
Paul you hit the bull eye buddy 😉
I am using SP2
You need to add "Maintenance Cleanup Task" with desire retention period of Database...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 25, 2009 at 4:49 am
What sql server Service Pack are you using?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 25, 2009 at 1:01 am
DC, you bang the target profiler will tell you everything 😉
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 24, 2009 at 5:58 am
I guess in your case backup threshold value is greater than log backup intervel.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 24, 2009 at 4:28 am
Viewing 15 posts - 961 through 975 (of 1,179 total)