Viewing 15 posts - 31 through 45 (of 1,769 total)
I would suggest setting max ram per instance.
As far I know SQL Server keeps consuming memory and never releases it, potentionally not leaving enough ram for OS, AV, ...
It can...
January 12, 2022 at 10:16 am
Thanks for voluntering. It's certainly helpful to make the skills more popular.
At Belgium we have coderdojo's to learn children to create websites, games, ... in the hope they will use...
January 3, 2022 at 4:25 pm
You've must have exhausted all other options. Maybe they have a six figure salary job opening
December 29, 2021 at 8:58 am
Happy holidays and Merry Christmas! Have a healthy and fun 2022
December 24, 2021 at 10:30 am
Doing fine. Bracing for omikron impact. There is also some budget tightening, luckily most sql databases are now sql 2019 or azure
December 21, 2021 at 9:51 am
I disagree with Chandler on avoiding an ICT position but heartily agree with "No position is worth dying over". Live your life instead of being lived.
Remote work is way more...
December 17, 2021 at 3:30 pm
How's everybody? Wishing a good 2022
December 17, 2021 at 3:24 pm
Hi,
Have a look at https://www.brentozar.com/archive/2021/11/video-office-hours-black-friday-edition-ask-me-anything-about-sql-server. It mentions a case of a slow running sp_BlitzFirst
I guess unless you pay Brent for it ( or use his consultant kit) ,...
December 17, 2021 at 3:11 pm
Express
Limited to lesser of 1 socket or 4 cores
It should use 4 cores if you present them as 1 socket, 4 cores.
If you would present is as 2...
December 1, 2021 at 1:36 pm
Higher core counts also mean higher licensing costs.
November 26, 2021 at 3:42 pm
Is the SSRS 2019 site in their single-signon internetzone? Browsers don't allow single signon by default
For IE it would be Security - Local Intranet ( Verification of user: only automatic...
November 23, 2021 at 12:53 pm
You could use
https://docs.dbatools.io/Copy-DbaDbTableData
with a query as a source.
Or export/import the data as csv from a restored backup
November 23, 2021 at 12:49 pm
4th wave is in full effect. Luckily most are vaccinated and have lower hopitalization needs.
Back to telework for a month
November 23, 2021 at 12:39 pm
Where is the DDL of ExtractReports.dbo.TAllData and [ExtractReports].[dbo].[TradeCodesInsert] ? I only see [Parts].[TradeCodes]
Is there any sample data to work on?
November 19, 2021 at 11:16 am
Thanks Jeff Moden for the extensive reasoning. Bookmarked this post.
Most of our non-guid indexes are fillfactor 100. If I understand correctly I'll better stop the index maintenance for now and...
November 5, 2021 at 4:29 pm
Viewing 15 posts - 31 through 45 (of 1,769 total)