Viewing 15 posts - 31 through 45 (of 309 total)
Thank's a lot Howard.
It is really disapointing :(.
Best regards.
Carl
March 24, 2011 at 9:01 am
It could be helpfull to avoid logging in scenario where you want to "UPGRADE" the data in a BD with numerous conversions script:
1- You take a full backup of the...
March 9, 2011 at 9:37 am
Hello Jillk,
1- Open the SQL Server Agent properties Window
2- Click on Alert System
3- Enable mail profile and enter the information for Mail System and Mail Profile
4- Click on the ok...
October 27, 2010 at 8:44 am
We logged something at SQL Connect recently but no ones (only 4 votes) seems to be interested in this enhancement.
See the following URL:
It is about a better way to manage...
September 23, 2010 at 7:15 am
We finally found that some french SQL Server 2008 clients have been install on the network. This was causing the french error message.
For those of you interested to see this...
June 21, 2010 at 1:17 pm
Hi Grant,
This morning we set the treshold to 25. Rigth after that, locking and performance problem arose. We waited but the situation did not tend to return to "normal".
We than...
May 7, 2010 at 8:09 am
Thank's a lot Grant.
We will investigate on this treshold with our load of work.
Best regars.
Carl
May 7, 2010 at 6:53 am
We openned a case with Microsoft Dynamic CRM support in the past weeks and the guy said to me that, with SQL Server 2008, leaving Max Degree of Paralellism to...
May 7, 2010 at 6:52 am
Knight (5/6/2010)
Oh and don't forget, when you make that config change all caches are cleared so expect a temporary hit as they repopulate.
Thank's for this last tips... It may explain...
May 6, 2010 at 9:27 am
Hello Jeffrey,
We are using the build-in Rebuild Index task. I don't see any way to enable or disable statistics recomputation in that task.
Any way, lets say that we were using...
May 3, 2010 at 7:01 am
Yes, I am sure it's not a REORG it's a REBUILD of the indexes.
We noticed that behavior two times.
Now that we have changed the schedule of these jobs, we...
April 29, 2010 at 1:26 pm
We are updating stats WITH FULL SCAN.
Regards.
Carl
April 29, 2010 at 12:50 pm
Hello Grant,
The job is in fact a REBUILD INDEX job.
Yes we changed the schedule to have the update stats job that follow the rebuild index job.
I just wanted to know...
April 29, 2010 at 12:28 pm
Viewing 15 posts - 31 through 45 (of 309 total)