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

jQuery .data() usage

I use .data for storing values instead of accessing DOM elements. I realized and found a better and faster way of it. In fact I have been using  $('#myElementID').data(myKey,myValue); for a while now.    Check out following/ these cases-   The other way for the same is ... [More]

URL Rewriting vs. ASP.net Routing

Those who want to decide which URL routing technique to be used and in which scenario, can have look into "IIS URL Rewriting and ASP.NET Routing" posted by Ruslan Yakushev.   He says: "Either IIS URL rewriting or ASP.NET routing can be used to implement URL manipulation scenarios f... [More]

jQuery intellisense in Visual Studio 2008

Microsoft is promoting jQuery and so Visual Studio 2010 is having inbuilt intellisense for it. But for earlier version of Visual Studio i.e. VS 2008, it can be done by installing kb file.Upgrade Visual Studio 2008 to Service Pack 1 and use the KB958502. This hotfix can be downloaded from -http://arc... [More]

What is SOAP - Simple Object Access Protocol

SOAP is XML based protocol, format-for-sending-messages and used over HTTP.

Web services are used to handle interoperability problem and have given a way to exchange the data in different platforms.

It uses Simple Object Access Protocol (SOAP) to transport data over networks. XML is widely used for structuring, coding data and decoding data. [More]

Update Panel slowness problem

Here are few tricks which can boost the working of Update Panel as they eliminate/minimize the huge data transfer in asynchronous calls.   1.       Set the UpdateMode property conditional for each Update-Panel.      Ex.- UpdateMode="... [More]

Hover Event in jQuery

The hover requires 2 callback functions, one for "mouseover" and another one is far "mouseout". Thus we can say, hover is an ready made solution that is equivalent of binding these two events in following manner -

$('.myHoverClassNameComeHere').live('mouseover mouseout', function(event) {
if (event.type == 'mouseover') {
// do something on mouseover
} else {
// do something on mouseout
}
}); [More]

JavaScript vs JScript vs jQuery

Java Script was created by Netscape for their new version of browser. Initially they released this as part of Netscape Navigator 2.0 with a name "LiveScript". Later they renamed it with "Java Script". Note, Java is a programming language and completely differ. Actually at that time Java was being mo... [More]