Viewing 15 posts - 4,681 through 4,695 (of 22,219 total)
There's not enough to go on, but I can make a couple of suggestions.
First, it sounds like you might be hitting bad parameter sniffing. If a recompile changes the behavior...
"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
June 3, 2016 at 5:34 am
The online operation keeps a temporary copy of information available as it does the rebuild. Temporary just about anything within SQL Server goes into tempdb. You can read about 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
June 2, 2016 at 8:16 pm
You need to reexamine how you are creating your key structure. You can't have a primary key that consists of four columns and then a foreign key that consists of...
"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
June 2, 2016 at 4:45 pm
It's possible you've set the lock timeout and you're hitting it. Or, you need to apply a service pack or cumulative update.
"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
June 2, 2016 at 4:39 pm
GilaMonster (6/2/2016)
Grant Fritchey (6/2/2016)
jasona.work (6/2/2016)
I read this and suddenly felt millions of DBAs cry out in horror...(Yes, it's the Daily WTF, scarily it might even be (mostly) true)
Great story. 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
June 2, 2016 at 4:37 pm
I have no inside information on this, but I have a guess.
It may have something to do with the work done by the optimizer, specifically the algebrizer process that identifies...
"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
June 2, 2016 at 2:30 pm
jasona.work (6/2/2016)
I read this and suddenly felt millions of DBAs cry out in horror...(Yes, it's the Daily WTF, scarily it might even be (mostly) true)
Great story. A true horror. And...
"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
June 2, 2016 at 2:19 pm
Ed Wagner (6/2/2016)
jasona.work (6/2/2016)
Happy National Leave the Office Early Day!!![/url]So, who's going to celebrate this day today?
😀
I must admit that it looks like as good a reason as any, but...
"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
June 2, 2016 at 8:39 am
There are a lot of commands in SSMS that use server level calls to work. So, they don't work well with Azure. The basics are there, but not the more...
"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
June 1, 2016 at 8:25 pm
There is no easy way to do this. Each report can be an ad hoc T-SQL statement, a stored procedure or a view. You can at least document the dependencies...
"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
June 1, 2016 at 4:28 pm
That command isn't one I would have used all that much in the past which might explain why I had to look it up. If you look at the documentation...
"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
June 1, 2016 at 3:36 pm
yb751 (6/1/2016)
Grant Fritchey (6/1/2016)
yb751 (6/1/2016)
Steve Jones - SSC Editor (6/1/2016)
yb751 (6/1/2016)
The purchase of some Red Gate tools finally got approved by my boss. 😀
Feels like I've been...
"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
June 1, 2016 at 3:17 pm
Eric M Russell (6/1/2016)
Grant Fritchey (6/1/2016)
Eric M Russell (6/1/2016)
"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
June 1, 2016 at 3:01 pm
Eric M Russell (6/1/2016)
"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
June 1, 2016 at 1:15 pm
And if you're going to apply them as is (and please read Kevin's warnings, they're very accurate and if anything not dire enough), the keys consist of the equality and...
"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
June 1, 2016 at 12:41 pm
Viewing 15 posts - 4,681 through 4,695 (of 22,219 total)