what is denormalization and when would you go for it? : Sql server database administration

699

What is the synonym of join?

517

How can you find out how many rows returned in a cursor?

547

How do you debug a procedure in sql server?

492

when you create a database how is it stored? : Sql server database administration

491

what's the difference between delete table and truncate table commands? : Sql server database administration

482

What are 3 ways to get a count of the number of records in a table?

609

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

621

What is difference between equi join and inner join?

480

what is unique and xaml nonclustered index

555

What are points to remember while using the fillfactor argument?

528

Explain about link server in sql server?

533

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

582

What is sql server schema compare? How we can compare two database schemas?

557

What is an expression in ms sql server?

566