Viewing 15 posts - 1 through 15 (of 1,576 total)
Thank you so much Jeff, that is good information, I will read and look into it. Thank you for providing the links !
August 16, 2022 at 10:03 pm
Thank you Kaj, that was a great and easy trick.
Thank you so much!
August 15, 2022 at 4:57 pm
I was just curious if they are using same transaction log backup chain. It looks like they do.
I can think of a scenario, for example my log shipping set the...
July 1, 2022 at 3:36 pm
Thanks, the tail log backup makes sense now for me.
Additionally can I confirm the following statement is true?
When doing full backup in SQL server , It will include all data...
May 7, 2022 at 5:04 pm
That make sense. For this situation I asked is to restore database to the point that I start do the last full backup. So as I understand now it should...
May 6, 2022 at 9:31 pm
my total job takes 2 minutes if it is a successful run. so very quick. The ado.net source is a sql select query, it then goes to SQL server destination...
April 25, 2022 at 8:35 pm
That is a marvelous idea to get addresses. Thanks much, that gives me some ideas.
But what we need now is to create fake addresses for testing environment, not using real...
February 26, 2022 at 12:34 am
Thank you, I just want to generate some random fake data that look like street names, one word. 2000 or so. This is for testing DB that cannot have real...
February 25, 2022 at 4:47 am
No, my addMasterAddress table could have gaps for AddressID, that is why I am not using it, I use generated row_number,
with cteMasterAddressRow as
(SELECT *, row_number () OVER (ORDER BY...
February 16, 2022 at 9:16 pm
I think the row_number it generate as long as gurantee each address row is only used once , address it is unique, it is OK. there is no specific order...
February 16, 2022 at 7:54 pm
I think of way that may do it. I can add a column named row_number in the query for each table, and join with the row_number to update other columns...
February 16, 2022 at 7:17 pm
Basically I have two tables, one is AddMasterAddress table with 10000 records, the other is a new fake dataset let's call it FakeAddress table which has no identity column. So...
February 16, 2022 at 6:48 pm
yes, the performance are better if I test small batches of updating.
February 15, 2022 at 7:14 pm
sorry, the extension sql is not allowed, changed to .txt, attached
February 14, 2022 at 10:32 pm
table and script trigger attached.
February 14, 2022 at 10:04 pm