I am a newbie to MS SQL. We are using MS SQL 2008 R2 in Windows 2008 server.
1). I want to tune a developer's queries, views and stored procedure. How can I open up the explain plan from Management Studio?
2). Can you list most common MS SQL server administration commands for DB admin to manage the server?
3). If complained the query running very slow or the report running slow, what steps should I take to troubleshoot this issue?