debanjan.ray (1/24/2013)

---

One of simple delete query is taking more than 10hrs to execute. There are more than 12 foreign keys dependent on that table. Query is like this,

Delete from...

SQL* (1/23/2013)

---

What is the need of computed column if we can do the same thing in the query/application?Can anybody give me such scenario where we must use this Computed column...

yes it can be done with the same way as you did but need additional code too like :

set...

there are couple of good tools provided by redgate http://www.red-gate.com/products/dba/ (Disclaimer: i am not paid by redgate for this 😀 ).

i have used spotlight too , and found is...

i am not good in replication but yes i found something for you

This problem occurs because the current identity value of the table on the publisher is not within...

YOur cursor doesnt do here anything , simply "USe database"

What actaully you are trying to achieve here ?

Dont cross post.. it wastes time of other people.

Original post here http://www.sqlservercentral.com/Forums/Topic1410489-1292-1.aspx

Dont cross post.. it wastes time of other people.

Original post here http://www.sqlservercentral.com/Forums/Topic1410489-1292-1.aspx

Dont cross post.. it wastes time of other people.

Original post here http://www.sqlservercentral.com/Forums/Topic1410489-1292-1.aspx

Check if you get some help from sys.tables in tempDB database.

lestatf4 (1/23/2013)

---

select c.Reference, mc.MPAN,ElementID,MONTH(hhdatetime) mm,YEAR(hhdatetime) yy

from CONTRACTS.MPAN_Contract mc

join CONTRACTS.ContractElementUnitInstance ui

on mc.ContractID = ui.ContractID

join CONTRACTS.Contract c

on ui.ContractID = c.id

and ui.ElementID in (2,3,4)

join CONTRACTS.CalendarAllHH cal

on cal.HHDatetime between ui.Startdate and ui.Enddate

and cal.HHDatetime...

Dont cross post. it wastes the people time.

Original post here http://www.sqlservercentral.com/Forums/Topic1410434-1550-1.aspx

For example:

USE SampleDB

EXEC sp_changedbowner 'sa'

select name from

(

select name, row_number() over ( partition by name order by name ) rnk

from EmEmployeesand

) t where t.rnk > 1

girish.nehte-1109699 (1/23/2013)

---

Hi,

I am using SQL Server 2010 with Visual Studio for my application. Now I have a table say "EmEmployeesand that have some 5000 records. This table has a column...