I will second Lowell for this. actually whats your exact requirement.

meanwhile you can restrict user by limiting their permission at database level like SELECT, EXECUTE etc.

its is happening because of white spaces in folder's name "program files"

daveriya (5/3/2011)

---

hi

i want to delete all the records from 2 tables ,that r link with pk->fk

for ex, emp : empid ,name

...

If the user(login ) exists there then it will be pulled out by

select * from syslogins where name like '%' + @User + '%'

Are you not getting...

Production server!! and if you are using same disk for both user DBs and temmpdb , then start thinking to move tempdb on different disk.

Vinod,

During online indexing sql takes space from the current DB for temporary storage of data.there is one option "SORT_IN_TEMPDB" . keep it ON so that tempdb can be used...

actually posted ones are some suggestion to improve the DB performance and...

actually posted ones are some suggestion to improve the DB performance and...

Current db size is 900 gb and you are saying it could get flat raise in next year.you shud also think about following steps.

1 manage your DB on multiple disk.

2...

Current db size is 900 gb and you are saying it could get flat raise in next year.you shud also think about following steps.

1 manage your DB on multiple disk.

2...

hi varun, can u tell us any specific reason why you don't want to use CTE?if the other approach the comparatively expensive.

hi varun, can u tell us any specific reason why you don't want to use CTE?if the other approach the comparatively expensive.

THis link can help you to undestand the working of TempDB http://technet.microsoft.com/en-us/library/cc966545.aspx#EDAA

DId you have any heavy migration in recent past ? or any sql level code changes ?

SQLkiwi (3/4/2011)

---

If I understand the question correctly, this should work:

SELECT Invitee_ID =

CASE

...