Viewing 15 posts - 3,241 through 3,255 (of 22,206 total)
First, why is the log so big? Shrinking it is just a matter of issuing the command. It shouldn't take your server down. However, you need to know why the...
April 10, 2018 at 5:03 am
Strong vote for following Jeff Moden's approach to splitting strings. It's been tested to scale to which most of us will never be messing with.
April 10, 2018 at 5:01 am
April 10, 2018 at 4:52 am
April 9, 2018 at 4:26 pm
Sounds like high volume on transactions that are affecting latching and locking. Options 1) identify the queries taking part, tune them. Option 2) throw lots of money at the server...
April 9, 2018 at 12:24 pm
A backup is a page by page copy of your database that takes into account the fact that active transactions are occurring so that it has a recovery phase when...
April 9, 2018 at 9:33 am
You can't disable it, no. The best thing to do would be to try capturing the logins and connections using extended events. You can maximize the details available to you...
April 7, 2018 at 8:09 am
April 6, 2018 at 10:10 am
You can create a trigger on a view. Here's the documentation.
Instead of a trigger, I'd suggest a design that let's you add jobs. What if they...
April 6, 2018 at 9:14 am
Certainly replacing the table variable with a temp table will likely lead to improvements as will the code that Chris is suggesting.
However, that doesn't explain why you're seeing...
April 6, 2018 at 7:21 am
Lots and lots of scans. Despite a large number of filters, you're getting scans all over the place. Ignoring the fact that you don't have clustered indexes, the indexes you...
April 6, 2018 at 7:15 am
Why not use Extended Events. You're on 2016. They're better and generally more accurate.
April 5, 2018 at 12:14 pm
April 5, 2018 at 9:29 am
Viewing 15 posts - 3,241 through 3,255 (of 22,206 total)