Viewing 15 posts - 11,431 through 11,445 (of 22,224 total)
Looking at the execution plan, your indexes may need some work. I would concentrate on the clustered index scan. You've got this as a predicate:
[CardData_Test].[dbo].[FleetcorOPIS].[start_date] as [O2].[start_date]<=[CardData_Test].[dbo].[transactions_recon].[TRDATE] as [R].[TRDATE] 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
January 12, 2012 at 6:31 am
Nuts. I was hoping one of you knew the answer to this. I wanted to put SQL Server on my Thrive.
"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
January 12, 2012 at 6:10 am
I just finished writing part of the chapter of my new book on troubleshooting memory issues. Let's see how it works.
First, check Memory:Available Bytes. Is that low? If so,...
"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
January 12, 2012 at 6:09 am
Was there a large data load on Monday? How about an index defrag process or something along those lines where large portions of the data would be affected and marked...
"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
January 12, 2012 at 6:00 am
DeanORenO (1/11/2012)
There is also this proclivity for answering questions with questions or turning the question on the asker, like most of the replies to my question will inevitably be.
I'm sorry...
"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
January 12, 2012 at 5:52 am
Bex (1/12/2012)
Grant Fritchey (1/12/2012)
GilaMonster (1/12/2012)
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspxAlready responded. I'm waiting to see his answer before continuing.
I just had a look over...
"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
January 12, 2012 at 5:49 am
GilaMonster (1/12/2012)
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspxAlready responded. I'm waiting to see his answer before continuing.
I just had a look over his posting history,...
"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
January 12, 2012 at 4:46 am
Looking at the restore command itself, logically it makes sense. You're going to have to break down & issue print statements to validate that everything is working. Instead of trying...
"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
January 11, 2012 at 9:12 am
azdzn (1/11/2012)
Querying the plan cache will do the trick ! Good idea !Thanks a lot Grant and Gail.
Sure thing. Just remember, as I say in the article, direct queries against...
"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
January 11, 2012 at 8:19 am
Maybe you need to do:
SELECT * FROM schema.table
If the table is not in your default schema, it won't just show up automatically.
"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
January 11, 2012 at 8:17 am
Stefan Krzywicki (1/11/2012)
GilaMonster (1/10/2012)
mtillman-921105 (1/10/2012)
I guess I'm really the only nerd around here,You and me apparently. We'll go be hopeless somewhere...
You are not alone. I'm definitely a nerd.
Not me. I'm...
"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
January 11, 2012 at 7:35 am
Scans are only one indicator of poor performance and are actually not even always a good indicator. SQL Server will run faster using a scan instead of a seek on...
"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
January 11, 2012 at 7:30 am
But you have a good backup you can go to and retrieve everything, right?
If not, why not?
"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
January 11, 2012 at 6:23 am
Except for what Gianluca has posted, you're in trouble. However, going forward, you might try getting a copy of this tool from Red Gate. It can help with exactly this...
"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
January 11, 2012 at 6:22 am
And is it working for you?
"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
January 11, 2012 at 4:45 am
Viewing 15 posts - 11,431 through 11,445 (of 22,224 total)