Viewing 8 posts - 211 through 218 (of 218 total)
First, it's unadvisable to shrink the log file if it grows to that size a couple of times a week. You take a major performance hit when the log...
March 26, 2010 at 3:44 pm
What the previous poster said, plus OLTP or Warehouse.
There is no one size fit's all approach.
March 26, 2010 at 3:27 pm
Ultimately, before anything else, you have to make sure that the environment is supported my MSFT.
It used to be the case, that on VMWare, SQL was not support in production,...
March 26, 2010 at 2:08 pm
Have you enabled logging (under the advanced tab of the job step properties)? If not, enbable it, then check the log file for more detailed info.
Also, copy the job...
March 26, 2010 at 2:02 pm
I really don't see what the point would be. It's not really best practice to split files based ono size of the file, but instead, on the IO requirements.
When...
March 26, 2010 at 1:42 pm
srinivasreddy4uhyd (3/11/2010)
Correct me If I am wrong.
My situation is I want to restrict group of accounts which can login from some...
March 11, 2010 at 3:59 pm
I've been a SQL DBA since 1998, never taken a certification test. My resume speaks for my qualifications, not a test of theoretical knowledge that many people memorise for...
March 3, 2010 at 8:22 am
As for scaling, I am not sure how well it would handle thousands of logins per second. My best advice would be to add at the begining of the...
March 3, 2010 at 7:37 am
Viewing 8 posts - 211 through 218 (of 218 total)