DB_Newbie2007 (8/3/2010)

---

Thanks for the comments, Grant.

The cost threshold for parallelism option on this server is set to 5.

Window Server 2008 Standard (64-bit).

SQL Server 2008 Standard (64-bit), Version...

Stefan, good thought on the optimizer dropping out, but both queries went through a FULL optimization process. That means the optimizer thought it had them both right. I'm still wondering...

Steve Jones - Editor (8/3/2010)

---

Not to make it too much of an issue, but in the US we have fundamentally tried to give freedom to religious institutions. For better or...

Stefan Krzywicki (8/3/2010)

---

WayneS (8/3/2010)

---

Stefan Krzywicki (8/3/2010)

---

WayneS (8/3/2010)

---

There's a quote in this article that sums up my feelings:

"On the...

DB_Newbie2007 (8/3/2010)

---

Grant,

Unfortunately, "ChargeType" is actually my name for a bunch of columns added together in this particular table to list a charge. The tables (dbo.Jan10, dbo.Feb10, etc) are wide...

DB_Newbie2007 (8/3/2010)

---

Grant,

I agree with the previous statement (RIGHT(RTRIM(InvoiceNumber),12) is a performance issue)... the VIEW_InvoiceData table was never intended to be queried against. Unfortunately, the original architect (2007) did not...

Personally, I have zero issues with a mosque near Ground Zero. But... that particular organization has an agenda...

The faster query is getting a parallel execution (assuming I'm reading which of the two plans is the faster). That could explain the difference in execution times right there. But...

jeff.mason (8/3/2010)

---

The only foolproof way I know of (and you probably need a domain admin account for each domain to do this) is to do an LDAP query against AD...

I'd try SQLPing

I'm not sure that I see a difference either, but, this:

RIGHT(RTRIM(InvoiceNumber),12)

Is going to absolutely kill performance. You can only ever get scans because of that. Functions on columns is a...

Why are you trying to create an alias of the geography data type with the same name? Just use it as is.

Also, if you try running that script, as defined,...

How about using SMO. Something like this works:

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.SMO") | Out-Null

$Server = New-Object ('Microsoft.SQLServer.Management.Smo.Server') 'Servername'

$db = $Server.Databases["Test"]

$script = Get-Content c:\scripts\input.sql

$extype = [Microsoft.SQLServer.Management.Common.ExecutionTypes]::ContinueOnError

$db.ExecuteNonQuery($script,$extype)

Lynn Pettis (8/2/2010)

---

Gianluca Sartori (8/2/2010)

---

Jeff Moden (8/2/2010)

---

Wow! If that's actually true, that's WAY too low for someone of...

Lynn Pettis (7/23/2010)

---

Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a...