Forum Replies Created
Viewing 15 posts - 3,916 through 3,930 (of 22,219 total)
-
RE: Improving performance using partitioning
nadersam - Tuesday, April 11, 2017 5:16 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: There is insufficient system memory in resource pool 'default' to run this query.
For any given ID value, how many rows are returning? Even for a 500,000 row table, presumably a given ID value has what, 3-5 rows? 20? If you have a nonclustered index...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: how to determine who change the schema ownership?
On 2012 & better systems, it's a good idea to start looking to extended events for this type of info. There's a system_health extended event that runs, similar to the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Improving performance using partitioning
Gianluca already answered the question better than I would.
It's down to having a rock solid guarantee of partition elimination. So often we hear that, oh sure, they'll always filter...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Improving performance using partitioning
Jeff Moden - Monday, April 10, 2017 8:49 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: RedGate Log Shipping and True MSSQL Replication
If they are having trouble managing the logs, log files and log backups, regardless of the fact that Redgate Software is being used to do the backups & restores (DISCLOSURE:...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Improving performance using partitioning
Partitioning of data is meant to be a management tool, not a query performance tuning tool. It is quite rare to get performance enhancements out of partitioned data. You have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Question about Clustering & Includes
GilaMonster - Thursday, April 6, 2017 10:50 AMGrant Fritchey - Thursday, April 6, 2017 12:07 AMRE: Question about Clustering & Includes
bvaljalo-1000038 - Wednesday, April 5, 2017 5:12 PM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Upgrade SQL 2008 R2 Express to SQL 2014 Standard..How?
Oops. That link above is old. Use this one instead. I'll edit the other post.Follow the documentation is the single best advice I can offer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Upgrade SQL 2008 R2 Express to SQL 2014 Standard..How?
Do you want both versions of the software running on the system? If so, install 2014 and provide a named instance (which is generally considered a good practice...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Upgrade SQL 2008 R2 Express to SQL 2014 Standard..How?
I'm not completely sure I understand the set up or the question.
If you're asking how to upgrade your databases from 2008 to 2014, the best approach is to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Recomended Hyper-V Memory Settings
SQL Server within the VM is going to claim all the memory it can (as usual) and it won't release any. So it's not a surprise that you get 90%...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Need to update Price based on partial comparison of one column vs another ?
Add another column to your table that strips the leading zero and the trailing digit and use that for comparisons. That way you can index it and get decent performance....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Are the posted questions getting worse?
SQLRNNR - Tuesday, April 4, 2017 11:38 AMSo, in other news and because somebody is too quiet on the topic.This happened:
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningViewing 15 posts - 3,916 through 3,930 (of 22,219 total)