Paul White NZ (5/5/2010)

---

Yes to the loop join - but that's exactly what is...

Solomon Rutzky (5/5/2010)

---

aeternam (5/5/2010)

---

Using a while loop in combination with a table variable shouldn't, in general, be the best performing option.

How would this query perform:

SELECT <something>

FROM <the partitioned table>

WHERE etp.PartitionID...

Numerous SQL Server MVPs (and lots of other users as well) have been screaming at Microsoft for years to improve partitioning. I hope improvements will be coming in later...

Can you give...

>>A DATETIME column with DEFAULT GETDATE() will work for single-row inserts, but if multiple rows are inserted in the same statement they will all have the same value.

Here is...

Scott Coleman (4/28/2010)

---

Don't confuse the virtual memory system and its paging file with the SQL buffer pages. Virtual memory pages are 4 KB pieces of the memory used by...

Whisper9999 (4/27/2010)

---

TheSQLGuru (4/27/2010)

---

Here's more insight for you: Low PLE simply means pages of data are being removed from the buffer pool so 'fresher' pages can be put in for...

Here's more insight for you: Low PLE simply means pages of data are being removed from the buffer pool so 'fresher' pages can be put in for processing. ...

maven.avi (4/27/2010)

---

As per your question, i have the written the following query.

Hope it helps.

Create table latest_value

(

[name] varchar(50)

)

go

Insert into latest_value

Select 'Avinash'

Union All

Select 'Suresh'

Union All

select 'Rahul'

Union All

Select 'Anil'

Union All

Select 'Zayed'

Union...

+2!!

Jeff, didn't they completely remove support for "SELECT 1 FROM E01 a, E01 b" in SQL 2008 or 2008R2? I thought that non-ANSI stuff was going away. In...

Oopsie! Should have held my comments for another week or so - then it would have been considered a good segue into the next article. :hehe:

Number of rows isn't the only issue that can kill you with Table Variables. The actual VALUES can cause issue too, since you can't have statistics on TVs. ...

I have done this type of thing for numerous clients, with stunning results as you show. Actually usually better, because they are almost always encountered in multi-table-open-ended search scenarios....

I too would like to see more information on exactly what is required for the optimizer to be able to translate APPLY to a JOIN so it can use something...