Viewing 15 posts - 11,746 through 11,760 (of 22,219 total)
paul_ramster (10/5/2011)
where PostedDate='1/19/2011'
and PostedDate is defined in the view as:
CAST(CAST(SUBSTRING(WH_Status.StatusHistory,CHARINDEX('Batch posted successfully',CONVERT(VARCHAR(MAX),WH_Status.StatusHistory))-35,26) AS DATE) AS DATETIME) AS PostedDate
You will always get a scan on...
"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
October 5, 2011 at 1:40 pm
chandan_jha18 (10/5/2011)
Grant Fritchey (10/5/2011)
You say you're getting a table scan, do you have clustered indexes on 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
October 5, 2011 at 1:06 pm
timscronin (10/5/2011)
Could I not setup another instance on the existing clusters and log ship/mirror to that node?
Yeah, as long as it's a separate instance. In terms of a DR situation,...
"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
October 5, 2011 at 10:13 am
If the DB names are the same, you won't be able to log ship or mirror and still have access to one of the databases.
"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
October 5, 2011 at 10:07 am
No real way to tell you anything without more information. Minimum an execution plan.
You say you're getting a table scan, do you have clustered indexes on the tables? If 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
October 5, 2011 at 9:41 am
If the CPU is 100%, I'd focus there, not on memory. Memory pressure can evidence itself with increased I/O as more stuff gets flushed to disk more frequently, but it's...
"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
October 5, 2011 at 7:47 am
From what you're saying, it's dynamic. You won't be able to create a plan guide for it. Modify the text and put in hints directly or take away the dynamic...
"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
October 5, 2011 at 7:42 am
What problem are you trying to diagnose?
"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
October 5, 2011 at 7:38 am
Scans aren't necessarily bad and seeks aren't necessarily good. It really depends on their relationship to the rest of the process, the number of rows involved, joins associated... It's actually...
"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
October 5, 2011 at 7:35 am
But then you build the system to allow the drill-down to make another query. I've been through this too, at multiple organizations with multiple different data sets. There are 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
October 4, 2011 at 12:19 pm
Absolutely. It's like an on/off switch. Put a clustered index on the table, and the table becomes the clustered index. Without a clustered index, the table is a heap. That's...
"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
October 4, 2011 at 8:19 am
Ninja's_RGR'us (10/4/2011)
solomon.jernas (10/4/2011)
For reporting purpose, but all connection are suspended stauts, ather application getting time out issue web page,Thanks
Why don't you return the sum (or what ever aggregate) 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
October 4, 2011 at 6:49 am
You're returning a million records in a minute? Sounds like performance is OK. Why are you returning a million records?
"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
October 4, 2011 at 4:24 am
parsayandan (10/3/2011)
and If your think was true I delete SCC data or data that have problem...
"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
October 3, 2011 at 4:59 pm
Stefan Krzywicki (10/3/2011)
Grant Fritchey (10/3/2011)
"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
October 3, 2011 at 11:58 am
Viewing 15 posts - 11,746 through 11,760 (of 22,219 total)