Thanks for your reply...

What is the effetc of this statement when we apply the final t- log back up?

Thanks mahesh for your reply.

Hi Grant,

Thanks for the reply...

I would like to know if we can include a case statement in an insert operation.

Thanks everyone for their reply

Thank you ALZDBA...

what about a covering index??Is it stored seperately from the base table??

what do you mean by this statement?

if a NCI is defined on a clusterd table, data access is performed using the uniquified key(s) of the clustered index.??

Is it true that a Nonclustered index occupies additional space apart from the Heap space??

ANd that a Clustered index is not stored seperately from the base table??

Hi Jack,,

You mean to say that as the Sql server agent needs to access network resources(and hence it is a network service), it be configured with a domain account??

Thanks steve for the reply..when is a service configured as LocalService and when is it done as Localsystem...

I understand that in case any sql service needs access to a network...

Thank you all for your inputs...

Hi,

I was asked this question in an interview...as to how this query may be rephrased for performance improvement...

what wud be u r take on this??

Hi,

In that case , if selectivity is >50% then always a table scan or clustered index scan is better..Am i right??

And my earlier question was if we had a...

What if we had a table with an empid field which was inserted randomly and is not ordered..i.ee. instead of rows having empids as 4, 5 6,..we have a table...

Hi,

Thanx for the reply Mike..

What about this??

SELECT ' Customer' ,count(Customer_id) FROM Customer WHERE CountryCode='vn'

UNION ALL

SELECT 'SalesOp' ,COUNT(salesOp_id) FROM SalesOp WHERE programCode='lt' and SalesOfficeCode like 'vn%'