Viewing 15 posts - 3,226 through 3,240 (of 22,206 total)
April 12, 2018 at 5:10 am
April 12, 2018 at 5:07 am
So, the databases all have the same name? If so, you can't put them all on the same instance. So, your options are, in the case of server consolidation, to...
April 12, 2018 at 4:35 am
I won't be able to give you a total run down on everything, but let's cover a few of the topics you raise. We'll start just at the data center.
April 12, 2018 at 4:31 am
Alexander Zhang - Wednesday, April 11, 2018 1:36 PMBTW, there is no specific purpose, but for some unreasonable and stupid curiosity:-)
Have fun.
Maybe...
April 11, 2018 at 1:41 pm
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
Viewing 15 posts - 3,226 through 3,240 (of 22,206 total)