Tag Info

New answers tagged

0

I am running 2008 R2 with 46GB of Ram. No virtual machines. SQL Server 2008. Databases are about 300GB. I put the databases on a solid state drive recently and tripled my data output. The server is currently using 45GB of Ram and running good. FC Sata Raids and SAS SCSI Raids. 26 logical drives in all. 144 Spinning disks. Yesterday I was only using 24GB ...


0

Ok, I have not messed with the file share subscriptions so I had to set this up locally on my machine to mess with it. The only thing I can even come across in MSDN that talks about the username for this type of subscription is here: Password: Specify the password for the Windows user name. Out of that the only thing I can find is that it requires an ...


0

Another approach would be to create UNION ALL view: select 'REDACTED' name, employeeclass, confidentiality_ind from students where (CONFIDENTIALITY_IND = 'Y' or EmployeeClass = 'XA') and not <privilege check> union all select name, employeeclass, confidentiality_ind from students where not (CONFIDENTIALITY_IND = 'Y' or EmployeeClass = 'XA') or ...


0

In Oracle 11.2.0.3, Virtual Private Database allows you to hide rows or columns. For example: create or replace function check_confidentiality( p_schema in varchar2, p_object in varchar2 ) return varchar2 as begin return 'not (CONFIDENTIALITY_IND = ''Y'' or EmployeeClass = ''XA'')'; end; / call dbms_rls.add_policy( object_schema => 'schema', ...


0

what you can do, is to write two stored procedures with the following logic: Build a stored procedure which does the case thing. This may be optional but the resulting sql would look better and easier to debug/develop. Define a stored procedure which has as input the tablename Read out the columns of the table - maybe here can be done some ...



Top 50 recent answers are included