Viewing 15 posts - 2,866 through 2,880 (of 59,067 total)
Helo friends, hope everyone is doing good. I am working on a project where I have a big fact table having data for 8 years and has around 8-10...
August 26, 2022 at 5:12 pm
You have datetime columns - don't use between!
where businessdate between '2022-08-01' and '2022-08-31'
means return everything through '2022-08-31 00:00:00.000 (excludes that entire last day of the...
August 26, 2022 at 4:59 pm
I'm not exactly sure what you're asking but, no matter the language, dates and times are stored as (binary data) Integers behind the scenes. How they're presented is totally up...
August 26, 2022 at 3:29 pm
Thanks for the feedback. On this whole thing, remember that planning is the key. Shoot, the first time I did it, I actually drew a picture of what I wanted...
August 26, 2022 at 3:18 pm
Just to confirm, the code looks like you only have 1 row per week... is that correct?
If so, LAG would would a treat here.
August 26, 2022 at 2:21 am
p.s. The Sort_In_TempDB thing only takes care of the sorting aspect. You can leave that in if you want but consider the load it puts TempDB under for such a...
August 26, 2022 at 2:04 am
I have a fairly large table, billions of rows, that take up around 3TB of disk. I was tasked with creating a clustered index on this table. I performed...
August 26, 2022 at 1:55 am
I thought "cloud" was a polite way of saying "smoke and mirrors" where your wallet gets smoked and they use mirror to deflect your billing questions. 😀
August 25, 2022 at 8:05 pm
I need to create a query where the first of March will be Week 1 starting from Monday to Sunday from the date. If the first of the month...
August 25, 2022 at 6:54 pm
In the past, we've found a lot of problems with automated deployments that can be described by one, single, four letter word...
"Oops". 😀
August 25, 2022 at 4:47 pm
I know... I'm weird... I couldn't stop laughing as I read the following article about AI and on-prem. I mean who knew that computationally intense processes on the cloud might...
August 25, 2022 at 4:42 pm
The Seek is probably a Seek followed by a range scan of the full table, which probably has little if any advantage over the scan. I only use the Execution...
August 25, 2022 at 2:26 am
Martin, your solution worked.
Thanks,
So I can learn a bit, which one of Martin's replies does that cover?
August 25, 2022 at 2:02 am
On the formatting thing, you could try a free website such as PoorSQL.com with the understanding that there is no support if something goes awry. There are other sites that...
August 24, 2022 at 7:28 pm
And, no... I wouldn't do a delete in batches. You end up blowing out the log file even with that and you end up with no temporary backup if something...
August 24, 2022 at 7:15 pm
Viewing 15 posts - 2,866 through 2,880 (of 59,067 total)