Viewing 15 posts - 3,241 through 3,255 (of 22,214 total)
April 11, 2018 at 6:56 am
April 11, 2018 at 5:53 am
I do occasionally listen to music. I'm sure that's the same.
April 11, 2018 at 5:19 am
This bit of code:
like '%[^a-z0-9]william%[^a-z0-9]%'
Means that you're always going to be seeing scans of whatever indexes you have. I'm with Eirikur (always), in...
April 11, 2018 at 5:12 am
Looks like the problem is the CONVERT inside the ISNUMERIC command. It has to resolve that CONVERT in order to determine whether or not things are a number or not....
April 11, 2018 at 5:07 am
Why on earth would you change a database in simple recovery to full in order to backup the log, which is only going to contain transactions that haven't yet truncated...
April 11, 2018 at 5:02 am
Impossible to know without more information on what queries are causing the CPU usage and how you're measuring it.
April 11, 2018 at 4:57 am
the database is in full recovery and we have log backup for every 30 mins...
April 10, 2018 at 7:13 am
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
Viewing 15 posts - 3,241 through 3,255 (of 22,214 total)