Viewing 15 posts - 3,016 through 3,030 (of 22,219 total)
You can query the sys.sql_expression_dependencies to find that information. Here's documentation on that. I would also suggest you look into setting up a continuous integration process for your...
"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 5, 2018 at 2:00 am
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
Viewing 15 posts - 3,016 through 3,030 (of 22,219 total)