Main Page of Questions and Answers

• Can we use Truncate command on a table which is referenced by FOREIGN KEY (1)
• Can you explain the role of each service (1)
• Can you explain the types of Joins that we can have with Sql Server (1)
• Can you give an example of Stored Procedure (1)
• Can you give me some DBCC command options (1)
• Can you link only other SQL Servers or any database servers such as Oracle (1)
• Can you tell me the difference between DELETE (1)
• From where can you change the default port (1)
• How do you troubleshoot SQL Server if its running very slow (1)
• Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take (1)
• Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow (1)
• Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot (1)
• Miscellaneous questions (1)
• schema and views from one SQL Server to another (1)
• TRUNCATE commands (1)
• What are cursors (1)
• What are the authentication modes in SQL Server (1)
• What are the OS services that the SQL Server installation adds (1)
• What are the types of indexes available with SQL Server (1)
• What command do we use to rename a db (1)
• What do you mean by COLLATION (1)
• What is a Join in SQL Server (1)
• What is a Linked Server (1)
• What is a Stored Procedure (1)
• What is a trigger (1)
• What is a view (1)
• What is an Index (1)
• What is BCP When do we use it (1)
• What is log shipping (1)
• What is normalization (1)
• What is the basic difference between clustered and a non-clustered index (1)
• What is the difference between a HAVING CLAUSE and a WHERE CLAUSE (1)
• What is the use of DBCC commands (1)
• What should we do to copy the tables (1)
• When do we use the UPDATE_STATISTICS command (1)
• When do you use SQL Profiler (1)
• Where do you think the users names and passwords will be stored in sql server (1)
• Which stored procedure will you be running to add a linked server (1)
• Which TCP IP port does SQL Server run on