I wasn't involved much in the installation of the database for the Jira application except that I was told by the vendor that Atlassian won't even talk to someone with...

First, you keep talking about "invoice no" but you have nothing in any of the tables that is an "invoice no".  Do you mean "InvoiceID" in the [Inventory] table?

And, surely,...

OMG !!

Wow .....the cross apply worked like a Charm.  and it was quick , even though now checking the table index is Clustered on identity, I will...

@ Brian...

I agree that a good DBA is necessary to prevent performance from tanking on 3rd party databases but, I'm not sure I'm so happy with Jira as a lot...

+ 1,000,000,000

OMG !!

Wow .....the cross apply worked like a Charm.  and it was quick , even though now checking the table index is Clustered on identity, I will go ahead...

While a Calendar table will certainly work, a little (and I do mean very little) math can be used to solve this problem.  Case in point...

--===== Create...

For a stand-alone, nonclustered index with just that column in it, REBUILD that index setting the FREESPACE to 50[%].  That will delay any fragmentation for some amount of time,...

I've experienced the random GUID-"problem" upclose in other tables. Index is 98-99% fragmented just a few hours after a defragjob has completed. There's frequent INSERT and DELETE in that...

BWWWWWWAAAAA-HAAAAAA-HAAAAAA!!!!

That made my whole week!  Thanks for the great laugh!!!

Ah... sorry... you're asking for when it was stopped.  Might be a different lookup so I withdrew my previous post.

Yes... Most have seen it happen many times before.  There are a thousand different causes of a few reasons that can usually be explained by an actual execution plan.  Any...

We manage SQL Server data in a growing environment where our One of the most popular archiving techniques with data that includes date and can be scaled early as...

Fragmentation associated with Random GUIDs is a complete MYTH based on improper testing, misinformation, and the use of supposed "Best Practices" for index maintenance that are actually "Worst Practices" and...

DELETE FROM dbo.Table WHERE ID IN (12); ... With the temporal table, deadlocks are guaranteed every time. Only one of the deletions will succeed; the rest will...