Information Technology,Software Programming,PL SQL Tips for error resolution,Research,Development,SQL 2014,2012,2008,Procedural language,SP,excel macro ,Musical notations.

April 28, 2016

Error during setting SQL Maintenance plan wizard setting


Getting Error during setting SQL Maintenance plan wizard setting.

"Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)"


This type of error comes due to t the unregistered COM in dts.dll which is located in

in command line change directory and path of dll file is  C:\Program Files\Microsoft SQL Server\100\DTS\Bin

You can run the following from the command line to resolve this error:

REGSVR32.EXE dts.dll

Then you need to disconnect from management studio and reconnect, it again then set SQL Maintenance plan wizard again it should work.

I hope this will solve to come out from your troubleshooting.

April 7, 2016

How to handle disk space issue on C drive

Mostly we face space issue in C drive . How to handle disk space issue on C drive?

Following are the steps you can use to free some space in c drive.

1. Go to event viewer and clean all logs.
2. Use disk cleanup properties on c drive to clean unwanted logs.
3. Clean CBS log file at C:\Windows\Logs\CBS folder.
4. Go to %userprofile%\desktop folder and transfer all files to other drives.
5. Set virtual memory to other drive instead of more on c drive.
6. Uninstall unwanted program from control panel ->Program and features.
7. Clean temporary folder from internet explorer.
8. You can use ccleaner software to clean logs.
9. Empty Recycle bin folder.
10. Find duplicate files and delete it.

March 27, 2016

What is difference between btree indexes and bitmap indexes?

1)Btree index:when ever we are requesting data using btree indexes columns using where clause then oracle server searching for indexes in database,if btree indexes columns are available in database then oracle server automatically creates btree structure,through btree structure only oracle server retrieve data very fast from data base .

2)Bitmap index:when ever we are using bitmap index then oracle server automatically creates bitmap table,it is mostly used in data-ware house applications.bitmap index is high performance compare to btree index because bitmap index internally creates bitmap table.

3)By default indexes are btree indexes. When ever we are creating the primary key ,unique key constraints automatically btree indexes are created.

If you want to create bitmap index then explicitly you have to mention the bitmap keyword at the time of creation of index. Bitmap index mostly created on lo cardinality columns.the table having wide range values.

February 26, 2016

What is an Embedded system?

An Embedded system is any computer system hidden inside a product other than a computer.
 You will encounter a number of difficulties when you writer embedded-system software in addition to those you encounter when you write applications.

Throughput— Your system may need to handle a lot of data in a short period of time.
Response— Your system may to react to events quickly.
Testability— Setting up equipment to teat embedded software can be difficult.
Debug ability— Without a screen or a keyboard, finding out what the software is doing wrong is a trouble some problem.
Reliability—Embedded systems must be able to handle any situation without human intervention.
Memory Space—Memory is limited on embedded systems, and you must make the software and the data fit into whatever memory exists.
Program installation—You will need special tools to get your software into embedded systems.
Power Consumption—Portable systems must run on battery power, and the software in these systems must conserve power.
Processor Hogs—Computing that requires larger amounts of CPU time can complicate the response problem.
Cost—Reducing the cost of the hardware is a concern in many embedded system projects; software often operates on hardware that is barely adequate for the job.
Embedded systems have a microprocessor and a memory. Some have a serial port or network connection. They usually do not have keyboards, screens, or disk drives.

January 11, 2016

Platform Independence of .NET Platform,Advantage,Disadvantages

Platform Independence of .NET Platform

Its lang independent as long as that language's compiler targets the managed environment.. i.e, code written in or VB.Net or any other .Net compliant language will result in the same IL.
certainly .net doesn't compile in UNIX. No compilers til date i suppose.. Heard that something similar exists to compile .net in Linux tho'..

Platform Independent does not mean O S independence in .NET terms. It means you can build a managed code and be assured it works on 32 - bit m/c, 64 bit m/c etc. Of course, at present it only supports Windows as O S, but Microsoft has left open the UNIX ( or any other O S for that matter) implementation of .NET run time. Lot of open source projects are going on in this regard.

Advantages of asp with c sharp over asp with

ultimately both copies in to MSIL, it depends on what application designing and what is the background of the developers who work for.

C# more structured and fully OOP enabled, even VB is OOP enabled, but I don't thing VB.Net supports operator overloading etc..

There is only Syntactical difference between these two:
1)Vb.Net is not Case Sensitive while C# is.
2)Statement Delimiter in VB.Net you use carriage return to separate sentences while in C# you need a ;(Semi Colon)
3)Declaring variables.
4)Data type names line integer in VB.Net and int in C#.

ts is just political choice for the PM/DM to choose C# or VB.Net with ASP. (Excluding resource capability matrix)

In my career graph, I have never seen the problem which tends to write operator overloading for the web application domain. Frankly, operator overloading may be targeted where responsibilities are driven with some kind of mathematical equation...

Its true that ASP.NET is more popular with C#. But, it has nothing to do with language capabilities but at the root where we people start learning OOPS(C++). And we imagine "class" more closer with C# syntax. There are other psychological phenomenon are there... but i don't have rights to bog you people.

Differences between .NET application and a Java application

Net is a technology, Java is a programming language.
.Net is emerging, java is already well established.
this question in a interview is to test your presence of mind and to see how many differences you say, is something like asking difference between a rose and lilly.