Viewing 15 posts - 7,726 through 7,740 (of 22,226 total)
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.
"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
July 16, 2014 at 2:15 am
The Dixie Flatline (7/15/2014)
Sometimes I think MVPs are a real pain in the ***. Present company excepted.
Yes they are. And speaking for this present company, I am too.
"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
July 16, 2014 at 2:04 am
The only way I know of that you could currently do this would be to build it yourself. Whether you use SSIS or not is something of a discussion point,...
"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
July 15, 2014 at 10:25 am
I can't find the blog post at the moment, but Brad McGehee wrote up a great assessment comparing the benefits of index reorganization with the costs of index reorganization 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
July 15, 2014 at 10:22 am
I'm pretty sure there's no way to check that. You might look at the system health extended events session. It has a rolling log of certain events, but I'm pretty...
"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
July 15, 2014 at 10:12 am
murnilim9 (7/14/2014)
btw how do we find out which stored proc that...
"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
July 15, 2014 at 1:11 am
GilaMonster (7/14/2014)
rodjkidd (7/14/2014)
Sadly I have no costume for Friday 🙁I'm still working on mine. Dunno how Steampunk it is though. Limited by the requirement it be easy to pack.
I checked...
"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
July 15, 2014 at 1:02 am
sirvikasrana (7/14/2014)
Hema kumar-337490 (7/14/2014)
"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
July 14, 2014 at 9:10 am
rodjkidd (7/14/2014)
Grant Fritchey (7/14/2014)
rodjkidd (7/14/2014)
quackhandle1975 (7/14/2014)
Be nice to meet Steve Jones,...
"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
July 14, 2014 at 9:00 am
Then you need to use WITH MOVE.
"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
July 14, 2014 at 8:57 am
rodjkidd (7/14/2014)
quackhandle1975 (7/14/2014)
Be nice to meet Steve Jones, (and say thanks...
"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
July 14, 2014 at 8:52 am
Absolute and direct insider knowledge...
Expect an announcement this week, before SQL Bits starts. Promise.
"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
July 14, 2014 at 5:53 am
The name on a foreign key can be pretty much whatever you choose to define it as. Usually, I'd have it be descriptive, like DepartmentEmployeeFK or something similar, so that...
"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
July 14, 2014 at 5:52 am
That estimated cost isn't in real "seconds." It's just a number used for the internal calculations.
"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
July 14, 2014 at 5:24 am
You just need to run an ALTER TABLE script. Here's an article from Microsoft on how to do it.
"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
July 14, 2014 at 4:33 am
Viewing 15 posts - 7,726 through 7,740 (of 22,226 total)