Viewing 15 posts - 7,756 through 7,770 (of 22,219 total)
Deepak Burkul (7/11/2014)
yes this is interview question and i am going to learn more on execution plan of SQL server that time i get this confusion about Physhical Join...
"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 3:15 am
SQLRNNR (7/10/2014)
Grant Fritchey (7/10/2014)
SQLRNNR (7/10/2014)
Grant Fritchey (7/10/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 11, 2014 at 3:07 am
SQLRNNR (7/10/2014)
Grant Fritchey (7/10/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 10, 2014 at 10:54 am
Chowdary's (7/10/2014)
I think this is ok for all of us if i say like Thank you all...
But one thing whenever i post a query i get the answers...
"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 10, 2014 at 7:52 am
I get it. I'm not the brightest bulb in the box, but I can usually understand the logic of processing data most of the time. I'm utterly at a loss...
"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 10, 2014 at 7:50 am
Without the wild card on the comparison to 'R' you might as well drop the LIKE statement and say <> instead.
"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 10, 2014 at 6:45 am
This question gets asked a lot. You can search out the answers. In fact, I'd practice learning how to look up stuff on the internet. Don't assume that you need...
"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 10, 2014 at 6:44 am
And Loops Join.
But what's the real question? Is this an interview question, or are you looking to solve a problem?
"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 10, 2014 at 4:55 am
I don't think that will help. Most of those errors are not from tempdb, they're from another database. And, everything is from drive F. It looks like that drive is...
"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 10, 2014 at 4:54 am
I am not an Access person, but Access absolutely can call stored procedures within SQL Server and based on what you're describing, that's what you want, not a view. Or,...
"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 10, 2014 at 4:52 am
Chowdary's (7/10/2014)
Thank you Mr.Gail Shaw for giving the reply.If All the Differential Backups got corrupted means in that case what will be the resolution to restore the data.
Regards
Jagadeesh...
If all 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
July 10, 2014 at 4:47 am
It sounds like you're trying to capture some enormous execution plan or an execution plan on a cursor or something like that. SET STATISTICS XML OFF is just turning off...
"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 10, 2014 at 4:36 am
Maybe caching at the client, try a refresh... grasping at straws here. I've only ever seen it work.
"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 9, 2014 at 11:57 am
It's not something I've tried before, but you'll have to restore all the database at least once before you can access it. In a partial restore operation, you're only moving...
"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 9, 2014 at 11:55 am
Not sure where you're pulling that information from, but it looks like a session is rolling back a transaction and is waiting on the disk.
"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 9, 2014 at 11:53 am
Viewing 15 posts - 7,756 through 7,770 (of 22,219 total)