Viewing 15 posts - 5,956 through 5,970 (of 59,070 total)
What do you want to appear for durations that are greater than 24 hours?
December 2, 2020 at 3:28 pm
So if you wanted a field named date_last_modified on your data table and you wanted to use a trigger to set that value to getDate() via an update trigger,...
December 2, 2020 at 3:17 pm
Is it possible to restore not only the database but also it's snapshots from the Live to the Dev server?
It's about time you found this place and signed up,...
December 2, 2020 at 3:06 am
I don't need such a thing but I Googled for "download Shapefiles for all countries" and got a shedload of hits that also had the word "free" in their descriptions.
December 1, 2020 at 11:38 pm
If both databases live on the same SAN, checkout the documentation for the SAN... it may have the ability to do a "SAN Snapshot", which is incredibly fast and doesn't...
December 1, 2020 at 11:16 pm
The other advice would be to upgrade at least the 2012 and 2014 instances. Also, if each host has 32 cores, are some of them really low usage where you...
December 1, 2020 at 11:11 pm
I am using an 8 core laptop with 8 GB of ram and 512 GB SSD disk, SQL Server 2019.
I get consistent 1100 ms with Jeffreys cte.
I'm thinking that...
December 1, 2020 at 10:25 pm
I get 450 milliseconds when using the algorithm as a scalar function. I get 1000 milliseconds when using the algorithm as an inline table-valued function.
Using the same 1 000...
December 1, 2020 at 7:56 pm
Are you referring to this function? https://www.sqltopia.com/algorithms/date-and-time/get-the-nth-weekday-of-any-interval/
I can't see that it should take 4 seconds to run over a million date interval?
That's the one, Peter. Here's the code I...
December 1, 2020 at 7:04 pm
You did good. Peter's takes over 4 seconds on a million rows. Yours takes about 380ms. Like I said, an order of magnitude
Curious - I am...
December 1, 2020 at 6:24 pm
@Jeffrey Williams,
I tested your performance improvements for Peter's code and they're an order of magnitude faster. Nicely done. I've also not been able to find a fault in...
December 1, 2020 at 4:29 pm
Hi,
I am just checking to see if anyone has ever did a costing per database (based on it size). I am trying to figure out what the cost is...
December 1, 2020 at 3:15 pm
Look at the last script from my post.
It allows to the function against all the dates you can possibly get.
in between the brackets at CROSS APPLY (...) T2 you...
December 1, 2020 at 1:44 pm
How much memory is actually in this particular system? I ask because, while I agree that Express is pretty limited, it seems to me that it should be able to...
December 1, 2020 at 1:43 pm
Totally agreed on that, Sergiy. It turned out that I had problems with my fnTally function going nuts but it wasn't the fault of the function. 2017 RTM sucked eggs...
December 1, 2020 at 5:22 am
Viewing 15 posts - 5,956 through 5,970 (of 59,070 total)