CodePattern.net

Understand Sealed Class in C# programming [More]

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

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

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]

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 statemen... [More]

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]

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

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 WHER... [More]

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 [... [More]

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]