CodePattern.net

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]

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]

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]

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]

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]

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]

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]