On the basis of name, visibility and availability, Temporary USP, further classified as -
i) Local (#, to current user connection, auto deleted when connection is closed)
ii) Global (##, to any user after creation, auto deleted when the last session using proc ends) [More]
Being a Chapter Lead, I organized this event with help of executive members on technology discussion so named it “Technology Day”. We did this meeting on 3rd August at Unit Nexus Corporation, Zirakpur with help from SSS & Educational Society, Gorakhpur. [More]
It is a general practice to ask practical oriented questions that help interviewer to understand the ability of candidates. These practical oriented questions can be answered easily on the base of experience.
Can we create a View on a table which is not exist in database ? (in MS SQL)
When will you use View and when Stored Procedure?
Can we disclose only 10 WCF functions out of 15 to a particular customer or user ? (in WCF)
Suppose we want to charge customer based on no of calls made to our WCF function, so is it possible to do so in WCF? [More]
In Oracle, it is created with help of FORCE VIEW with Create command. But, In case of MS SQL, it is not possible to create a View on table/view that is not exist in database. [More]
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. [More]
MS SQL 2012 or its previous version MS SQL 2008 has inbuilt statement completion feature. This can be set for all languages or for T-SQL only. [More]
Microsoft SQL Server 2012 has a customized clause for paging and it is efficient. Custom paging is the option for handling huge records. [More]
In this blog I am not going to write a big epic on how to crack interviews but just briefing on it i [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
WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0
ORDER BY 1;
The above statement will giv... [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]