Viewing 15 posts - 1 through 15 (of 16 total)
On the subject of the backup failure...
IMHO (and experience but YMMV), it's a complete waste of time to backup a 2TB log file (happened to me the 2nd day...
September 26, 2023 at 4:15 am
If partitioning IS present, why is there a need for any of this? SWITCH the old data out. Copy it to a new table in the archive. Then SWITCH...
May 10, 2023 at 2:33 pm
Did you try to run this NOT using MERGE ?
No I have not. I'm mainly doing general administrator for the DB, the query itself is developed by my application...
May 10, 2023 at 8:02 am
May 8, 2023 at 1:38 am
I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to perform the creation job.
CREATE CLUSTERED...
May 5, 2023 at 3:03 am
If you've been running without partitions for 12 years or so, why add them back? Partitions are all about data management, not performance. If you're not dealing with all...
February 16, 2023 at 1:51 am
Hi All,
Thank you so much for your replies. Just to add on, does Microsoft mention anything about having a primary constraint and table partition together? As far as I know...
August 15, 2022 at 6:36 am
instead of a Primary Key you can define it as a Unique Index.
one of your issues is how you ensure that GSN_ID remains unique throughout the table. - a...
August 8, 2022 at 2:53 am
Here's the create index statement which the developers run.
Create NONCLUSTERED INDEX [IX_TileID_Include] ON [DB01].[dbo].[table1] ([Tile_ID]) INCLUDE ([Die_ID],[GGI_ID],[GGI_X],[GGI_Y],[DS1_ID],[DS1_X],[DS1_Y]) with (DATA_COMPRESSION = PAGE, ONLINE=ON)
As for the server spec, it's a VM server...
June 27, 2022 at 3:42 am
Hi Jeff & Alejandro,
Thanks so much for the insights and feedbacks. I've just join this new organization less than a month only so I'm still learning some of the process...
May 22, 2021 at 4:00 pm
Noted Grant! Thanks for the explanation. You're are absolutely correct that nothing can be missing from SQL BACKUPs, I did argue with the developers on this as well. However with...
June 17, 2020 at 1:19 am
Thanks all for the replies!
Unfortunately I don't have much info which I could share. The database itself doesn't have any tracing or monitoring turned on plus this issue happens on...
March 5, 2020 at 2:51 am
I notice you say this is a SQL Server 2008 R2 cluster. I want to get clarification on what you are saying. Are you saying when Node2 is the...
November 4, 2019 at 12:28 am
Thanks all for the reply.
I'm not well verse in using powershell, still rather new in managing a SQL server, so dbatools will gonna be challenging.
As for the versioning, my company...
October 3, 2019 at 3:37 am
Grant Fritchey - Monday, January 28, 2019 6:49 AMYep. You've got it.
Awesome, let me do some tweaking to my backup frequency.
January 28, 2019 at 6:58 am
Viewing 15 posts - 1 through 15 (of 16 total)