Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should have been "How...

Apparently not, if you keep coming back.

😛

Why? Anything what I said does not apply to your universe?

Yes, there are LOTS of foolish people. Yes,...

That's what you should be doing (using your beloved "non-legacy" system views this time 🙂 ):

SELECT OBJECT_NAME(ic.object_id), i.index_id, COUNT(*), COUNT(DesiredIndex.OrdPosition)

FROM sys.indexes i

INNER JOIN sys.index_columns ic ON ic.object_id = i.object_id AND...

Xedni (12/7/2016)

---

Sergiy (12/7/2016)

---

Index name is not a really good indicator of index existence.

You may have many identical indexes, all with different names.

To check if an index with the same structure...

BTW,

you've got an error in your duration calculations.

Here is the testing script:

SELECT *,

duration_datetime = DATEADD(ss, T2.minutes/100, 0),

duration_orig = cast(minutes /100/60/60 as varchar) + ':' + left( cast...

John Mitchell-245523 (12/8/2016)

---

Edvard

Yes, that's how it works. Try declaring @starttime and @endtime variables and setting them to the new values. You can then use them in the update...

Somebody implemented EAV poorly...

etl2016 (12/12/2016)

---

Hi,

I am seeing that special character on my SSMS query, where as the actual data does not contain that character.

Basically, data type is varchar for both source and destination...

sgmunson (12/11/2016)

---

Sergiy (12/11/2016)

---

sgmunson (12/9/2016)

---

Sergiy (12/8/2016)

---

sgmunson (12/8/2016)

---

Sergiy (12/8/2016)

---

sgmunson (12/8/2016)

---

Sergiy (12/7/2016)

---

sgmunson (12/6/2016)

---

As painful as that is, a book in any body cavity is going to be more painful and for a lot...

sgmunson (12/9/2016)

---

Sergiy (12/8/2016)

---

sgmunson (12/8/2016)

---

Sergiy (12/8/2016)

---

sgmunson (12/8/2016)

---

Sergiy (12/7/2016)

---

sgmunson (12/6/2016)

---

As painful as that is, a book in any body cavity is going to be more painful and for a lot longer than...

sgmunson (12/8/2016)

---

Sergiy (12/8/2016)

---

sgmunson (12/8/2016)

---

Sergiy (12/7/2016)

---

sgmunson (12/6/2016)

---

As painful as that is, a book in any body cavity is going to be more painful and for a lot longer than it takes...

sgmunson (12/8/2016)

---

Sergiy (12/7/2016)

---

sgmunson (12/6/2016)

---

As painful as that is, a book in any body cavity is going to be more painful and for a lot longer than it takes to waste...

sgmunson (12/6/2016)

---

As painful as that is, a book in any body cavity is going to be more painful and for a lot longer than it takes to waste your time....

But better go with this:

declare @Year int = 16

declare @ThisYear varchar(10), @LastYear varchar(10)

SELECT @ThisYear = CONVERT(VARCHAR(10), @Year) + '-' + CONVERT(VARCHAR(10), @Year + 1),

@LastYear = CONVERT(VARCHAR(10), @Year-1) + '-' +...