Viewing 15 posts - 616 through 630 (of 1,155 total)
Follow the great advise from Steve. He is correct.
First make sure that each instance has been configured with Max memory otherwise if one instance uses max memory on the box,...
May 2, 2011 at 6:56 pm
TempDb and Memory are completely 2 different concepts. You can't replace the tempdb functionality with memory. Tempdb will be in use even though you have lots of free memory for...
May 2, 2011 at 6:55 pm
I have that experience too. What I usually do is when I execute the scripts on the target, I usually remove the @schedule_uid and will edit the schedules appropriately. That's...
May 2, 2011 at 6:35 pm
Follow Ninja's advice. Use the Grant\ Deny to the securables.
...
May 2, 2011 at 6:26 pm
Very good recommendation from Mister Magoo. That's exactly the thing that you were looking for.
...
May 2, 2011 at 6:25 pm
SQL Server 2008 has a new feature for Auditing. You can audit anything happening on the SQL Server using this feature. Its a full pledged Audit implementation and it's very...
May 2, 2011 at 6:05 pm
Average disk queue length (Total) doesn't give you any good insight. It gives you the average values of the all disks (Including C and D) as a whole which will...
May 1, 2011 at 11:33 am
Syed Jahanzaib Bin hassan (4/22/2011)
2-You have define Max Degree of Parallelism to 8,This will define as 2 because its depend on physical processor not on logical
3-Set MAX worker Thread 704...
May 1, 2011 at 10:40 am
Follows Steve's Great Advise. He is right.
RAID 5 has be avoided like Plague for Databases. The best options are RAID 1 or RAID 10. Usually the difference is Cost. RAID...
May 1, 2011 at 10:14 am
As John Mentioned, Please post the SQL error msg if any, from the SQL Error Logs or Windows Application Logs. If this is a JBoss error, the posting a JBoss...
May 1, 2011 at 9:24 am
It's not a good practice not to use a Linked Server. They work well with heterogeneous data sources. If you have good knowledge of configuring the security, they don't...
May 1, 2011 at 8:52 am
Follow the Great advice from Gail. I agree with her.
It shouldn't be enabled unless you have a very strong reason to do so and only after contacting MS.
...
May 1, 2011 at 8:19 am
Very well said Sachnam....
Follow his advise. You never should insert millions of records at a time. Insert them in small batches.
Go with Simple recovery model and small batches.
...
May 1, 2011 at 8:14 am
Viewing 15 posts - 616 through 630 (of 1,155 total)