mahesh.vsp (5/7/2010)

---

How sql server knows the data is to be stored in C:\drive but still the system catalog views shows the default path when the database was created. What will...

Vladan (5/8/2010)

---

Hi,

this is quite an interesting problem. I never had to do anything with such calculations, but I was interested how I would solve it and here is what...

how do we come to know this ?...

Any specific reason behind it ? i guess your log is rapidly growing.

depends on various factors like

hardware config, network io, vol of data in tables ,indexes, how much query...

again Indexes will matter here

ColdCoffee (5/6/2010)

---

NOTE: This uses the CURSOR method, and i am pretty sure there are many efficient methods to do this. And i smell the no-c.u.r.s.o.r-ever camp is just around the...

TheSQLGuru (5/6/2010)

---

>> WHERE NOTETYPES.Associated_Department_ID IS NULL OR OPERDEPTMBR.Operator_ID = @Operator_ID

That type of WHERE clause is HORRIBLE from a performance standpoint. Our own Gail Shaw has a very nice blog...

and more important why we need to set it up ?

clucasi (5/6/2010)

---

Could anybody give an idea where lam going wrong.

i have checked the insert and update and they work on there own, and I have tried the case statement and...

refer this link

http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/

http://support.microsoft.com/kb/329204

http://technet.microsoft.com/en-us/library/ms181007(SQL.90).aspx

magasvs (5/5/2010)

---

I would add the second log file only if there is no space to grow for the first log file (to have the second file on different disk drive)....

whenever we restore backup , users automatically get transferred (obviously orphan users) . So how did...

Something like this

select * from db1.dbo.table union all

select * from db2.dbo.table union all

select * from db3.dbo.table union all

select * from db4.dbo.table

Either you need to give...