Jeff Moden (4/23/2012)

---

Interesting! Where did you take such a class? ...

RedLegSQL (4/23/2012)

---

Hope someone can help with this one, I've installed SQL Server 2008 r2 developer edition onto the same pc as a default instance of 2005.

however when I try and...

GilaMonster (4/23/2012)

---

SQLKnowItAll (4/23/2012)

---

1. A covering index is an index whose key contains all of the values of a query and subsequently does not require reading anything other than the index....

?

ROFL...

capn.hector (4/23/2012)

---

GSquared (4/23/2012)

---

Solution is, tell whomever put the data in the table to do it again, but do it right this time. Don't split the data across multiple rows...

Do you know how to use google? 🙂 There is...

I would test the performance of MAX versus COUNT. Not sure offhand which would be better... Also, I hope you are not storing '1 of 3' in a column....

John Mitchell-245523 (4/23/2012)

---

Backups can be set to expire - this is when the backup set can be overwritten with a new one. The maintenance cleanup task is different -...

Shree-903371 (4/23/2012)

---

I have sorted the data and had ranking for highest sales by City. But I want to see ranking with highes rank in that city i.e. 1 of 3

CREATE...

sudhakar-726066 (4/23/2012)

---

[font="Courier New"]

Hello Everyone,

I have configured DB mail Which works for all SQL server's 2008 except few servers, Which gives below error when i try to send test message.

ERROR:...

Yes, it will delete it. If you moved that file, it would still be a valid file. The backups don't "expire," the clean-up will simply delete them.

Why don't we start with the basics...

1. How is the backup created; i.e. Script please...

2. How are you restoring; again, script please.

raghu_ktm (4/23/2012)

---

Hi Jared,

Nice to see the solution here, In may case same issue with MSSQL Linked server, do you have any idea to solve this as well !

I am calling...

GilaMonster (4/19/2012)

---

SQLKnowItAll (4/19/2012)

---

GilaMonster (4/19/2012)

---

SQLKnowItAll (4/19/2012)

---

To add a bit that people often forget is the uniqueness of the column(s) indexed. If the data is skewed the index may not be very...