Viewing 15 posts - 1 through 15 (of 3,510 total)
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...
Far away is close at hand in the images of elsewhere.
Anon.
June 2, 2022 at 3:29 pm
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....
Far away is close at hand in the images of elsewhere.
Anon.
May 22, 2022 at 12:44 pm
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...
Far away is close at hand in the images of elsewhere.
Anon.
May 22, 2022 at 12:11 pm
+1000
Far away is close at hand in the images of elsewhere.
Anon.
May 10, 2022 at 12:52 am
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...
Far away is close at hand in the images of elsewhere.
Anon.
April 3, 2022 at 12:57 pm
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...
Far away is close at hand in the images of elsewhere.
Anon.
January 27, 2022 at 3:02 pm
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...
Far away is close at hand in the images of elsewhere.
Anon.
January 27, 2022 at 2:08 pm
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...
Far away is close at hand in the images of elsewhere.
Anon.
December 23, 2021 at 2:36 pm
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...
Far away is close at hand in the images of elsewhere.
Anon.
December 23, 2021 at 11:19 am
I'd bet Credits to Navy Beans that the proposed fix will be to remove the NOT NULL constraint from the column.
Nah! Just add a DEFAULT 😉
Far away is close at hand in the images of elsewhere.
Anon.
December 22, 2021 at 9:13 am
Casually reviewing jobs at the moment but will get more serious in new year and see what happens??
Far away is close at hand in the images of elsewhere.
Anon.
December 20, 2021 at 10:34 pm
How's everybody? Wishing a good 2022
Same to you and everyone here 🙂
For me, 2022 brings change, after 38 years in this job, it officially ends 31st March 2022 🙁
Far away is close at hand in the images of elsewhere.
Anon.
December 17, 2021 at 5:09 pm
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...
Far away is close at hand in the images of elsewhere.
Anon.
November 9, 2021 at 2:33 pm
The choice of device has many factors to consider, location where it is to be used would be my first concern. Using a device in a nice clean office where...
Far away is close at hand in the images of elsewhere.
Anon.
October 19, 2021 at 8:44 am
I agree with Jeff 🙂 However extracting the data and transferring to a secure ftp site at 1.1 sec per report is very optimistic.
Far away is close at hand in the images of elsewhere.
Anon.
September 7, 2021 at 12:31 pm
Viewing 15 posts - 1 through 15 (of 3,510 total)