Viewing 15 posts - 4,681 through 4,695 (of 22,224 total)
In an hour... you've got almost no time. I'm teaching an introductory course over a lunch next week. I keep thinking of stuff I want to include, but there's just...
"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 4, 2016 at 5:51 am
David Burrows (6/3/2016)
Grant Fritchey (6/3/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 3, 2016 at 6:54 am
Grumpy DBA (6/3/2016)
Grant Fritchey (6/3/2016)
Brandie Tarvin (6/3/2016)
Steve Jones - SSC Editor (6/1/2016)
SSMS is decoupled from SQL. You need to install that separately.
Wait. Client tools are no longer an option 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
June 3, 2016 at 6:01 am
You can try going into the Tools, Options menu. Once there, scroll down to SQL Server Object Explorer. Select the Scripting option. Then scroll down until you see "Generate script...
"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:59 am
Brandie Tarvin (6/3/2016)
Steve Jones - SSC Editor (6/1/2016)
SSMS is decoupled from SQL. You need to install that separately.
Wait. Client tools are no longer an option to install with the rest...
"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:40 am
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
Viewing 15 posts - 4,681 through 4,695 (of 22,224 total)