A mindful brain

Some days back I have been come to contact with a very nice person who has really mind clowing brain. I readt all it out from her descent writtings her style of writting an expressing the matter among someones.I must appreciate to visit her blog : http://www.shwetagupta.com/blog/. The only and the only name in my

Read More

Just-in-Time [JIT]

JIT compiler is a crucial component of the .NET framework. The JIT compiler converts IL to machine code, which is then executed. The JIT compiler does not compile the entire code at once because it could hamper the performance of the program. It compiles the code at runtime, at the time it is called. The

Read More

Common Language Runtime [CLR]

Let’s rewind our mind to ancient era, when there is no existence of CLR concept, what happened when we invoke the language program or code. Basically, languages consist both compiler and runtime environment. Compiler converts or compiles code to executable files [known as PE (Portable file) files], which can be run by the users, in

Read More

.NET framework

.NET framework is a Tool, which provides an environment for building, deploying and running web services and other application. It also predicts from above figure that .NET framework [see fig11] consists of CLR and a single of unit of complete set of Class Libraries, provides the scarcity to develop Windows applications and Web Application with

Read More

The Object Oriented approach

The fundamental idea behind object-oriented languages is to combine into a single unit both data and the functions that operate on that data. Such unit is called an Object. An object functions, called member function in OOP, typically provide the only way to access its data. If you want to read data item in a

Read More

Stored procedure with a parameter and output parameter

The following example is for Microsoft SqlServer. One can try and run this is for learners.Step-1 Create a Stored ProcedureCREATE PROCEDURE uspGetContact @LastName NVARCHAR(50), @ContactID INT output AS SELECT TOP 1 @ContactID = c.ContactID FROM HumanResources.Employee a INNER JOIN HumanResources.EmployeeAddress b ON a.EmployeeID = b.EmployeeID INNER JOIN Person.Contact c ON a.ContactID = c.ContactID INNER JOIN

Read More

SET SHOWPLAN_TEXT

Syntax: SET SHOWPLAN_TEXT { ON OFF }Remarks: The setting of SET SHOWPLAN_TEXT is set at execute or run time and not at parse time.SET SHOWPLAN_TEXT ONGOUSE pubsSELECT * FROM royschedWHERE title_id = ‘PS1372’GOSET SHOWPLAN_TEXT OFFGO

SQL Server script to rebuild all indexes for all tables and all databases

A very good and useful script for DBA DECLARE @Database VARCHAR(255)DECLARE @Table VARCHAR(255)DECLARE @cmd NVARCHAR(500)DECLARE @fillfactor INT SET @fillfactor = 90 DECLARE DatabaseCursor CURSOR FORSELECT name FROM master.dbo.sysdatabasesWHERE name NOT IN (‘master’,’model’,’msdb’,’tempdb’,’distrbution’)ORDER BY 1 OPEN DatabaseCursor FETCH NEXT FROM DatabaseCursor INTO @DatabaseWHILE @@FETCH_STATUS = 0BEGIN SET @cmd = ‘DECLARE TableCursor CURSOR FOR SELECT table_catalog +

Read More