How to Read the SQL Server log files using T-SQL

The system stored procedure sp_readerrorlog allows to read the contents of the SQL Server error log files directly from a query window and also allows to search for certain keywords when reading directly from the error file.Lets check following sample: – CREATE PROC [sys].[sp_readerrorlog](@p1 INT = 0,@p2 INT = NULL,@p3 VARCHAR(255) = NULL,@p4 VARCHAR(255) =

Read More

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