hemanth.damecharla (2/8/2013)

---

GilaMonster (2/8/2013)

---

The only thing you can do for a recovering database is wait. If the schedulers are still hung may require another restart, bear in mind that'll undo any...

The only thing you can do for a recovering database is wait. If the schedulers are still hung may require another restart, bear in mind that'll undo any recovery work...

Correct.

As for why the files are different sizes, they were...

wafw1971 (2/8/2013)

---

What the questions is about is setting up the SELECT statement within the table to have that information sorted already so when some one does query the data its...

Anuj Rathi (2/8/2013)

---

record_cat is foreign key for record_subcat1 & record_subcat1 is foreign key for record_subcat2.

So, as per your explanation, record_subcat2 is most selective column in our index &

record_subcat2, record_subcat1, record_cat,...

This will give you the CalendarMonth as you asked. For ordering, you could just have ordered by the Date column and it would have sorted correctly without this

CREATE TABLE Time3

(Date...

Selectivity should not be the primary indicator for choosing index columns. Putting the most selective column first would be stupid if nothing filters by it. The decision as to column...

wafw1971 (2/8/2013)

---

Thanks for that, but I need to know how to add a sort to the SQL Code, not the query. It maybe me not making it clear and I...

No, I mean that the query that retrieves from that table needs to have an ORDER BY clause on it.

How the data is inserted into the table is absolutely...

So what do you have so far and where are you stuck.

For that you need...

Unless the truncate was run in a transaction that has not yet been committed or there's a recent backup to restore, that data is not coming back.

Anuj Rathi (2/8/2013)

---

"If you have a WHERE clause that includes expressions connected by two or more AND operators, SQL Server will evaluate them from left to right in the order...

No way to answer...

As Grant said earlier

No, you absolutely do not want to create indexes for every theoretical...