I very rarely use it since it's a non-SARGable predicate and could destroy performance,...

Too many errors. Avoid writing too much at once without testing.

DROP TABLE #table_1;CREATE TABLE #table_1 (StatementName VARCHAR(500))

INSERT INTO #table_1 (StatementName) VALUES ('Nothing')

DROP TABLE #table_3;CREATE TABLE #table_3 (StatementName VARCHAR(500), Flag CHAR(1))

DECLARE...

You have this index definition in your first post:

CREATE NONCLUSTERED INDEX IX_Large_Table_ABDFHJ ON dbo.Large_Table

(A,B,D,F,H,J) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO

Why?

ben.brugman (10/30/2015)

---

The Question was:

Can SQL-server use an index and then use the covering index to collect the data?

(And therefore not using the 'main' table).

Answers:

GilaMonster (10/29/2015)

---

No. Lookups are always to the...

Eirikur Eiriksson (9/14/2015)

---

Wayne West (9/14/2015)

---

Matt Miller (#4) (9/14/2015)

---

Eirikur Eiriksson (9/14/2015)

---

Jeff Moden (9/14/2015)

---

Eirikur Eiriksson (9/13/2015)

---

Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees...

Resender (10/30/2015)

---

Okay yesterday I was in a bit of a panic and made the post Partition Sliding window causing loads of... in a haste without thinking it through,...

Steve Hurst (10/30/2015)

---

Two things, first the index does not show against the table in SSMS under the Tables (table_name) Indexes. Second, it came to light when running a script to...

Do you mean like this?

Select Top(10) HotelName, Price, CustomerRating

From dbo.VacationDestinations

where Price <= @price AND CustomerRating = @CustomerRating

Order By

CASE WHEN @ratingWeight >= @priceWeight THEN CustomerRating ELSE Price END DESC,...

A change to the earlier query after mixing up some more data:

SELECT

DeductionID, DeductionAmount, --d.[from], d.[to],

PaymentID, PaymentAmount, --p.[from], p.[to],

DeductionBalance = CASE WHEN d.[to] > p.[to] THEN d.[to] -...

Luis Cazares (10/29/2015)

---

g.britton (10/29/2015)

---

SQL uses three-value logic. So anything = NULL evaluates to False and anything <> NULL also evaluates to FALSE. Also, NULL = NULL is FALSE...

J Livingston SQL (10/29/2015)

---

Bruceo (10/29/2015)

---

By the way, how do you format your results like that? I looked through all the shortcuts and could not figure it out!

Is that an image...

Ed Wagner (10/29/2015)

---

yb751 (10/29/2015)

---

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but then I thought...

J Livingston SQL (10/29/2015)

---

ChrisM@Work (10/29/2015)

---

Try this - the result of some fiddling around earlier:

-- Set up sample data

DECLARE @Deductions TABLE (DeductionID int IDENTITY(1,1),DeductionAmount money);

INSERT @Deductions (DeductionAmount) VALUES (1000),(200),(50),(600);

DECLARE @Payments TABLE...

You're welcome, thanks for the feedback.

Try this - the result of some fiddling around earlier:

-- Set up sample data

DECLARE @Deductions TABLE (DeductionID int IDENTITY(1,1),DeductionAmount money);

INSERT @Deductions (DeductionAmount) VALUES (1000),(200),(50),(600);

DECLARE @Payments TABLE (PaymentID int IDENTITY(1,1),PaymentAmount money);

INSERT...