Thursday, April 25, 2013

[MS SQL Server] Select permission failed on underline object in Views

[MS SQL Server] Select permission failed on underline object in Views

Select permission failed on underline object in Views

Posted: 25 Apr 2013 05:27 AM PDT

I need to configure a user to run only a view and nothing else on the server (SQL Server 2008 R2). They should have permission to run the view and see the data it returns but not have permission to the underlying tables. Lets say the view is called TestView and the user is called TestUser. What SQL script can be run to configure this user with permissions to only run the view which exists in a database called TestDatabase?I did the following things but still getting error message like "Select permission was denied on the object" and this object is a table which is on different databases.1. Enabled the ownership chaining.2. Views and tables owners are dbo.Any help would be appreciated.

CXPaxket waits causes high CPU ?

Posted: 25 Apr 2013 01:17 AM PDT

Hi,Can anyone please confirm does CXpacket waits causes high CPU...because we got high cpu alerts yesterday on my environment...when i look into monitoring tool...i can see a spid (stored proc which does delete) and in suspended mode.Wait type : CXPacketWait time : 893575physical io : 968Server Specs :sql 2008 sp2, standard edition 64-bitwindows server 2008 R2 standard editionProcessors : 2Memory : 12 GBPlease let me know if you need any detailsThanks in advance

SSIS - VB/active x equivalent

Posted: 25 Apr 2013 01:40 AM PDT

Hi all,I've only used sql2000 and have managed to get DTS tasks to do all the weird and wonderful stuff that comes up. I've used the ActiveX task alot to include stuff within a DB task that often has nothing to do with databases as such, but is part of a data process none the less.I have installed 2008 and I am playing with it and getting mostly confused =)I was taking a look at the Visual Studio esque SSIS tool and was wondering if there is anything similar to get some script into your task in 2008..?ThanksSORRY ignore this I have found them under the control tabThanks

Maintaining Statistics

Posted: 24 Apr 2013 06:35 PM PDT

Hi,I am having a little issue in understanding how to implement a good maintenance plan in updating statistics. I have more than one db with very big tables and modifications done every day. I know for sure that the Auto Upate Statistics is not enough for our performance, so i need to update them mannually.From all the material found online, i managed to get two queries: one for updating all the statistics created for indexes and one for updating all the statistics auto-created.For updating the statistics for indexes, i use a query from sys.sysindexes, sys.objects and sys.schemas, by finding a percentage between the rowmodctr and rowcnt columns. Based on this percentage, i update the statistics. Also, i use STATS_DATE to update all old statistics.For updating the auto-created statistics, the column statistics, i use a query that checks the column modified_count from sys.system_internals_partition_columns. I did not found a lot of documentation on this system internal view, so i don't really know how exactly can i analyse the column modified_count to know which statistic need to be updated.How can analyse the field modified_count from sys.system_internals_partition_columns so that i could find out which statistic needs to be updated?Or, is there another way i could analyse every auto-created statistics (columns statistics) so i can know which one should be updated?Thank you!

Best practices for SQL install - separation of SSIS / SSRS / SSAS?

Posted: 24 Apr 2013 08:31 AM PDT

Can anyone point me in the direction of any best practice guidance on installation of reporting services / IS / AS on separate servers to the SQL DB services? I've just moved from a site that habitually separates each onto separate servers to one that doesn't and I can see benefits of both options so am looking for some guidance please.Thanks.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog