How to create sub reports?

252

Write a query to find 5th highest amount paid from the customer table.

994

how to control the amount of free space in your index pages? : Sql server database administration

1087

What are the different ways you can create databases in sql server?

1159

What are data files?

1096

How to trouble shoot if unable to connect SQL Server

2034

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1101

How to stop log file growing too big?

1066

What is blocking and how would you troubleshoot it? : sql server database administration

1101

What is difference between aggregate and analytic function?

978

What is a hint?

1060

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

952

What is subquery in sql?

1131

What are the differences between lost updates and uncommitted dependencies?

1151

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1176