It does create a system index, that's how SQL Server maintains the unique values in the table. But, there are no statistics for the index, so it won't really be...

chandrashekarthota (4/26/2010)

---

As a site administrator I request you to kindly ignore my Core member comments. I am

closing down my site for few weeks just because of plagiarism and I have

learned...

I'm not arguing, at all. I believe you.

You might try adjusting the WHERE cluase in the...

natalie.davies (4/23/2010)

---

I know this is the 2008 forum, but the same label oddity exists with 2005 too.

I remember being very confused when having a look at one of the shiny...

Shark Energy (4/23/2010)

---

I've got all the usual suspects - StmtCompleted, BatchCompleted. The started ones, Execution plans. Its throwing up nothing at all for this spid other than cacheremoves.

Good call on...

dtipser (4/23/2010)

---

Hi,

If you are running SQL Server 2008 64 bits on Windows 2008 64 bits the advanced properties shows as in attachment file.

How did you get the advanced properties for...

Steve Jones - Editor (4/23/2010)

---

Good job, everyone on the plagiarizer. I saw the email late last night from Brad as I was watching a movie with my wife and (wisely)...

tripower (4/23/2010)

---

Grant Fritchey (4/23/2010)

---

You can change the JOIN criteria something like this:

SELECT...

FROM Contractor INNER JOIN

...

Adam Bean (4/23/2010)

---

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/e83b5ded-8cda-468d-ac36-1b8c31b1073b

It turns out that the label is very confusing. There is a bug filed on it in the SQL bug database and it will hopefully get fixed...

Jason Shadonix (4/23/2010)

---

Mine is that way too. Another interesting thing...if you click on it, the little "tool tip" thing that shows up says: "Indicates whether this 32-bit service is...

I'm sure I'm...

Adam Machanic (4/23/2010)

---

Yup: I escalated last night with the INETA board of directors, and the e-mail thread eventually wound up in the hands of one of the INETA India people...

Paul White NZ (4/23/2010)

---

Grant Fritchey (4/23/2010)

---

Notice how both rows have the same index_id. There's only one index there. A row is returned for each level that the index has in...

dmoldovan (4/23/2010)

---

Follow Grant's good advice.

Select the events and other trace properties in the GUI, start the trace, immediately stop it and select File ---> Export. This way you'll obtain the...

tripower (4/23/2010)

---

I have three tables [contractor], [estimate], [contract]. Here is what I have so far:

SELECT [Contract].ProjNumber, [Contract].Description, [Contractor].[Name], [Contractor].City,

MIN([Estimate].Estimate) as "Lowest Estimate"

FROM ...