Viewing 15 posts - 4,096 through 4,110 (of 59,067 total)
Thanks. I definitely missed your 301 comments below the 2nd spreadsheet you posted.
You say to only worry about the contiguous dates but neither the Green or the Purple sections in...
January 4, 2022 at 6:38 pm
Is it possible to start Sql server agent job after a trigger? what i want to do is after a certain table updates a certain column, then it runs...
January 4, 2022 at 3:50 am
That's awesome, Frederico! Thanks for posting that.
It would appear, though, that you actually have to program for the table structure. Is there anything like the getting data from the Web...
January 4, 2022 at 1:29 am
p.s. You might also want to read the following about Query Store. Personally, I'll never enable it and use other methods to figure out what I need to but I'm...
January 4, 2022 at 1:00 am
My first recommendation is that you actually desk check the query to make sure that you don't have anything "silly" in it. For example, looking at your query, you have...
January 4, 2022 at 12:50 am
Your post is a bit confusing. You start by talking about I/O Latency but show a chart for CPU usage and then ask if it's common to have a lot...
January 4, 2022 at 12:30 am
Worse than that, it sounds like you're doing backups on the same server that you're backing up. That's a serious mistake because if the server crashes, not only have you...
January 4, 2022 at 12:10 am
Now THAT's interesting. Just curious... do you know what the page will be for 2022? Or will it magically change at the end of the month?
Yes, that link should...
January 4, 2022 at 12:03 am
Easy enough. But I would personally assign whoever created that table with DATETIME instead of DATE to toilet cleaing duty for a week...
"It Depends". I can see someone designing...
January 3, 2022 at 11:57 pm
Getting back to your second output, what exactly is it that determines if the entries are contiguous? Does a contiguous period always start with a comp code of 301? And,...
January 3, 2022 at 5:06 pm
The pictures are very helpful for understanding but it would also be extremely helpful if you included readily consumable data. Please see the first link in my signature line below...
January 3, 2022 at 4:56 pm
It looks like you can now use PowerQuery as a source in SSIS. The nice thing is that Excel can write PowerQuery for you - all you have to...
January 3, 2022 at 4:48 pm
Heh.. I get an "Error: This question has no body." when I click on the link in the post above. Was the resolution to not post any more QOD's? 😀
January 3, 2022 at 1:47 am
It's a direct quote from here...
Must be a spammer setting up.
January 1, 2022 at 5:54 pm
Hold the phone here... inserting 5000, 10000, 15000 rows isn't a large, time consuming task for SQL Server. Why do you think you need to "chunk" the data...
January 1, 2022 at 3:41 am
Viewing 15 posts - 4,096 through 4,110 (of 59,067 total)