Which tcp/ip port does sql server run on? How can it be changed?
How to update values in a table with update statements in ms sql server?
What is sub-query in sql server? Explain its properties.
What's new in sql management studio for sql server? : sql server management studio
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the downside of using udf?
What is a transactions?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How is sql server used?
What is inner join? Explain with an example?
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?
How many ways to create table-valued functions?