You don't need EE for what you want to accomplish.

What you need to do is create a new filegroup on your database and put that filegroup and file on the...

Do some reading in BOL on the LIKE operator and wildcards.

Dave Hoogendoorn (4/20/2009)

---

The query takes a long time to execute. So after two minutes I stop the query to see how many records are retrieved. The more records retrieved in...

Depending on the query, parallelism may not be best. More processors may help by allowing additional queries to be processed at the same time.

Test your query again but with...

I am pretty sure you can't drop the indexes on just specific partitions, as indexes are created on just specific partitions. It's an all or nothing type of thing.

You are thinking human readable here. If that is the issue, then I'd build views over the tables with the columns in the "proper human readable order" and have...

Personally, I'd go with option 3. The location of the columns in the table is not relevent. If you want to keep things close together for the developeres,...

Not at this...

One reason I used a dynamic tally table was simple, what if you didn't already have one or you called it by another name such as Numbers? By doing...

Griffster (4/20/2009)

---

Lynn Pettis (4/15/2009)

---

Here is some code for you to examine and play with. I hope it helps.

declare @StartDate datetime,

@EndDate ...

Took your...

Paul White (4/19/2009)

---

Lynn Pettis (4/19/2009)

---

And, as a final thought before I leave. As a professional, I must admit when I was wrong. Paul, I was wrong. Please...

And, as a final thought before I leave. As a professional, I must admit when I was wrong. Paul, I was wrong. Please except my apologies. ...

You know, it's been a long day, I think it's time to get some sleep. Maybe then I can re-engage in a more meaningful dialog and hit the right...

Paul White (4/19/2009)

---

Now I'm confused :unsure:

Perhaps I'll...