Ghanta (2/20/2010)

---

I guess I have to do page level compression and do it on each partition one by one... how about sparse column? Can it be done on an existing...

I doubt you'd want more than one record returned in this scenario...

Matt's right: there isn't a cardinality guarantee. APPLY invokes a table-valued-function (TVF) for each row returned by the outer table expression. A TVF can have many rows of...

Chris,

Parameterization is not the only reason for multiple cached plans, though it would be interesting to know whether the statement in question is submitted ad-hoc or as part of a...

Cool. I can't imagine there will be any sort of problem, so long as the package still has the Certificate of Authenticity attached. 😉

Paul

Lynn Pettis (2/20/2010)

---

Too lazy to look back, did you post the table and index definitions and the actual execution plans from running the queries on the two systems? You...

Fixed that for...

To expand on my previously reply slightly...

USE tempdb;

GO

IF OBJECT_ID(N'dbo.PreAggregatedSampleData', N'V') IS NOT NULL DROP VIEW dbo.PreAggregatedSampleData;

IF OBJECT_ID(N'dbo.SampleData', N'U') IS NOT NULL DROP TABLE dbo.SampleData;

GO

CREATE TABLE dbo.SampleData

...

Indexed view.

Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS (Books Online)

Grouping Sets In SQL Server 2008 (Craig Freedman's Blog)

Those were my first two matches using Google Search.

Paul

The Product Key is on a bright orange sticker on the reverse of the plastic bit that holds the DVD.

I don't think you could miss it really, so have a...

I see no reason why you shouldn't do this, though you should certainly test it for yourself 😀

I wonder why the currently installed SQL Servers are 2000 Standard - I...

That is a link to a Microsoft White Paper by Paul Randal.

This is a clickable link to it: FILESTREAM Storage In SQL Server 2008

@gt: you can use the [...

Josh/V,

I really don't see how that is relevant. 😛

Paul

Non-CTE, non-APPLY version (2000 compatible?)

UPDATE RowsToUpdate

SET notional = ISNULL(new_value, 50)

FROM (

SELECT T1.value_date_minus_1,

...