Log in | Register

Edominer Peoplewareindia, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Edominer Peoplewareindia, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education



About Edominer Peoplewareindia

This author has not yet filled in any details.
So far Edominer Peoplewareindia has created 9 entries.

SQL Server sp purge jobhistory – To delete job history

Hello Geeks,

Beginning with SQL Server 2005, as part of the Database Maintenance Plans, MS introduces the “History Clean Up” tasks. SQL Server stored procedure SQL Server sp purge jobhistory removes the history records for a job. It returns 0 (Success) or 1 (Failure).


{   [ @job_name = ] ‘job_name’ |
| [ @job_id = ] job_id […]

By |January 28th, 2014|Categories: SQL Server|Tags: |0 Comments

The description for event id 22 from source mssqlserverolapservice cannot be found

SQL Server – The description for Event ID 22 from source MSSQLServerOLAPService cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component.

One day a client informed us that their SQL Server Analysis Services was not […]

SQL Server Architecture Part 2: The Relational Engine

In the previous article of this series, we discussed about the overall SQL server architecture and the Network Interface (specially). In this article we’ll discuss about the next, but very important component of SQL Server’s Database Engine i.e. the Relational Engine.

Relational Engine

Also known as the Query Processor, the relational engine is responsible for the […]

SQL Server Execution Plan – Part 1 (Basics)

Hi geeks,

First of all I would like to make an apology for not posting any blogs for the last two months (was busy with my work) but it’s better late than never….

Today I am blogging about SQL Server Execution Plan but this topic is so huge that I have to divide this into multiple […]

SQL Server sp_help_job – To get the status of a SQL Job

Hello Geeks,

I would like to thank Amit Sir for giving me the opportunity to blog on SQL Server topics. This being my first blog, I am staring with SQL server system stored procedures.

Today I will cover SQL Server sp_help_job system stored procedure. In our work place we have lot of SQL jobs. Some of […]

SQL Server Constraints


SQL Server Constraints can be defined as rules that govern the values that are inserted into a column. These rules help in enforcing data integrity. For example if a NOT NULL constraint is defined over a column in a particular table, it means that column will not accepted any NULL values.

Constraints used in SQL […]

SQL Server Architecture Part 1

Hello Readers,

This is the first part of the series of articles describing the SQL Server architecture. But before starting the discussion, I would like to thank Amit Sir for giving me the opportunity to Blog in SQLServerGeeks.com and share my knowledge with you.

In order to begin the study of any technology, the best approach […]

SQL Server Track Deprecated Features with Extended-Events

Hi geeks,

hope you all enjoyed my last blog on SQL Server Statistics Only database.

In this blog we will explore one possible solution to the problem all database developer and administrator have during SQL Server upgrade from one major release to another. Every new release of SQL Server brings some new features to the world […]

SQL Server Statistics Only Database

Hi Geeks,

First of all I would like to thank Amit Sir and SQLServerGeeks.com for giving me this opportunity to blog.

This is my 1st blog on SQL Server Statistics Only Database, so I am pretty much excited about it, hope you all will like it.

In this blog, I will show you a technique of re-producing […]