Viewing 15 posts - 9,316 through 9,330 (of 39,771 total)
Charps (8/10/2015)
August 10, 2015 at 1:01 pm
I'm not sure it's hubris, but more a question of having a view of your code that you can count on for future work. Certainly some of us work in...
August 10, 2015 at 12:58 pm
robert.sterbal 56890 (8/10/2015)
Glen Berry's are a good example of what would be great on a...
August 10, 2015 at 12:54 pm
Jayanth_Kurup (8/10/2015)
SQL express cant be used as a publisher in replication
I don't believe this was the intention. It seems as though SQL Standard is the publisher, moving to a variety...
August 10, 2015 at 12:52 pm
I'd still suggest they add each of your DBAs, use a group for access, and disable all accounts. Then when an issue arises, they can activate only the account needed.
August 7, 2015 at 4:51 pm
Brian J. Parker (8/7/2015)
August 7, 2015 at 1:00 pm
I'm not 100% sure what will happen if you change the replicated values. I'd think you're OK, but I'd have to test some things, and you should as well.
I...
August 7, 2015 at 10:25 am
1. Always worry. You should be fine, but if you aren't looking, you'll have issues. Try checking this: https://msdn.microsoft.com/en-us/library/ms142490.aspx
2. I think you should be OK, but I'd prep clients that...
August 7, 2015 at 10:20 am
Grant is right on the main issue. Secondary ones are more disk space, potentially lots more. Some systems have more index data than real data.
Also, slows down backup/restore with more...
August 7, 2015 at 10:12 am
Never share IDs, including service accounts. That's my philosophy. I don't even like SA available.
Always use groups. If one person needs access, someone else will.
As for preventing new additions, you...
August 7, 2015 at 10:08 am
delizat (8/7/2015)
Every situation is different, but this is the order of my backup jobs:1. Reorganize/Rebuild index
2. Check integrity
3. Update Statistics
4. Backup database.
I don't like this as if the rebuild and...
August 7, 2015 at 10:07 am
SQLRNNR (8/7/2015)
My recommendations would be to use either of these two products because they work better.
or
+1 here for me. I like the SQLFool script, but hear good things about MInion
August 7, 2015 at 10:05 am
One further note, if you're going to do this programmatically, and more than once, you'll get the same issue with filenames. Perhaps if you restore you want to have the...
August 7, 2015 at 10:04 am
One note I'll add, at the one company where we did this every month, it was self funded. The company didn't really contribute, and it was a good sized company...
August 7, 2015 at 9:53 am
chill8 (8/7/2015)
August 7, 2015 at 9:51 am
Viewing 15 posts - 9,316 through 9,330 (of 39,771 total)