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 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]