Viewing 15 posts - 2,266 through 2,280 (of 2,648 total)
well. the first link shown on google search has one that does give you the backup times - no duration as that is not available on msdb.
For duration you...
September 29, 2018 at 6:20 pm
have you even bothered googling for the answer?
https://www.google.ie/search?q=sql+server+restore+history+mssqltips
September 29, 2018 at 1:45 pm
September 26, 2018 at 11:17 am
Both BIDS/SSDT and the gui are 32 bit - server is running 64 bit so this is most likely the issue
install the 64 bit version of that component -...
September 25, 2018 at 1:15 pm
Take in consideration that the Express limit is per database - you can have 100 databases all with 10 GB each.
Depending on your application you may be able...
September 24, 2018 at 7:02 am
Most likely the issue is on the application side and how the data is being split/processed.
Adding to the fact that you said you could not do parallel processing this...
September 23, 2018 at 12:56 pm
Yes.
Just copy the packages or the ispac file to a location that your scheduler software (or SQL Server Agent user) has access to and then use the command...
September 19, 2018 at 3:39 pm
on your catch block output the error exception (and inner exception if any) to your log file and see exactly what the error is.
One thing that is likely...
September 5, 2018 at 4:38 pm
have you tried setting Delayed Durability? just to see the impact - and permanent setting if it improves and the DB can leave with it on (or at least the...
September 2, 2018 at 4:41 pm
install SQL Server 2017 express and make sure the path for its executables is on your path variable
September 2, 2018 at 1:16 pm
select convert(decimal(10,2), replace(replace('"6,789.01"', '"', ''), ',',''))
would do the trick - but if using SSIS or other tools those sometimes handle that on their own without any...
August 31, 2018 at 12:36 pm
August 31, 2018 at 12:22 pm
Viewing 15 posts - 2,266 through 2,280 (of 2,648 total)