Viewing 15 posts - 646 through 660 (of 1,138 total)
Jess-321561 (9/18/2009)
What does job syspolicy_purge_history do? This is came with a default installation of SQL Server 2008. Thanks!
It removes the policy evaluation history
When you create policies and evaluate them from...
September 18, 2009 at 9:26 am
Appreciate the explanation and solution Mel, greatly appreciated. 😎
September 18, 2009 at 9:19 am
This will fix it for you, before I get shouted at for using a deprecated command, I know it is sql 2000, but it works.
sp_update_jobschedule @job_Name= 'ExecuteGreedyTran',@Name= 'ExecuteGreedyTran', @freq_interval =...
September 18, 2009 at 9:06 am
Sounds like you have a big task to deal with, I would split everything out, definitionally want SSRS and SSAS on separate machine.
In previous posts, there seems to be some...
September 18, 2009 at 8:36 am
I am sure that someone will be kind enough to spend the time to do this for you. however based on your comments, I am making the assumption, you didnt...
September 18, 2009 at 8:18 am
Trooper-731533 (9/18/2009)
I have a job that rebuilds the index on one of our production databases. The job runs succesfully however when I check the 'avg fragmentaion in percent' using the...
September 18, 2009 at 8:03 am
Can you post the error that you are seeing
September 18, 2009 at 7:59 am
Sorry for the double post, I can see that my title has changed and my points are up to date, so extremely happy, Many thanks to whoever made the change/fixed/ran...
September 18, 2009 at 7:52 am
lrosini (9/18/2009)
Do Not click on the link from dba-vb. IE will start opening mulitple pages and become unresponsive. A reboot will be required.
Was tempted to test that theory out. but...
September 18, 2009 at 7:47 am
MarvinTheAndriod (9/18/2009)
September 18, 2009 at 5:58 am
tobe_ha (9/18/2009)
I need to find a way to analyze a tempdb, as i would like to answer the following questions:
- Allocation per Database
- Allocation per Session / User
- Top n...
September 18, 2009 at 5:50 am
Vishal Singh (9/18/2009)
so I. but thanks for reply.BTW did you ever come across with any situation where in A/A node the number of CPUs are not equal on both nodes?
Nope...
September 18, 2009 at 4:42 am
Vishal Singh (9/18/2009)
Silverfox (9/18/2009)
Vishal Singh (9/18/2009)
What this term mean "TempDB should have one data file for each CPU"
I would have thought someone as talented as you would know this.... 😛
It...
September 18, 2009 at 4:28 am
Vishal Singh (9/18/2009)
What this term mean "TempDB should have one data file for each CPU"
I would have thought someone as talented as you would know this.... 😛
It is best practise,...
September 18, 2009 at 4:21 am
Vishal Singh (9/18/2009)
and if nothing works, suspend the Services from Primary.:hehe:
LOL, the op has enough answers, dont confuse any further.
September 18, 2009 at 4:18 am
Viewing 15 posts - 646 through 660 (of 1,138 total)