Again, you cannot rename an instance.

The sp_dropserver/sp_addserver applies whem you have changed the machine name in Windows. In this case you need to do "sp_dropserver oldname" followed by

sp_addserver "newname",...

It's unlikely that the speed difference would be significant. Yes, if you need to do this on...

Hard to say when we don't know the exact steps you did....

SELECT quotename(s.name) + '.' + quotename(o.name), o.type

FROM sys.objects o

JOIN sys.schemas s ON o.object_id = s.object_id

WHERE o.type NOT IN ('S', 'IT')

This will lists all objects in the...

Are there any triggers on the table? The INSERT statements themselves are plain vanilla, but there could be issues with trigger code.

But since you say mirror waits, I guess you...

It's impossible to say. In the system I work there is a table to which a bunch of rows are added every night. This job usually completes in a few...

SELECT replace(str(amt, 13), ' ', '0')

Jay Purvis (8/30/2013)

---

This is typical of jerks that can post anonymously, and say things that would cause them to get their butts kicked if they said them to anyone face...

deep3.kaur 98681 (8/30/2013)

---

we are dropping indexes before inserts and re-build after the inserts are complete.

My main issue is why the ETL is taking more time on Sql 2012 then it...

For that matter, I had not seen the term RBAR before I started to be...

In addition to the other posts, permit me to point that one important piece is missing from your post: what error do they get?

And, for that matter, do they insert...

I have been involved in another thread where someone was trying to use BCP to export data, and the througput he got was about the same as yours. I did...

danka_6786978 (8/29/2013)

---

So, I'm changing my question then: if my statement that I started with begin Tran errors out, will that transaction stay open till I do rollback or commit? What's...

Jay Purvis (8/29/2013)

---

No, it was a development server, but it is still a pain to not be able to restore system databases.

Especially when the builds were released only a month...

It's as simple as this:

SET @sql = 'SELECT * FROM <sometable>

WHERE dateadd(hh, @tzoffset, END_DATETIME) BETWEEN @StartDate AND @EndDate'

When you work with dynamic SQL you should use parameterised statements for...