I'm a bit confused. A LEFT JOIN is an OUTER JOIN. The full syntax would be LEFT OUTER JOIN.

Since you're copying the entire database, why not simply run a backup and restore?

It sure looks like it's going through a de-dup process to me.

balasach82 (6/21/2010)

---

Thats a Lightning quick reply. My requirements are to get the No. of TXN count as well as the corresponding queries. Initially, even if i get the TXN count,...

Are you looking for something in particular? There are probably a hundred "how-to" articles on setting up a basic backup schedule just here on SSC alone, and most of them...

adnan8t2 (6/21/2010)

---

Dear Readers,

According to your experience what we should set the size of following fields while creating a new database.

MDF Initial Size = depends on system estimates

LDF Initial Size =...

If you just need a transaction count, there are performance monitor counters that will give...

Ah, different information. I would check the ANSI settings first, see if they're the same.

david.c.holley (6/18/2010)

---

Its has an Access front end. When I was reading up on security yesterday, the articles that I read suggested that Application Roles required the password to be provided...

Oh right, I was thinking about looking at the data... misread it. Good catch,...

You can't. You'd need to have execute privs on the procedure in order to execute it and get the data back from it.

A server side trace is the best method. Just limit the number of events and columns you're capturing and you won't even see the effects of it running, even on...

Another option that we use pretty frequently is to create a role within the database. Grant all permissions through the role, and then add users or AD groups to the...

First off, you didn't state whether or not the hardware was different. Unless the memory, cpu and disks are identical, you'll see fundamental differences in behavior between machines.

Second, index fragementation,...

And in addition to all that, I'd like to recommend a good book... look down.