Check if tempdb collation is different to your database(s) the last time time I had this problem that was the cause and as already stated you have use COLLATE on...

Question for the smart people, and the rest of you.

Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is healthy.

Or is...

I have seen this where month name is the column heading but the grouping is date or year/month. Matrix column grouping should be month number only and the heading month...

As a hard and fast rule no. But high cpu can sometimes be caused by high io and that can definitely be a symptom of poor queries as Jeff indicated....

I would check for any correlation between excessive IO and high cpu. Insufficient paging file space will cause sql server excessive page swapping and therefore high IO. Second is there...

+1000

Cannot check this as I do not hve access to any SQL Server yet but IIRC IFF in SSRS is not short circuit and both results are evaluated and therefore...

Not sure what you are alluding too but I tried all three options without creating a new database and in each case the id was reused. Only the following two...

Out of curiosity, did some tests

Offline/Online - No Change

Detach/Attach - No Change

Delete/Restore - No Change

However if you attach or restore a database with an id that is already in use...

output as below

CompanyIDYearRev_IDMetarialID1888574MetarialID1888575MetarialID1888576MetarialID1888577supplier1888574supplier1888575supplier1888576supplier1888577
1039109202133982083.1897.0592.8795.7480.1899.0094.8796.74
1039152202033989880.1810098.8793.7479.1899.0096.8790.74

my result will be

company and year and rev then pivot first Colum based on material id ,pivot second Colum based on material id

with...

• This reply was modified 3 years, 9 months ago by David Burrows.

Static version

SELECT CompanyID,[Year],Rev_ID
,MAX(CASE WHEN MetarialID=1888574 THEN Metarialperc ELSE 0.0 END) AS [MetarialID1888574]
,MAX(CASE WHEN MetarialID=1888575 THEN Metarialperc ELSE 0.0 END) AS [MetarialID1888575]
,MAX(CASE WHEN MetarialID=1888576 THEN Metarialperc ELSE 0.0...

Nah! Just add a DEFAULT 😉

Casually reviewing jobs at the moment but will get more serious in new year and see what happens??

Same to you and everyone here 🙂

For me, 2022 brings change, after 38 years in this job, it officially ends 31st March 2022 🙁

I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

One of our Devs has a question. He's trying to get...