Help for Some Questions - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Help for Some Questions

Author

Topic

khanewal
Starting Member

33 Posts

Posted - 2011-06-21 : 09:18:48

Hello Team,

first of all thank you because whenever I'm in trouble you all always help me, hopefully this time again you will help me for clearing my concepts.

1 - I need to assign Execute only permission to the user on current Store proc and future new procedures. can you please answer me from the following four options, I selected B, but not sure if it is correct.
A - Assign Fixed Database Role
B - Assign Object Level Permission
C - Grant Specif DB Level Permission
D - Assign Server Level Role

2 - A Customer table has update for every one hour with Redundant data and need to compress, what compression we will apply, I selected B
A - Row Compression
B - Page Compression (if there is Redundant data what we can use)

3 - Db using bulk mode recovery model, Log shipping done by WAN Link , and log are using a lot of space, how to reduce the size of log files
A - Compress Logs
B - change Full recovery model
C - Change simple recovery model

4 - I'm upgrading SSRS, and need to make sure it records the version control, how to achieve this
A - Install in Native mode
B - Use Sharepoint Integrated Mode

I will be very thankful if you clear my concepts for the above question.

Regards,

Your Friend

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-06-21 : 10:06:18

1. B is correct for the current procedure but won't give permission on future SPs
2. Depends on what the redundant data is (is it across rows, within columns, across columns in a row) but page compression includes row compression and is probably what is being looked for.
3. Looks like A - B won't help, C won't work
w. Depends on what you mean by version control.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

khanewal
Starting Member

33 Posts

Posted - 2011-06-21 : 10:18:52

Thanks Friend for your quick reply,

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources