Viewing 15 posts - 7,861 through 7,875 (of 22,224 total)
Perry Whittle (6/30/2014)
Grant Fritchey (6/30/2014)
As long as you have unique file names on a given server,
It's not the server dictating this. You can have 100 databases all with the primary...
"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 9:13 am
Not sure then in that case. I've seen poor performance in some machines after waking, but not a specific query issue with SQL Server.
"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 8:40 am
george sibbald (6/30/2014)
"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 8:11 am
Chowdary's (6/30/2014)
Actually am checking the server which is having only 2012.There am getting the issue.
Pls help me out if there is any...
"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 8:09 am
Is the machine you're querying from and the data location and the machine going to sleep, all the same machine? If so, I suspect you're probably seeing some memory artifact...
"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:32 am
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
Viewing 15 posts - 7,861 through 7,875 (of 22,224 total)