Viewing 15 posts - 3,241 through 3,255 (of 22,219 total)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2018 at 1:41 pm
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2018 at 12:40 pm
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2018 at 6:56 am
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2018 at 5:53 am
I do occasionally listen to music. I'm sure that's the same.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2018 at 4:57 am
the database is in full recovery and we have log backup for every 30 mins...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 10, 2018 at 5:01 am
Viewing 15 posts - 3,241 through 3,255 (of 22,219 total)