pdchandran (3/5/2010)

---

We are facing severe performance probs on one of our prod servers. And we trying to identify the hardware bottleneck...%BufferCacheHit ratio 80% and page life exp 10 seconds...but then...

FreePoint

nadersam (3/8/2010)

---

Thanks Paul for your reply, I found it very informative.

To make sure I understand you correctly: For the index, if the added field is a NULL value, just its...

The answers are in two excellent articles on this site by MVP Jeff Moden:

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Cross Tabs and Pivots, Part 2 -...

They might change. Optimizations within the engine exist to avoid allocating new...

This is quite a complex topic, but I will try to be brief.

When you add a column, what SQL Server has to do, depends on many factors. Essentially, though,...

So true. They (the people with...

It is very important not to generalise on performance here, since it is so dependent on data distribution (especially the number of groups, and average number of members per group)....

-- For the demonstration

USE tempdb;

GO

-- Drop any objects left over from previous runs

IF OBJECT_ID(N'dbo.PetColours', N'V') IS NOT NULL

...

APPLY makes this easy and intuitive:

SELECT IT.IntTranID,

IT.IntLine,

iTVF.BrlBarrelID

FROM testInventoryTran IT

JOIN ...

:laugh: Very funny!

Cross Tabs and Pivots[/url] by Jeff Moden.

It's a very well-read article on this site.

Paul

waxingsatirical (3/8/2010)

---

I'd like a First() function in SQL server, often I need to get a value from a row that has been replicated by a join to another table. I...

It's not meaningless with an...

Here are some places to start in Books Online:

Locking in the Database Engine

Transactions (Database Engine)

Paul