Viewing 15 posts - 7,861 through 7,875 (of 22,219 total)
Chowdary's (6/30/2014)
If i change the Names of Mdf and Ldf from the Files page i can able to restore the Database...
"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
June 30, 2014 at 6:17 am
This is flat out a problem:
RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.CONTACT_PHONE
"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
June 30, 2014 at 4:55 am
If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning book done within a...
"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
June 30, 2014 at 4:54 am
You really want to look at the execution plan on something like this. There is no obvious issue with your T-SQL, so you read the execution plan to understand how...
"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
June 30, 2014 at 4:49 am
system_health extended event session is already capturing deadlock information for you if you haven't disabled 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
June 30, 2014 at 4:47 am
Personally, I don't like being out of support because if you have some type of major issue, Microsoft may not help. Most of the time and in most circumstances, this...
"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
June 30, 2014 at 4:46 am
Have you looked at the wait statistics to understand what the server is experiencing waits on? Further, capture the waits at the start of one of the slow processes and...
"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
June 30, 2014 at 4:44 am
Koen Verbeeck (6/27/2014)
Grant Fritchey (6/27/2014)
Anyone think they can help this person? I think they really need it, and what's more, deserve it. 6.5? Please, no.6.5 to 2000 with DTS. Ouch.
Stone...
"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
June 27, 2014 at 2:53 pm
GilaMonster (6/27/2014)
Grant Fritchey (6/27/2014)
You have a MIN without an ORDER BY. That can lead to bad data
How? Top without an order by I can see, MIN (the minimum value)...
"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
June 27, 2014 at 2:52 pm
Joy Smith San (6/27/2014)
You can change it manually.
Yes
"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
June 27, 2014 at 2:50 pm
Chord77 (6/27/2014)
He wants my primary role to be process improvement and creation. I've done it (successfully) in the past, but that wasn't 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
June 27, 2014 at 2:49 pm
Almost impossible to give you substantial suggestions without at least seeing the execution plan, but a couple of points. Do you really need the DISTINCT clause. That's going to cause...
"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
June 27, 2014 at 8:11 am
Anyone think they can help this person? I think they really need it, and what's more, deserve it. 6.5? Please, no.
"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
June 27, 2014 at 8:09 am
Wow! Well done.
I'm mainly working 2008 & up, so I'll be happy to help with that stuff.
Good luck on the DTS issue.
"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
June 27, 2014 at 8:07 am
Since your question is 2000 specific, you might get better responses posting it in a 2000 forum. I haven't touched a 2000 server for several years now, let alone messed...
"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
June 27, 2014 at 7:18 am
Viewing 15 posts - 7,861 through 7,875 (of 22,219 total)