Whoa!

I'm with Gail. That brings up a WHOLE different discussion. First, you need all the information she has brought up.

For loading an Azure SQL Data Warehouse, currently, the...

I've been using DreamHost for several years now. It's been a very solid experience.

Chad Crawford (11/7/2016)

---

Grant - your blog gets a wide enough audience that you're going to always have someone who misreads it, misunderstands it, or deliberately maligns it for some...

I agree with Eirikur. Just a restore will get the job done. If you need it near real time, I'd suggest looking at Availability Groups.

I'm at the MVP Summit, so my responses are going to be slow & short for the rest of the week.

Sounds like real improvements have been made. Exploring the new...

Oh cross database? I didn't even notice that. Sorry. That's what happens when you don't drill down and pay careful attention. Yeah, no cross-database foreign keys.

You might, might, see a...

Get in touch if you have questions. Hopefully the book is helpful.

I do think you're looking at the variable causing average values instead of specific ones to get a less...

Are the DatabaseID columns enforced as foreign key constraints, or are they just indexes? Since they are being used as foreign keys, you want to ensure that they are enforced....

That's a gigantically open-ended question. To answer it faithfully you have to know if we're changing the data as well as moving it. Are there transformations to the structure or...

There isn't a perfect way to get this done. I'd suggest looking at SQLCop[/url]. It does a decent, but not great, job at this. I don't know of a tool...

Assuming we're talking about an inline table function, that's the approach I would use. If you're looking at the multi-statement table valued function, I would caution against it.

Be careful. You're...

I don't know if you're on 2008 or 2008R2, but if the latter, you should explore using traceflag 2371. It makes a huge difference for lots of people when dealing...

I agree 100% with Gail. To do this accurately, you need to have monitoring in place.

However, you could look to the Dynamic Management View, sys.dm_exec_query_stats. That does have the last...

And since you have NOLOCK everywhere, it's worth pointing out that the use of NOLOCK can lead to missing or extra rows in your query. Be very cautious in how...

There are a bunch of people around here with that kind of experience. What's the question?