Do you mean SQL Server Express Edition with Advanced Services? If so, that instance can only be used as a subscriber. Therefore, you cannot set up replicatioon or create...

eforta.it (3/25/2012)

---

Robert,

You said in your explaination of dirty pages:

'Dirty page: A page that has changed (has transactions committed to it) and has not been written back to disk.'

Reference: http://support.microsoft.com/kb/78363

Quote: 'To...

Does the data change on this database or does it just get added to? If it is only added to, is it possible to partition (I know it is a...

You could try SELECT TOP 1 1 FROM database.schema.table and see if an error is returned or not. Or, if it is a linked server it would be linkedserver.database.schema.table

Lynn Pettis (3/22/2012) In fact, in production code I even use table aliases in single table queries. You never know when you may have to add a second table...

Check this out.

Have you verified the integrity of the backup file? Also, why are you dropping and restoring versus simply overwriting the database? Just curious on the last one...

Check out this article.

Why drop instead of alter?

Check this.

Why do you think that doing this all at once is going to decrease the amount of time; i.e. it may take 30 seconds/db now, but when you run it...

Yes, that's exactly what I mean. I'm not sure how to check which they are using, but there are several out there that can have issues. Maybe someone else can...

When you did the ping, did you use IP or server name? If you used servername and it was fast, then I think it probably something to do with the...

GSquared (3/21/2012)

---

SSIS can be faster at certain actions inside SQL Server. For example, I have a process that copies data from one server to another on a scheduled basis....

And that number is 10/minute? 20/minute? 2000/minute? How are you judging that it is too many? Every time a connection is reusing a pool, it is executing this. ...