Side note: But never use the Profiler GUI against a production system. Always use trace events to capture the information. Profiler is only used to consume the data after it...

And you can see if there's an index you can create that may help with the sort operation. It doesn't always work, but it's a possibility.

Also check the default ANSI settings between your local SSMS and the remote SSMS. Differences there can result in different execution plans.

How big are these queries. 30 seconds for a...

What is it that you're actually looking for? Are you hitting a performance problem?

Jeff Moden (7/7/2014)

---

I hate questions like that. Anyone that has interviewed for more than a couple of times can easily make something "glorious" up and get away with the...

Most of the functions are the same with 6-8 joins or one. Most of the rules are the same dealing with a few rows or a few million. The real...

If you're really going to be building a lot of databases, I'd suggest reading Louis Davidson's book. It's a great way to learn how to do database design.

After you restructure it as was suggested already, this needs to be addressed:

(RTRIM(pc.CODE))

That will lead to scans which will seriously hurt performance. You shouldn't have functions on columns like...

You can. I haven't done it myself, so I can't offer advice. But it's absolutely doable.

I'd create a table for the Make. Then I'd create a table for MakeModel. That will have the primary key from the Make and the Model. Then you create a...

You are absolutely in a tough spot. But if you want to be technical, you don't have many choices.

No. You can have multiple clusters on shared hardware, but you can't put different versions of SQL Server into the same cluster.

Because DBCC runs on a snapshot of the database, the two processes won't interfere with each other.

From this code alone there's no way to tell you how it's going to perform. In addition to the code requests, if you can capture the execution plans, that would...

Either get a lot more space for the thing so it doesn't fill the drive, or, look into your ETL process and determine what is allocating so much space into...