Since updates could occur on either table, I'd almost say that peer to peer replication between the two tables would be a good solution.

Having the stored procedure on each database...

If this is what your code looks like:

SET NOCOUNT ON

DECLARE @hr INT

DECLARE @fso INT

DECLARE @drive CHAR(1)

DECLARE @odrive INT

DECLARE @TotalSize VARCHAR(20)

DECLARE @MB NUMERIC;

SET @MB = 1048576

CREATE TABLE #drives (

drive CHAR(1) PRIMARY...

Here is some code to look over and run. Any questions (and there should be if you don't understand anything), let us know.

DECLARE @ThisDate DATETIME;

SET @ThisDate = '20120613';

SELECT

...

GO is a batch separator used in SSMS (and can actually be changed), it isn't a T-SQL command or statement.

Also, make sure you aren't using it for production work. If you are going to do development, I'd purchase the Developer Edition for each developer.

There are also a lot of configuration settings that can be set by the DBA in Oracle. Knowing what these settings do and how the interact with each other...

isuckatsql (6/12/2012)

---

I removed the ‘GUID’ field and used an ‘INT’ ID field instead for the primary key and clustered indexes, and got the query down to:

SQL Server Execution Times:

...

For those of you who haven't seen it yet, Fantasy Football 2012.

As the returning Champion from last year (and not necessarily expecting a repeat), I am eager to go again!

A full backup only backs up enough of the transaction log to ensure a consistent restore as of the end of backing up the data portion of the database. ...

CELKO (6/13/2012)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how,...

Just got an email from Yahoo, it's time to start thinking about SSC Fantasy Football 2012!

Who is ready for a rematch??

Don't worry about, you aren't an idiot. I get it often.

I...

Just one little thing, I am not a her. 🙂

Just be aware that if your SQL Server instances are running under the local server account on SEPARATE servers that you would need to do one of two things:

1) change...