Viewing 15 posts - 1 through 15 (of 533 total)
Thanks, I am a little rusty!
Phil.
February 1, 2022 at 6:48 pm
I amended to smallint.
Phil.
February 1, 2022 at 11:38 am
Hi. Thanks for the response.
"On a side note, you declare @Size as bigint."
I am showing my lack of understanding 🙂
What would you suggest?
HAVING SUM([FileSize]) /1048576.0 > @Size - This returns...
February 1, 2022 at 11:32 am
Doh. it should have been:
HAVING SUM([FileSize]) /1048576.0 > @Size
So I think I am all set.
Feel free to offer a better approach.
Phil.
February 1, 2022 at 10:10 am
Thank you all for your expert input. As always greatly appreciated.
Phil.
January 28, 2022 at 9:48 am
Thanks very much for your responses. I will amend what i have.
Point duly noted regards using functions in WHERE clause.
Many Thanks,
Phil.
January 27, 2022 at 8:24 pm
Hi Jeff. I changed my approach and formatted within the SSRS report rather than the code.
SQL query now SUM([FileSize]) AS SumOfFileSize
Many Thanks,
Phil.
January 27, 2022 at 4:43 pm
--This did the trick
ROUND(SUM(CAST([FileSize] AS BIGINT)/1048576.0),2)) AS [FileSizeMB],
ROUND(SUM(CAST([FileSize] AS BIGINT)/1073741824.0),2) AS [FileSizeGB]
Thanks,
Phil.
January 25, 2022 at 3:18 pm
Thanks for your response Jeff. Glad to see you are still going strong. I will have a play. Keep up the great work.
Kind Regards,
Phil.
January 25, 2022 at 3:14 pm
Thank you for your replies.
I added: CAST(FileSize AS decimal(35,2)) AS FileSize,
+
WHERE Domain = @Domain AND convert(bigint, Filesize) > 50000
That worked so many thanks.
One last question...
--I added
ROUND(SUM(CAST([FileSize] AS...
January 25, 2022 at 9:54 am
Hi. Where?
Looks like you need BIGINT instead of INT.
I tried:
SUM(CAST([FileSize] AS BIGINT)/1048576.0)) + ' MB' AS [FileSizeMB]
Kind Regards,
Phil.
January 24, 2022 at 5:08 pm
Hi. I guess it doesn’t make much difference but the deletes were performed in batches over a 24 hour period.
Thanks,
Phil
November 15, 2020 at 10:20 pm
Hi. I will need to check. I am surprised it is 600+GB.
Phil.
November 15, 2020 at 9:54 pm
Hi. I do not manage SQL I’m the tech lead on the application.
The database is in a cluster hosted in Azure. I have been advised recovery model must be set...
November 15, 2020 at 4:32 pm
Hi. Yes the transaction log is that large.
Thanks,
Phil
November 15, 2020 at 11:51 am
Viewing 15 posts - 1 through 15 (of 533 total)