What do you understand by replication in sql server? Mention the different types of replication in sql server.
Is it safe to delete log files?
How to rebuild the master database?
What is a subquery in a select query statement in ms sql server?
Explain what are the restrictions while creating batches in sql server?
How to check if stored procedure is running in sql server?
What is ms sql server index?
What does this statement do @@rowcount?
Does a sql server 2005 select statement require a from?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What are the rules to use the rowguidcol property to define a globally unique identifier column?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?