Viewing 15 posts - 7,726 through 7,740 (of 22,219 total)
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
Just bumped by Gus on the Total Points board. Still behind him on the forum posts count.
"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:23 pm
Tough situation. I can't tell you that you made the right call. But, if you put yourself in what you think is the right situation, then you did the right...
"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:22 pm
enrique.mallon (7/12/2014)
Such condition arises when SQL Server database becomes deadlock and you are unable to perform action or transaction on it. It means that your SQL database got...
"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:21 pm
hoa.nguyen 64423 (7/11/2014)
At this writing, I have 2 environments DEV and QA. In QA...
"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 11, 2014 at 11:44 am
Adding the file is going to be a logged operation. The restore will include 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 11, 2014 at 11:36 am
Viewing 15 posts - 7,726 through 7,740 (of 22,219 total)