Viewing 15 posts - 16 through 30 (of 2,897 total)
Still in the ticket queue ?
Created a test thread and I still see this when there are 16 posts. When we get to 17, it appears to work. Updated...
August 3, 2023 at 1:27 pm
Yes, Annoying. I reported it over a year ago.
"....Just posting so Michael's post above will show up. This site won't show a single post on page 2. I really wish...
August 3, 2023 at 1:25 pm
At a minimum, before modifying a stored procedure, you can save the original, with a new name, such as appending the date on the end.
And add comments in the live...
June 23, 2023 at 1:00 pm
Do you need to convert the dates ? Isn't this OK ?
INSERT INTO homes.Properties
VALUES
(1, 1, '12a, Station Street, Liverpool', 500, '2019-12-31' )
,(2, 1, '12c, Station Street, Liverpool',...
May 30, 2023 at 3:10 pm
You may get better replies if you show what you have tried already, and what part is causing problems.
Expecting the entire solution from scratch seems a bit much.
May 30, 2023 at 3:05 pm
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
I'm pretty sure that BCP doesn't work on actual spreadsheets ((but...
May 9, 2023 at 7:06 pm
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
May 9, 2023 at 5:03 pm
You can script your PROD MyTable table as CREATE to a SQL window, change the table name to MyTable_Stage, and change all the data types to VARCHAR(nn) , then run...
May 8, 2023 at 6:57 pm
Go to DB Properties. What is the last log backup date ?
I just changed a FULL DB to SIMPLE and it still shows the last Log backup date after I ...
May 8, 2023 at 5:41 pm
When I have similar problems, I make a staging table with the same fields as production, but all defined as appropriate length VARCHAR to eliminate (or reduce) data mapping errors....
May 8, 2023 at 5:25 pm
Thanks for the comprehensive reply.
April 18, 2023 at 3:05 pm
It appears Datto also runs "DIFFs" during the day, but they also show as type 'D' in the SQL backupset table, not 'I' , and do not impact the native...
April 17, 2023 at 8:55 pm
"... ORDER BY 3 ..."
I recommend against this. Name the field.
If a new field gets added as 3rd field, you will get different results.
And, nobody knows what field '3' is,...
March 20, 2023 at 3:50 pm
Are these tables already being used ?
If so, Identify the "trouble areas" and look at how to fix them, rather than just build indexes you think might be needed.
March 20, 2023 at 3:46 pm
Sounds like he doesn't deserve the help.
March 2, 2023 at 5:50 pm
Viewing 15 posts - 16 through 30 (of 2,897 total)