Viewing 15 posts - 1 through 15 (of 1,573 total)
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,
like this:
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
Also the trigger is to add logs to another table. This is usually used when user change address from user interface web site, so it is usually one record one...
February 14, 2022 at 9:51 pm
Yes, I did check the log space, I see there is plenty space while it is running.
This is a non-production environment for me to scramble data.
So I was able to...
February 14, 2022 at 9:48 pm
That works perfectly, thanks much!
February 13, 2022 at 4:01 am
Viewing 15 posts - 1 through 15 (of 1,573 total)