Eric M Russell (3/11/2015)

---

Wow, that's so geeky. But it is...

CELKO (3/11/2015)

Another rule of thumb is that a query with too many tables is a bad code smell that says the schema design is a mess. A classic flaw is...

I'm back. Here is where I am at.

I was just doing basic queries on a very large dataset with the indexes set in place right now. Nothing more, nothing...

Grant Fritchey (3/10/2015)

---

xsevensinzx (3/10/2015)

---

Yeah, it's doing a seek. It wasn't at first. I threw in a table hint to point to the clustered index, which shaved off some time by...

Eric M Russell (3/10/2015)

---

xsevensinzx (3/10/2015)

---

ScottPletcher (3/10/2015)

---

If the table is already clustered on time (hooray!), then reading a week's worth of data shouldn't take that long.

We need to review two things...

Koen Verbeeck (3/10/2015)

---

Eric M Russell (3/10/2015)

---

Did I understand you right that the query took 20 days?

A medium powered server should be able to perform a full table scan of 200...

Grant Fritchey (3/10/2015)

---

It sure sounds like you need to do fundamental query tuning, indexing, statistics maintenance, etc. Assuming you can't get someone in to help you who has experience with...

Woke up to loads of responses. Good!

But, there is a lot of assumptions being thrown around here on how the data is being used that wasn't specified. 😀

GilaMonster (3/10/2015)

---

Partitioning is...

ScottPletcher (3/10/2015)

---

If the table is already clustered on time (hooray!), then reading a week's worth of data shouldn't take that long.

We need to review two things (at least).

First, the query...

Koen Verbeeck (3/10/2015)

---

If you want table partitioning, you need Enterprise edition.

Also, table partitioning in itself is not a performance solution. It's more a maintenance solution for big tables. The possible...

dbridgman (3/10/2015)

---

I think the author of this article is missing the point of MongoDB (as an example) quite entirely. It is designed as a 'flexible design model' and in fact...

Personally, I think breaking things into pieces is easier to understand because it can be explained from start to finish. The better you can understand the process, the easier things...

Jeff Moden (3/9/2015)

---

TomThomson (3/8/2015)

---

Jeff Moden (3/2/2015)

---

sqldriver (3/2/2015)

---

This is a great day! I get to tell people I'm as good at something in SQL as Jeff Moden, even if it is...

Ain't that the truth. When I took my first SQL Server job at the company I am at today, the previous guy wrote everything in Access and VBA code. I...

I was told by a senior DBA on my first day of working with SQL Server that creating stored procedures was the way to automating myself out the job. 😛

But...