Viewing 15 posts - 3,031 through 3,045 (of 22,233 total)
And once you do what Grant instructed, if you still get the error, 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
September 4, 2018 at 7:24 am
"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
September 4, 2018 at 7:22 am
"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
September 4, 2018 at 7:20 am
Try it with NORECOVERY instead of RECOVER in the restore. leave it in the recovering state until the differential is done.
"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
September 4, 2018 at 5:13 am
First, a bit of clarity, the title says "Indexing a character column". Then you type that you want "Indexing on Numeric column types" and then you say that the majority...
"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
September 4, 2018 at 3:25 am
Profiler has been deprecated for a long time. However, there is no indication that it will be removed from the product any time soon. That said, don't use it. Extended...
"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
September 3, 2018 at 3:14 am
I'd change it. I don't know a good way to optimize rollbacks other than keeping the transactions as small as possible. Instead of rollbacks, can you truncate the test tables...
"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
September 3, 2018 at 3:12 am
Depending on the query, your structure, and your data, a scan may be better than a seek. Without seeing your query, structure and execution plan, I can't tell you why...
"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
September 3, 2018 at 3:10 am
Most people I know who have large estates purchase a third party tool to help with the management. I know that when I was managing a large SQL Server estate,...
"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
September 3, 2018 at 3:08 am
Yahoo?
Is that still a thing?
"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
August 28, 2018 at 8:07 am
"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
August 28, 2018 at 8:04 am
"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
August 28, 2018 at 7:17 am
"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
August 28, 2018 at 6:34 am
If the queries are primarily point lookup (one or only a limited set of rows, say hundreds or less), then no, columnstore is a very bad solution for you. If,...
"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
August 27, 2018 at 4:40 am
Another possibility is to query the plan cache to see which indexes are in execution plans there. That approach is dependent on the plan being in cache though.
"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
August 27, 2018 at 4:29 am
Viewing 15 posts - 3,031 through 3,045 (of 22,233 total)