Viewing 15 posts - 3,286 through 3,300 (of 59,067 total)
Here's another example where it appears to be a well supported "Holy Grail" article. But, it produces "week start dates" that are greater than the original date. That's means it's...
June 18, 2022 at 9:59 pm
Microsoft SQL Server 2016 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2016 SP1 to SP2. This service pack contains up to...
June 18, 2022 at 9:21 pm
Thanks for the information that you share with us. I will try to figure it out for more.
Hi and welcome aboard.
Be advised that your post looks and smells like...
June 18, 2022 at 9:17 pm
I think that the easiest way would be to add a column to table A with an "OffsetDate" column built in. That will also me nicely indexable and easy to...
June 18, 2022 at 9:15 pm
Hello friends, I am a casual learner and right now exploring the DBA field (I am a database developer). Now I recently had a discussion with my group of...
June 18, 2022 at 9:05 pm
multiple bulkier tables with years of data
https://www.sqlshack.com/database-table-partitioning-sql-server/
https://www.brentozar.com/archive/2012/08/potential-problems-partitioning/
Partitioning is not a method of increasing performance of code. In fact, it usually slows code down, sometimes by a far amount.
June 18, 2022 at 8:24 pm
A newbie here. I have these columns, here are the samples and the data types I've chosen:

I'd just like to ask if the choices I've made...
June 18, 2022 at 8:21 pm
It can't be deleted. No worries there, though. It can actually help others if they end up with a similar question.
June 18, 2022 at 7:56 pm
You know what I'm going to say, Phil. SSRS is... an application. You already know the rest.
June 18, 2022 at 7:42 pm
Thanks for the code modifications, Steve. I'll take a deeper dive than just looking at it. Nice to see someone actually test both out a bit.
In the past, I've shyed...
June 18, 2022 at 6:07 pm
LearnSQL wrote:Any suggestions or thoughts.
The function seems to generate the correct calendar. Nicely done Jeff 🙂
select * from dbo.CalendarByDateFirst('20211201', '20220131', 7);
Thanks a lot Jeff for...
June 17, 2022 at 7:55 pm
As a bit of a sidebar, man!... The supposed SQL Format for the code windows is absolutely horrible! 🙁 I wish they'd do something about it.
June 17, 2022 at 7:49 pm
Here's Rev 02 with a shedload more documentation in the flower box and 3 extra columns that seem useful to me. I think I may turn this into an article...
June 17, 2022 at 7:46 pm
Thanks Jeff,,
I have been using the formula:
if ($Average_Fragmentation -gt 40.00) { Write-Host -ForegroundColor Red "$Index_Name is more than 40% fragmented and will be rebuilt."; $index.Rebuild(); Write-Host -ForegroundColor Green...
June 17, 2022 at 1:53 am
Viewing 15 posts - 3,286 through 3,300 (of 59,067 total)