If the servers are linked, and assuming you do not want to restart the replication, then I would recommend using the MERGE command to INSERT, UPDATE and or DELETE based...

SELECT STUFF(( SELECT ''+A.data FROM (SELECT DISTINCT TOP 100 PERCENT data FROM #temp ORDER BY data) A

FOR XML PATH ('')),1,1,'')

Would that not work? I have found that to be...

Vedran Kesegic (1/28/2013)

---

Snapshot is read-only. If you want to test something other than reads, it will not work.

Snapshot might not be good to test even the reads because it...

Course work? Show some effort and ask...

Ah, I remember the days of DBCC PINTABLE. Those were the days.

Kids, dont try that at home, it doesnt work anymore.

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just saying. The first 2 groups have very...

ravi@sql (1/14/2013)

---

Hi All,

I wanted to convert t-sql code to Pl-sql(oracle 11g).

Can any body guide what are the steps to be followed to migrate this code...

You would be better served with the last line like this:

EXEC sp_executesql @sql

You should have a higher plan reuse rate instead of the standard EXECUTE (@SQL)

You could take another approach and move the concept of locking or checking out a record and subsequent notifications of said lock to a middle tier, perhaps a WCF service...

I would use multiple MERGE's (I think it can be done with 3) against the base tables. I never update using views, just a personal opinion. Wrap the...

The easiest method I have found is this:

I assume I will be getting rid of the original file (if possible)

I create the new files (you do not need to have...

Could autogrowth be accounting for this? If the files were growing each time, and the growth was wrong, you could incur a ton of IO, and after the purge,...

The problem I see, is there is no ROLLBACK should an error exist. Therefore you have uncommitted changes pending, which of course, will cause the GET procedure to deadlock....

Minnu,

Please stop posting the same question worded differently multiple times. It wont get an answer any faster.

Minnu (12/5/2012)

---

Hi Team,

Am using below code to display name and "Date of birth"

but Field DOB is not coming in Date format.

select @FinalString=(SELECT RTRIM(+ISNULL('Name ','')+' : ' +ISNULL(+CAST(NAME AS VARCHAR(100))+'...