There's Joe Sack's TSQL Recipe's. It's nothing but scripts and how to write them.

Without more detail, it's hard to know for certain. For example, updating stats is good, but rebuilding an index also updates the stats, and with a full scan, not sampled....

Really? Looks like a car going into...

It's highly unlikely that an index would change the results of a query. It looks like you have an extra space at the end of the line, which is why...

Hard to know without seeing the query and knowing something about the data. Assuming no changes to the data and a well structured query, you should see the same data...

I'd pick up a book called Powershell in a Month of Lunches. That'll get you going quick. Same author has a more detailed book, PowerShell TFM. Get the 2.0 version.

I would absolutely advocate against this with every breath I took, but yes, you could shut down the server, then copy the database and log files, then restart the server....

kstjacques (10/23/2011)

---

Grant Fritchey (10/23/2011)

---

I just hope the vendor isn't one near & dear to my heart.

Yeah, there are lots of reasons to use a third party backup method. For example,...

What are you using the 68k records for? That's going to take a while to move into SQL Server... a long while. If you're doing an import you might want...

Now?

😀

LutzM (10/22/2011)

---

kstjacques (10/21/2011)

---

Thank you for all your responses!

So the good news is the vendor is saying they will look into fixing the issue.

My favorite part of the latest...

I'm more than a little confused by the question. The Merge Join operator inside of an execution plan is one of the most efficient operations there is. Problems around the...

How long does the oracle query take if you just run it on oracle? And how much data is being returned?

If you're just getting started as a DBA, first thing, treat production like a patient and you're a doctor, do no harm.

After that, the list of things you have to...

Clint-525719 (10/21/2011)

---

Thanks for the responses. First, to answer both your questions:

1) We do not have the AdHoc optimization turned on, and actually, I'd forgotten about it. I've...