Viewing 15 posts - 1 through 15 (of 2,356 total)
jasona.work wrote:....Being a pro-active guy, he went in and cleared out a couple profiles...
Why didn't he simply expand the disk? 😎
Honestly, two reasons:
April 3, 2025 at 3:56 pm
A little late for the preview of the SQL 2025 feature list:
https://www.brentozar.com/archive/2025/04/whats-new-in-sql-server-2025-2/
This actually got me all excited. Then I remembered what day it was...
April 3, 2025 at 3:49 pm
Find below steps to fix the tempdb issues.
1)DBCC SHRINKFILE ('tempdev', 1024)
The query executed successfully but the size of the database did not change.
2)SELECT * FROM sys.dm_exec_requests WHERE database_id =...
March 1, 2025 at 8:36 pm
Find below steps to fix the tempdb issues.
1)DBCC SHRINKFILE ('tempdev', 1024)
The query executed successfully but the size of the database did not change.
2)SELECT * FROM sys.dm_exec_requests WHERE database_id =...
March 1, 2025 at 8:36 pm
So, Wednesday, a member of our Infrastructure team asks me if my DBA group is the owner of an Azure database. I told him that is not a database, it...
February 24, 2025 at 3:51 pm
Is there any circumstances where you would allow code with a 'SELECT * ' to go into production?
I believe this should NEVER happen. There is a discussion that some...
February 21, 2025 at 7:39 pm
Worked perfectly!
Thank you!
January 23, 2025 at 3:57 pm
So there is no way at all to share storage for a new instance using fail over clustering? Kinda wish I knew this before hand.
If you didn't, then you...
January 22, 2025 at 5:17 pm
Also, ensure the MIN/MAX SQL memory is assigned properly.
Server has 32 GB, Min: 8 GB / Max 24 GB (for example)
With VM servers, sufficient memory is essential.
How did you...
January 2, 2025 at 2:50 pm
Apologies for taking a couple of days to reply. Those kind of checks are done by our VM admins as I'm not a VM admin.
I think by ballooning you...
January 2, 2025 at 2:48 pm
Happy New Year to all of you default blame acceptors!
Since we just went through a series of what all RTO stands for, how about folks chiming in with what...
December 31, 2024 at 5:59 pm
I would recommend updating statistics after you re-attach the database.
I've seen several people say that. I have to ask "Why"? The statistics are stored in the...
December 31, 2024 at 1:34 am
Great article!
Couple things to add, based upon doing this and encountering issues many times:
Unless you have to, do not move the detached log and data files. Copy and paste them,...
December 30, 2024 at 3:40 pm
Oh boy. Here are my Christmas presents.
December 16, 2024 at 8:49 pm
When you say the VM has been checked, can you elaborate? This really smells like VMWare ballooning resources.
December 3, 2024 at 3:13 pm
Viewing 15 posts - 1 through 15 (of 2,356 total)