Why would you call update statistics?

585

How do I find the port number for sql server?

505

What is an inner join?

530

What are page splits? : SQL Server Architecture

544

How to list all user defined functions in the current database?

518

How to change the system date and time from SQL Plus Terminal ?

687

Are semicolons required at the end of sql statements in sql server 2005?

570

What do you understand by mirroring?

570

How to use “drop” keyword in sql server and give an example?

688

Explain tablesample?

555

What is the command used to recompile the stored procedure at run time?

625

Can we insert data into a view?

574

Where are SQL server users names and passwords are stored in sql server?

719

What is the maximum length of an alert name?

606

Explain the collation?

627