performance tuning is a vast topic and you need to explain that to the interviewer, if he is looking for a specific answer he should know better. Performance tuning is...

As a first try you could try replacing the subqueries with joins. Also verify the right indexes are in place.

Additional information :-

Transaction isolation levels allow you to control behavior such as dirty reads.

Also lock escalation decide if the entire table gets locked and prevent updates and inserts from happening...

I agree when done properly Agile is great for the developer , in fact I have enjoyed working in this manner coz it allows me to do just enough coding,...

Also you could check if the server your trying to connect to allows remoted connection , i.e check is sqlbrowser service is running and

follow the steps in the below...

except is valid for sql 2005

http://msdn.microsoft.com/en-us/library/ms188055%28v=SQL.90%29.aspx

The issue your facing is network , login realted.

Are u able to connect to the target using other methods like .udl...

Try this

ALTER DATABASE database MODIFY FILE ( NAME = N'database_log', FILEGROWTH = 10% )

you could use sp_msforeachdb , I wouldnt though.

Not unless you can implement the logic in the proc as a function.

1. Is it true that Sql server is more secure than Oracle and Mysql as microsoft claims?

oracle on a unix platform is inherenty more secure but this depends on what...

declare @table table

(

name varchar(256)

)

declare @tableA table

(

name varchar(256)

)

declare @tableB table

(

name varchar(256)

)

insert into @table

select 'A123'

union

select '123'

union

select '1234'

insert into @tableA

select 'A123'

insert...

the format I follow is

Database

Logins

Users schema

Tables

constraints

Indexes

Triggers

data

indexes

functions

procs

everything else

Aahh Yes , i didnt think that the data would be used elsewhere programmatically ;D

It depends , case allows for conditional logic based on the data within the returned result set and therefore can make some queries really simple to code and effective....

Identity values will skip for rolled back transactions so it wouldn't be a good indicator of number of tickets per dept anyway. Unless your expecting a huge number tickets raised...

Try lookup under the DFT