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
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.
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
Two easiest command syntacx to disable /enable existing triggers on table are as below-
ALTER TABLE [mySchemaName].[myTableName] DISABLE TRIGGER myTriggerName
DISABLE TRIGGER myTriggerName ON [mySchemaName].[myTableName]
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
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.
"Either IIS URL rewriting or ASP.NET routing can be used to implement URL manipulation scenarios f... [More]
3. June 2011
Asp.Net , jQuery
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]