Viewing 15 posts - 4,186 through 4,200 (of 59,067 total)
Yeah! That last part forms a beautiful Type 6 SCD (Slowly Changing Dimension) but it's missing the "who dunnit" column. Adding one will either put the screws to the Temporal...
December 16, 2021 at 6:13 pm
Yes, agree that it would benefit in the read loads. But we should also consider the overhead of CI on write operations. So if the database is read-intensive then...
December 16, 2021 at 5:27 pm
i would not use clustered index is if the table needs to be dropped on occasion and recreated and the clustered index rebuild. This could take forever.
That's a part...
December 16, 2021 at 5:14 pm
This follows the same pattern as a "Catch-All" query and Grant is totally correct... both performance and resource usage, even for a small table, is going to suffer a lot...
December 16, 2021 at 2:08 pm
See the article at the similarly named link in my signature line below for a copy of the dbo.fnTally() function I use in the following. There are 3 main processes...
December 16, 2021 at 4:49 am
You're welcome and thank you for the feedback.
December 16, 2021 at 1:11 am
Heh... Temporal Tables. Reminds me of String_Split(). Fantastic idea but they left a part out... like who or what made the update. 🙁
December 15, 2021 at 11:31 pm
Yep. Totally agreed that the 52/53 week things get folks a whole lot closer than most but, as you say, what do people thing they're actually comparing? Even the almighty...
December 15, 2021 at 11:24 pm
Thanks for the feedback, especially after a whopping 16 years! 😀
While the code I posted still works, I've developed a real hate for the "wk" date-part. I also normally don't...
December 15, 2021 at 10:58 pm
Guess the op lost interest.
It also looks like we've had a problem with DBCC TIMEWARP on this thread. The original post was on 14 Dec 2021 at 11:59PM.
Even the Op's...
December 15, 2021 at 3:46 pm
Hi, I have been looking for the most correct way to handle this kind of analytics (periods) with sql server, and this article has been the closest to get...
December 15, 2021 at 2:01 pm
Not to mention that the code included in the execution plan is frequently truncated or a bit "warped". I recommend always including the code separately. It doesn't take long to...
December 14, 2021 at 6:02 pm
"I review it". How long does THAT take?
And why does it need reviewed for "safety" if they don't have the permissions to change anything on the instance??
What on Earth...
December 14, 2021 at 4:45 am
Hold on. I explicitly stated that auditors should not be able to change anything on the system. Talking about giving auditors "sysadmin" is a straw man.
Scripts that capture...
December 14, 2021 at 12:55 am
Viewing 15 posts - 4,186 through 4,200 (of 59,067 total)