Viewing 15 posts - 181 through 195 (of 2,855 total)
I may be mistaken but I am pretty sure that the error "The specified network name is no longer available" means that your computer lost access to the server for...
June 14, 2024 at 8:30 pm
Just to add, data manipulation operations (INSERT, UPDATE, and DELETE) on a table need to modify most (all?) indexes on the table. So adding indexes to improve performance of deletes...
May 30, 2024 at 5:25 pm
Apologies for the confusions caused . I am planning to set the execution timeout for all queries that I will be running in SSMS. My goal is to stop...
May 30, 2024 at 2:56 pm
I think the problem is that you are trying to do something that doesn't make sense. The timeouts are configured on a session by session basis, not on an instance...
May 27, 2024 at 3:33 pm
Sorry, been traveling, but to me, I'd say there are a few big things and then a whole lot of small ones.
Biggies
May 24, 2024 at 9:49 pm
I agree with you Steve. Presenting is terrifying and also fun. My first presentation I did was actually as a guest presenter at a university course where the professor had...
May 24, 2024 at 2:56 pm
What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums. Apparently even Steve has zero pull with them.
Two short...
May 24, 2024 at 2:38 pm
The trick to solving this problem is to make getting into your software EASY and getting out impossible. One cloud CRM tool we had bought into years back helped us...
May 23, 2024 at 8:27 pm
CDC (change data capture) will track changes on a table, but it can be messy if you have a lot of data that changes, but how you describe it sounds...
May 22, 2024 at 5:55 pm
Just a little FYI too - when hiring a consultant, it never hurts to check what the consultant is an expert in. If you hire a consultant to evaluate your...
May 22, 2024 at 3:32 pm
If you are putting NOLOCK on an INSERT, UPDATE, or DELETE query, that's not going to do anything. SQL doesn't allow NOLOCK on data change operations as it...
May 22, 2024 at 3:08 pm
My opinion - NOLOCK is not a solution to blocking or deadlocks. NOLOCK is a "band-aid" solution in most cases and in the rare cases it is "needed", there are...
May 21, 2024 at 8:23 pm
My opinion (note I am NOT a licensing expert) - that falls under an "it depends" scenario. Microsoft probably doesn't care, but your government agency/license may be unhappy with their...
May 21, 2024 at 8:18 pm
I could be mistaken, but I thought the whole point of backup with checksum meant that the backup would contain a checksum in it for validation of the backup. Basically,...
May 20, 2024 at 1:00 am
Possibly a silly question but are the plans exactly the same apart from the estimates? What I mean is are you getting the same seeks and scans across all systems,...
May 15, 2024 at 9:31 pm
Viewing 15 posts - 181 through 195 (of 2,855 total)