Viewing 15 posts - 4,231 through 4,245 (of 59,067 total)
I wound up in a highly similar position implementing 'immediate fixes' and never able to get to long-term solutions to stop all the 'immediate fixes.' It forced me into...
December 8, 2021 at 8:06 pm
IMHO, "Most Reads" doesn't tell you anything other than a title possibly having a great amount of SEO. People could be opening an article and getting one sentence in and...
December 8, 2021 at 4:45 pm
Jeff Moden wrote:The first to the check for is <insert drum roll here> are you using any monitoring software?
Yes i use monitoring and nxlog is part of the setup
So...
December 8, 2021 at 4:38 pm
This is so wrong. Your company is trying to have you fix the wrong problem. The real problem is the source of the data...
December 7, 2021 at 10:18 pm
Using the test data provided by the OP...
WITH cteWeekAgg AS
(
SELECT StaffID
,WeekStart = DATEADD(dd,DATEDIFF(dd,0,StartDatePeriod)/7*7,0)...
December 7, 2021 at 8:27 pm
The first to the check for is <insert drum roll here> are you using any monitoring software?
December 7, 2021 at 7:42 pm
Hi, guys!
May be I'm missing something - but is there some more in detail search or filter mechanism for forum topics besides the general SCC search feature?
Kind regards! Sebastian
Yes......
December 7, 2021 at 7:26 pm
Hi ,I would like to split a given number into 3 numbers based on a percentage(98.6% , 1.2% and 0.2%) and round it to an integer value and the...
December 7, 2021 at 7:24 pm
How many von/bis dates are you feeding this thing from the zugriff.dim_spell table? And how much (or little) memory do you have available on the SQL Server?
Also, I wish I...
December 7, 2021 at 6:48 am
My apologies. I was on vacation last week (but got emergency calls for 17.5 hours of work) and have been slammed for the day. I've got commitments from now until...
December 7, 2021 at 6:41 am
Hi Jeff,
the translation worked :-). I will test it on the large data set right away. The date format is just Excel being Excel where I prepared the demo....
December 6, 2021 at 4:32 pm
This is so wrong. Your company is trying to have you fix the wrong problem. The real problem is the source of the data and THAT's what actually...
December 6, 2021 at 4:18 pm
Do you have a performant SQL query to achieve that?
I hope the translator is working correctly but, to answer the question above, "Ja. Und es'ist blitzschnell! "
First, I have...
December 6, 2021 at 2:48 am
This means you can't use numerics for it because you don't do any calculations.
Instead of going through it all yet again, I'll summarize just by saying that's total rubbish.
December 5, 2021 at 5:36 pm
Viewing 15 posts - 4,231 through 4,245 (of 59,067 total)