Sealed Class in C#

Understand Sealed Class in C# programming [More]

JQUERY 1.8 first BETA release

jQuery 1.8 first BETA version is released and can be experienced by downloading it from jQuery CDN. [More]

How to find checked value of radio button using jQuery

We can find the checked value of a radio button using :checked attribute and radio button's name as a selector.    

System.Web namespace

The System.Web namespace contains the important base level ingredients for ASP.NET applications. System.Web namespace is an important base for Web Form user interface and web services. Use of Built-in Objects like Request and Response are very common and widely used. We directly write them without creating objects as they are built-in objects.This namespace has following built-in Objects : (1) Request (2) Response (3) Server (4) Application [More]

List of all Tables without Indexes in MS SQL

How to get the list of all tables that are not having any indexes on them : Today, I got a question on this and decided to put the way here also.  SELECT [name] AS Tables_Without_Indexes FROM sys.tables WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0 ORDER BY 1; The above statement will giv... [More]

How to get all existing indexes of a table in SQL

There is a system stored procedure “sp_helpindex”, which can be used to get the list of all existing indexes by supplying table name to it. We can use this stored procedure as – EXECUTE sp_helpindex my_Table_Name [More]

SQL Server database diagrams

I was looking for SQL Server diagram understanding and found a good article on Atif Shehzad.One can find and read this nice article - Getting started with SQL Server database diagrams

Check the Enable status of Triggers in SQL

We can use sys.triggers view (object schema view) to know the status of trigger(s) in a database. USE [myDatabaseName] GO SELECT * FROM sys.triggers WHERE [is_disabled] = 1 ; -- 0:Enabled and 1:Disabled   To get the status of a particular trigger: SELECT * FROM sys.triggers WHERE [Name] = '... [More]

Disable Triggers in SQL

Two easiest command syntacx to disable /enable existing triggers on table are as below-   To Disable- ALTER TABLE [mySchemaName].[myTableName] DISABLE TRIGGER myTriggerName OR DISABLE TRIGGER myTriggerName ON [mySchemaName].[myTableName]   To Enable- ALTER TABLE [mySchemaName]... [More]

How to Speed-up Triggers in SQL

Triggers are used to implement business rules, automate or to enforce referential integrity in database applications. Some important points/info about Triggers are -1) Avoid using cursor in Triggers.2) Avoid executing many sql statements on other tables also.3) Avoid returning multi-row-results... [More]