yup - that's one area that doesn't seem to have changed much.

I consider clustered indexes essential on damn near every table. About the only time a heap is better is when the data in the table is "write once, don't update...

*AND* on the machine running SSMS (i.e. the client tools need to be updated too).

homebrew01 (12/30/2008)

---

GilaMonster (12/30/2008)

---

Take a mid-sized computer book with a...

Just to clarify -...

Actually - let me correct that - it runs on the machine I am on, which has a "default" SQL Express install (no SSRS). So - no, it doesn't...

I don't know about installed - but I could swear I've run them without SSRS running before.

If it's doing a table scan, then yes -...

Assuming you have SP2 installed - right-click on the database, pick reports, and go after the Physical Index STats report.

RBarryYoung (12/30/2008)

---

Right, which leads to my strategy for dealing with block-headed vendors like this:

Question 1: What is your supported strategy for Disaster Recovery, that we should be implementing?

...

RBarryYoung (12/30/2008)

---

Before I suggested any other way to do this I really would want to know why backup & restore is not sufficient.

We really cannot tell you what...

ps (12/30/2008)

---

John Kandrovy (12/30/2008)

---

We are in the mist of moving a 3rd party vendor's SQL 2k database to a new server. According to the vendor it's our responsibility to move...

NULL is not a value, so comparing anything to it will fail. (NULL is a state)

Meaning A=Null will never be true, and A<>NULL will also never be true.

You need...

Madhivanan (12/30/2008)

---

Ashwin M N (12/30/2008)

---

Even if I execute this query I cannot exclude the 19"-R character. The " character is main problem.For rest all my query works fine.Is there any...

Bob Hovious (12/29/2008)

---

Matt, that was my first thought, but there's a problem if they just defined the identity property for the column without expressly creating a constraint.

Try this:

Create table dbo.dummy...