These are just little personal utility scripts I have on my network share drive ..... Nothing else would use them or even know about them.

homebrew01 (9/8/2008)

---

Good Luck !

There are other IT tools outside of SQL, used for pushing NON-SQL data to different locations, that use the word "replication" in their name or description. Perhaps...

How big are the tables ?? If they're huge, transactional replication might be good. otherwise the SSIS option would be simpler.

Good Luck !

There are other IT tools outside of SQL, used for pushing data to different locations, that use the word "replication" in their name or description. Perhaps some people...

If you have ongoing needs to keep location 2 updated with data from location 1, day after day, week after week, then replication is the way to go. If you...

Or maybe you have SSMS Express on your desktop.

ALZDBA (9/8/2008)

---

There is no move of the datafiles at alter database time !

With Tempdb, your need the alter database to update the catalog

and you'll need the stop/start to create...

Even though you ran it in master, not your own database, you still should...

Bob Fazio (11/27/2007)

---

There are no good techniques for preliminary sizing of the tempdb. This is because it's usage has almost no correlation with anything else.

The short answer...

Vika (9/4/2008)

---

Guess what I am doing now? Making SQL Agent jobs to back up all the databases on the production server. I run that useful query that some nice person...

Rod at work (9/2/2008)

---

In a previous post I asked about replication between and old production server and a new production server. We're going to go ahead with replication between...

I used SQLSafe by Idera ... sounds similar to RedGate's. The other ideas post above are also good options.

California (9/3/2008)

---

well guess what? It worked. all what i did was:

select * from dbo.[DB.Documents] -- Yes changed the DB.D to Upper case --- thats how the table is defined and...

Yup. It only takes a couple of clicks in the GUI, and...

We put our log files on the E drive which is physically on the server, and our data files go on the SAN. Keeps them nice and separate.