Viewing 15 posts - 15,436 through 15,450 (of 39,941 total)
Interesting, I'd never used ALL.
You could wrap in ISNULL to handle NULLs, and return zero's instead (or some other value).
August 15, 2011 at 8:26 am
Profiler is a great way to help. The other thing I'd suggest is that you start building documentation as you go. Note what you think tables are used for and...
August 13, 2011 at 10:27 am
Jobs fail or don't run sometimes. There is no guarantee that a job restarted your server every day.
I have had a few people claim the limit is 99 logs which...
August 13, 2011 at 10:24 am
The import/export wizard is the easiest way.
There is no copy/paste function you can use. Any other method, outside of a third party tool, will be slightly more complicated.
August 12, 2011 at 6:30 pm
First, even if you uncheck that box, I'm not sure SQL Server keeps an unlimited number of logs. I haven't found documentation and don't really want to restart an instance...
August 12, 2011 at 5:40 pm
Sorry, didn't realize you're posted that. Just so we're clear, you have log shipping set up on a primary and secondary server. The primary server (source) has logs set to...
August 12, 2011 at 12:41 pm
Brandie Tarvin (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
- work in a complex development environment that does automated builds at high volumes (> 1x...
August 12, 2011 at 11:27 am
I wouldn't think log shipping would require a restart. If you check the log shipping tables, are your settings changed?
August 12, 2011 at 11:26 am
Ray K (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
lots of the food isn't as great as what you can get a block or two outside the stadiums.
After that game at...
August 12, 2011 at 10:21 am
Have you checked the times on the servers? Make sure they're the same? I might look for some timing differences that cause things to delete. Even a few minutes over...
August 12, 2011 at 10:20 am
It sounds like you are on the ball with this one. I'd do the copy, and not add the complexity or possible issues from the open file read.
August 12, 2011 at 10:08 am
Is anyone here working with, or struggling to
- work in a complex development environment that does automated builds at high volumes (> 1x day)
- handle complex continuous development or...
August 12, 2011 at 10:07 am
Roy Ernest (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
Once again I feel like I've let too much time go without writing a book 🙁
Planning to write a book then? If so,...
August 12, 2011 at 10:02 am
OK, this has gotten slightly out of hand and away from the purpose of the thread, which is discussion the question.
I am closing the thread. The question had been edited,...
August 12, 2011 at 9:46 am
Viewing 15 posts - 15,436 through 15,450 (of 39,941 total)