That entry...

atchristian (3/6/2012)

---

The query that this happens on it a very intense analysis query. Would it be possible/ideal to inform this sproc to use only one processor for the execution? Is...

And once again I fail as a T-SQL parser.

The other interpretation (by Ken...

SQLKnowItAll (2/20/2012)

---

Why is your first example not a set? A set is simply "A group or collection of things that belong together or resemble one another or are usually found...

For what it's worth, I didn't really see what Joe was driving at with his example either. It's pretty easy to do what the OP was asking for with...

Well, before SQL Server 2008, there was no TABLE...

This demonstrates the problem and solution:

USE tempdb;

GO

CREATE TABLE dbo.Test (col1 integer NULL, col2 integer NULL, col3 integer NULL);

GO

CREATE VIEW dbo.V WITH SCHEMABINDING AS

SELECT

t.col1,

...

azhar.iqbal499 (2/18/2012)

---

I am creating Indexed views using SQL Server 2008R2. When I create index on the View it give me following error.

Cannot create the clustered index 'v_CR_WriteOffReceiptWise_Rpt_Ind' on view 'PRSP_Live_010909_190112.dbo.v_CR_WriteOffReceiptWise_Rpt'...

Rowles (2/18/2012)

---

If ANSI_NULLS are set to on, will the following equivalence operators work if equated to a null value?

IS

IS NOT

=

<>

I'm assuming that all four of the above are equivalence...

Jeff Moden (2/19/2012)

---

First, your example is quite a bit different than Stewart's. And, there is no need for an ORDER BY IMHO. Second, do you have an example...

This is completely the wrong approach, in my opinion. I prefer to work with...

SQLKnowItAll (2/17/2012)

---

@paul-2 I reviewed MSDN's explanation of the sp here. It didn't really give a good application for this, as it sometimes does. Could you give me a...

msurasky-905715 (2/17/2012)

---

I find strange that when I tested this on my SQL Server 2008 box I always got Index Seeks (never a scan, even when the tables was defined with...

The seek with no indexes:

USE tempdb;

-- Partitioning stuff

CREATE PARTITION FUNCTION PF(integer) AS RANGE RIGHT FOR VALUES (NULL);

CREATE PARTITION SCHEME PS AS PARTITION PF ALL TO ([PRIMARY]);

-- Partitioned heap

CREATE TABLE #T...