GSquared (8/6/2012)

---

Restarting the SQL service is probably speeding things up by getting rid of poorly built execution plans from the cache. That might speed it up, for a while,...

I like Duvel, but like this one even more

Yes, I use a DBA database for a number of solutions (one of those is Ola's solution for re-indexing). A list of the databases gives an idea of the data...

Hi,

Quote: "how is it anyone else's business to interfere and forcibly prohibit the transaction?"

What I think about this: it is not anyONE's business, but a more fundamental issue.

Mind you, I...

Hi,

I assume that the above only goes for those of us working in the USA?

I live & work in the Netherlands and over here it's usually quit simple. I have...

Well, one of your coworkers, then?

(btw:...

Hmmm ...

I guess it's your 50th birthday and this editorial was just a cliffhanger.

🙂

Hello Phil,

Maybe this is the issue? http://www.sqlservercentral.com/Forums/Topic657407-146-1.aspx#bm657482

I quote:

The figure you are looking at is calculated from the control information held about tables in tempdb.

tempdb has what is known...

Jportelas (8/8/2011)

---

Good afternoon:

In the enterprise I work for we have production and staging environments for our Databases and applications. Our Staging-environment DBA is having trouble when restoring a production backup...

To start: http://sqlchicken.com/sql-university/

Thank you all for your responses.

Anybody knows of other pro's and/or con's?

thnx,

Frits.

Well, just to mention one: in config-files both the server and the database...

Thank you Gianluca.

This is more or less what I was looking for (had no experience with openrowset yet). Allthough I may not use it here I learned something today!

Thanks again!

The following works for me:

* Create a new database 'MyDB_SourceBackup'

* Copy all definitions (tables, sp's etc.) from MyDB to MyDB_SourceBackup (using SQLCompare)

* Restore a full backup from production to MyDB

*...

The Hague, Netherlands.

(one of just a few towns with a translated name in many languages)

Den Haag, Nederland.