Viewing 15 posts - 7,726 through 7,740 (of 22,224 total)
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
I don't agree that it's spam, but you're right, no sense in reinforcing any kind of clicks to bad info like 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 13, 2014 at 7:21 am
Why run snapshots over and over. What purpose is it serving?
"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 12, 2014 at 5:25 pm
Viewing 15 posts - 7,726 through 7,740 (of 22,224 total)