Viewing 15 posts - 136 through 150 (of 2,339 total)
- you're running queries at the same time as the defrag process, in which case you really need to look at your maintenance windows
A 24/7 operation doesn't really have...
June 13, 2023 at 1:08 pm
I'm sure there's a valid argument there Paul, but then amount of energy it'd take to convince my colleagues, plus the fact that removing defragging would be blamed for...
June 13, 2023 at 12:00 pm
Replacing an old server with a newer one. A job that runs fine on the old, refuses to work on the new. Old 2012, new 2019. Both servers (VM)...
June 12, 2023 at 3:41 pm
Here's a thought. Stop reindexing.
June 12, 2023 at 3:36 pm
And you now have COBOL in the .NET world, so it is evolving.
The first time I saw that, I kind of fell out of my chair. I think it...
June 2, 2023 at 2:05 pm
My question was something else, kindly help here.
I know about committing and rollback.
yours sincerley
Your code, as posted, will not commit the inner transactions. The outer transaction, as...
June 2, 2023 at 2:04 pm
Your example of some developers testing 100 rows of data, then thinking that will scale to 1 million rows, is valid.
One of the contractors submitted code. They created...
June 1, 2023 at 2:48 pm
My question was something else, kindly help here.
I know about committing and rollback.
yours sincerley
Your code, as posted, will not commit the inner transactions. The outer transaction, as Grant said,...
June 1, 2023 at 1:09 pm
Jeffery, you are wasting your time. Dennis is always right, and he knows everything.
May 31, 2023 at 7:24 pm
There is no UNC based access between the two machines?
\\ServerB\backups\copy
Like this?
To elaborate, on the destination server, there may be a folder that is shared that you can access using...
May 31, 2023 at 4:31 pm
If Internet available at prod server, upload it thru google drive and download it from dev server (Internet availability)
I would NOT do that. That will likely violate rules that...
May 31, 2023 at 4:27 pm
The build vs buy is a challenge. The question is what is the need? Will an off the shelf package provide all of what you need?
Probably not. It seems as...
May 31, 2023 at 4:22 pm
I was not the one that brought up precision, you did. I just explained there there is no precision issue with DATETIME2 as you so claim.
Jeffery never said...
May 31, 2023 at 4:02 pm
There is no such thing as a nested transaction.
If you think that the inner transaction will commit in the code you posted, it will not. The final rollback or commit...
May 31, 2023 at 3:55 pm
It is a client's production Windows server. And there is no FTP or any file-sharing service available. Then how can I copy the backup file to the new server...
May 31, 2023 at 3:53 pm
Viewing 15 posts - 136 through 150 (of 2,339 total)