Viewing 15 posts - 4,681 through 4,695 (of 22,227 total)
For testing purposes, I'd suggest you restore to a different SQL Server instance other than your production instance. Make mistakes elsewhere. You don't want to screw up production.
"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 13, 2016 at 4:24 am
Ray K (6/6/2016)
Grant Fritchey (6/5/2016)
Ray K (6/4/2016)
Grant Fritchey (6/4/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 6, 2016 at 4:06 pm
Ray K (6/4/2016)
Grant Fritchey (6/4/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 5, 2016 at 4:03 am
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
Viewing 15 posts - 4,681 through 4,695 (of 22,227 total)