KBSK (11/2/2016)

---

Grant Fritchey (11/2/2016)

---

Just curious, what about the right hand side? You can write a query that puts a function against a column on either side of the operand and...

J Livingston SQL (11/3/2016)

---

ok, without you answering the rest of my question for expected results on various scenarios...here is shot in the dark...

The fastest data transferring channel is a truck loaded with DVD's

:hehe:

Like this:

DBCC CHECKIDENT ( 'table1', RESEED, 1453158)

It depends.

What is it for?

What is 2nd table is made for?

Can you explain the order of values in this query?

select 1,100,200 union all

select 2,200,null union all

select 3,120, 20

Why 100 goes before 200 for ID=1,

and 120...

webrunner (11/1/2016)

---

But is there any way to capture such a query as its tempdb log space usage crosses certain thresholds (such as 50% of the available tempdb log space) -...

Eirikur Eiriksson (10/29/2016)

---

Jeff Moden (10/24/2016)

---

I came up with...

mah_j (10/29/2016)

---

you will need this index on the dbo.Transaction

CREATE UNIQUE NONCLUSTERED INDEX [INDEX_NAME] ON [dbo].[Transaction]

(

[InvoiceUID] ASC,

[IsSuccess] ASC,

[TransKind] ASC,

[TransactionDate] ASC

)

INCLUDE ( [CardNumber],[ReferenceNumber],[SeqCounter],[UnqReferenceNumber]);

and this index for the dbo.Invoice

CREATE UNIQUE NONCLUSTERED INDEX...

Check for open transactions.

Both.

For verification.

It did not matter at the end.

They trimmed all strings in .Net code before storing...

I was not a DBA there, so did not look into DB sized.

Performance wise -...

Sterling Ostin (10/26/2016)

---

Sergiy,

I did read Luis' post and incorporated it in an even more graceful and shorter solution that best suited my need.

In the future, maybe you ought to question...

Jeff, don't you think it's a bit too late to...

Writing queries like this is asking for trouble.

Must be created by some automation tool and is extremely difficult for optimizer.

It might be not the index you found, people normally do...