Information Technology,Software Programming,PL/SQL Tips Tricks for error resolution ,SQL version 2014,2012,2008,2005,Procedural language,Stored Procedure, computer , excel macro programming,Visual Studio,Musical notations,Indian ,Western Music Lyrics,Chords.

November 20, 2015

Disadvantages of materialized View in SQL

Following are the Disadvantages of materialized View in SQL

1.We can not perform any DML Operations on materialized View ,but you can perform DDL Operations like DROP.The thing is here it stores the all records even if it is duplicate or non-duplicates,especially which we are using aggregate values.For example daily loads,monthly loads,yearly loads.such cases it would be very helpful storing of entire data if it is new or old.

The disadvantage is takes space Can only be based on a simple Select if you require real time data. maintaining the materialized View  Logs has an overhead on the master system.

2.We can't perform DML on materialized View  because it is like snapshot or read only .it is mainly used for reporting purposes.A materialized view can be either read-only, updatable or writable. We Can't Perform DML on read-only but can Perform DML on updatable or writable.

3.On readable - we cant perform DML.
on updatable- we can perform DML, we need to create the materialized View  by using FOR UPDATE clause and it must belong to materialized group.

on writable- if we create a materialized View  by using FOR UPDATE but do not assign a group it would become writable, we can perform DML but as soon as you refresh the materialized View, changes will be lost and will not be pushed to master table.

What is the Difference between count(*) and count(1) in SQL

Following are the Differences between count(*) and count(1) in SQL

1.COUNT(*) will include NULLS but it counts no.of ROWS in a TABLE,
COUNT(column_or_expression) counts no.of NOT NULL values within a COLUMN.

2.COUNT(*) is depend on full table but COUNT(1) is depend on only one column and both are given same output.

September 3, 2015

Difference between collection and bulk binding in SQL

Following at the Differences between collection and bulk binding in SQL

To retrieve multiple rows we can use cursors or bulk collections.
Cursors row by row mechanism so performance decreased.
But collections not row by row process all rows retrieved at time so performance increased.

And bulk bind means doing DML(data manipulation language) operations as a bulk.

By using for all statement we can do bulk-binding.

If you want to do bulk-bind first should use bulk collections .

July 27, 2015

Get Name,SID for user for windows

To Get Name,SID for users for windows  there are many ways to get that . SID full name is Security Identifier.

1. You can execute regedt32.exe  command from run mode. Go to HKey_Users and you can see sid of user like following picture.


2.Second way you can use command on command prompt and run the following command.

wmic useraccount where name='username' get sid

To get details in file you can use below way.

wmic useraccount where name='username' get sid > c:\sid.txt

3. To get All users SID you can use below command.

wmic useraccount get name,sid

To get details in file user below..

wmic useraccount get name,sid> c:\sid.txt

June 9, 2015

How to Reduce Microsoft Outlook Data file size

Sometime out Outlook Data file size become big and it's not getting decrease after deleting of lot of old mails then there is one option to decrease data file size of outlook.

You need to use compact option of outlook file. Below are step to do it.

1. Delete items that are old dated and not required.

2. Go to File tab->Account Settings-> Account Settings.

3. Go to Data Files tab, select the data file that for compacting purpose then you can  click Settings     then Click On Compact Now.

Outlook Express
Outlook Express
Outlook Express