GilaMonster (11/9/2011)

---

HowardW (11/9/2011)

---

SQL can't seek that particular predicate form because the plan gets reused and a seek would produce incorrect results if rerun with the parameter null. You get scans...

GSquared (11/9/2011)

---

However, if the queries were written to get the same results as each other, IsNull will have the same performance as OR, since they do the same thing in...

A PK constraint is entirely enforced by it's index. They're intrinsically linked and cannot be seperated/changed without dropping the PK.

When the PK is Non-Clustered, this creates a Non-Clustered Unique...

jackimo (10/28/2011)

---

Thanks for the replies. There isn't a natural primary key on the table - no column is really unique now. To add one I would have to...

Krishnaraj9 (10/28/2011)

---

I tested out the max file limitation for a database..The maximum number of files per database is 32767 including log and data files. You can look at the error...

Well, technically speaking, I guess you can have more than one log file per database, although, I'm not sure if the combined size of these can be greater than 2TB...

Jeff Moden (10/24/2011)

---

Google for the phrase "In my experience, every DBA has his own mental checklist"......

Just came across this:

http://sqlserverboost.info/?p=204

Complete plagiarism, yes?[/url]

The rest of the site content looks equally dubious.

Make sure you're meeting the conditions here in the first instance:

http://msdn.microsoft.com/en-us/library/ms189595.aspx

I don't think you can disable local DAC can you? If you're talking about remote DAC, then the work-around would be to RDP locally, establish connection to DAC locally, then...

Ok, so I'm still not understanding...

Performace Guard (Shehap) (10/12/2011)

---

Where < and > are applicable for that 2008 technology "index filter" meanwhile between is not applicable.

therefore, you have to change your codes accordingly to...

You definitely can't use case statements like that (nor do you need to).

This is a classic example of a Catch-All query.

The logical way to convert what you're trying to do...

The theory of the post above is correct if you're using SQL 2008, but bear in mind that it's not functionally equivelent (add another row for "2011-10-03 00:00:00.000" to show...

In what way are the results different? What's the data type of the "DATA" column?

Is HFM_ENTITY a character column? If so, do you have a case sensitive collation in...