foxxo (3/5/2013)

---

Are there multiple instances of SQL2005 installed on the box? (ie are you looking at the correct SQL Agent service?)

Open SQL Configuration Manager and check it there.

What's...

Thanks Dwain

dwain.c (3/4/2013)

---

Not really possible with a GROUP BY because you want two columns off the row with the max date, so use a window function:

create table #table1

(name nvarchar(50), purchase_date...

opc.three (3/1/2013)

---

Is your system running NUMA of any flavor?

Does this yield multiple rows?

SELECT [type],

[name],

...

opc.three (3/1/2013)

---

The queries are a little off in my environments too, with clerks being about 10-15% higher. All I can think of is that clerks are operating a lower level...

Thanks

Taking into account the fact that SQL plans consists of Adhoc and Prepared queries - The total...

Thanks Guys - This clears up a lot

Perry, would you say that it's safe to not cluster DTC when you have a single node cluster?

Thanks

opc.three (2/26/2013)

---

SQL also will the DTC if you try using explicit transactions with Linked Servers. I also use it with SSIS transactions, not technically the database engine but another use...

Thanks Gail and Grant

GilaMonster (2/13/2013)

---

Grab Kalen's book, Adam Machanic's memory grants video and go over them.

Memory grants for sorts are, oddly enough, memory. If the process can't get enough memory, then the sort...

From Grant:

All temporary tables (hash/work tables, temp tables, table variables) are written to disk as well as...

What I'm struggling to see is the tempdb allocation when spill doesn't happen.

Thanks

Hi Grant

I know this post is getting old, I thought I'd just fill you in on my findings

I watched a video (from SQL.Bits) called "Advanced SQL Server 2008 troubleshooting by...

Great Stuff - Thanks for your input

Thanks Anthony

Would you agree that...