jay-h (4/15/2015)

---

arrghhh

Details:

Sql2008 R2

Windows 2008 R2

VM

Need to move files to different drive

Detatched successfully. However I physically cannot copy the files to the new folder, continuously getting "You need administrative permissions" (interestingly...

The right answer is, it depends. To mention a...

Interesting on seeing how...

Try this...

DECLARE @t table(ID int not null identity(1,1), name varchar(255));

INSERT INTO @t(name)

SELECT name

FROM sys.databases -WHERE database_id > 4

SET @total = @@ROWCOUNT;

SET @id=1;

WHILE @id <=...

hudriwudri5 (4/16/2015)

---

Ok, that's what I want to hear, except there is another reason.

For me there are two possible answers

First : this is something I don't understand

Second: it's...

mxy (4/16/2015)

---

data is not in base table, after manipulation in temp table based on business logic we need to insert to a remote table. don't think replication in needed in...

Like Phil explained, performance will never be be optimal. SSIS or bcp is faster.

Having said that and if you can't change your code, I would suggest this read:

Linked servers...

You need to delete in batches. I've done that dozens of times without issues on tables with several millions records. But regardless, you table will be fragmented once you're done,...

1+

I use powershell for this type of cross server activities. Here's an example: USING POWERSHELL TO LOOP THROUGH A LIST OF SQL SERVER DATABASES[/url]

Avoid cursors. If you can get same result via pure TSQL, that will always perform better. In fact, getting rid of cursors will help you think in sets.

Regarding your question...

PHYData DBA (4/14/2015)

---

sql-lover (4/10/2015)

---

Thanks for the responses so far.

I need 100% certainty. The DMV/count is needed to identify the table(s) with an empty set. A massive DDL change will be...

Luis Cazares (4/14/2015)

---

sql-lover (4/14/2015)

---

Hmmm .... thinking loud and to myself.

I still would like to hear any advice but I think I can't rollback DDL statements in TSQL. In other words,...

Hmmm .... thinking loud and to myself.

I still would like to hear any advice but I think I can't rollback DDL statements in TSQL. In other words, and after re-reading...

The script ran beautifully! 😉 Thanks all for your input.