Viewing 15 posts - 11,761 through 11,775 (of 22,226 total)
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
No contact links anywhere on that EMC blog. So I went to the EMC site, the contact us link is prominent, but you get a 404 error (and not 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
October 3, 2011 at 11:08 am
WayneS (10/3/2011)
Grant Fritchey (9/28/2011)
WayneS (9/28/2011)
Grant Fritchey (9/28/2011)
Jack Corbett (9/28/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 9:52 am
The SQL Server service is the one that runs backups.
"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 5:01 am
Mr. Holio (10/3/2011)
Thanks.So when do do you usually look at the time stats if it is "not a way of measuring performance at all" ? Thank you.
I probably wasn't...
"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 5:00 am
Then the restore is not complete. It's still rolling forward or rolling back transactions to finish up. That, or your backup processes had NORECOVERY set, in which you case you...
"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 2, 2011 at 6:43 am
Not sure, downloaded the ISO, used that in my virtual server and had it set up and running in a trice. No issues, no problems. Just not sure what 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
October 2, 2011 at 6:41 am
Here's the documentation on Common Table Expressions.
"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 2, 2011 at 6:38 am
SQLIO is a great tool for measuring the IO performance of the system. It's not hard to set up and the tests will tell you what you need to know...
"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 2, 2011 at 6:37 am
Viewing 15 posts - 11,761 through 11,775 (of 22,226 total)