What is the maximun sixes of .mdf in sql server 2005
Can you tell me the difference between DELETE & TRUNCATE commands?
Equi join and non equi join is possible with sql server?
Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How can you see what type of locks used?
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?
What is trigger and different types of Triggers?
What is de-normalization and what are some of the examples of it?
What is raid and what are different types of raid levels?
In what sequence sql statement is processed?
write query for fourth maximum salary from employee table
14 Answers Mind Tree, SP Software,
in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?