Viewing 15 posts - 18,016 through 18,030 (of 22,219 total)
Since it's not executing, can you post the estimated execution plan?
It sounds like you might be getting some blocking. Are there other processes hitting the table at the same time?
"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
March 14, 2009 at 5:37 am
Amit Lohia (3/13/2009)
I do not think it will make much difference but my testing is on platform 64
I think that's worth noting. Now we know it happens on two platforms....
"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
March 13, 2009 at 11:00 am
If it's two different plans, that's probably the issue.
Make sure the same parameters are in use on both and make sure that both have updated statistics and defragmented indexes.
The very...
"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
March 13, 2009 at 10:30 am
Different parameters?
"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
March 13, 2009 at 10:23 am
Nope removing the certificate didn't fix the issue. That makes me feel better. There must be an alter database statement that removes the reference to encryption.
"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
March 13, 2009 at 8:27 am
Nuts. I might have been premature in posting to Connect. I finally found another reference:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351548&wa=wsignin1.0
I'm testing removing the certificate now.
"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
March 13, 2009 at 8:20 am
I posted it to Connect:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=423249
You can vote on it, set the priority, add your comments, especially since this is your issue.
I'm going to keep hacking at it as time allows.
"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
March 13, 2009 at 8:14 am
I hit the same issue. I went back to retest and now I'm hitting the issue on the test database, where I didn't hit it before...
I'm trying to track down...
"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
March 13, 2009 at 7:59 am
I think that's a torn page error. Try running a consistency check on the source db.
"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
March 12, 2009 at 5:27 pm
Bob Hovious (3/12/2009)
Congratulations, Gail 🙂 And congratulations also for being Geek of the Week.http://www.simple-talk.com/opinion/geek-of-the-week/gail-shaw-geek-of-the-week/
Yeah, congrats.
I confess I saw a tweet from someone over there...
"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
March 12, 2009 at 5:20 pm
Lynn Pettis (3/12/2009)
GilaMonster (3/12/2009)
Lynn Pettis (3/12/2009)
I have to agree as well. I'd love to get Babylon 5 on DVD.http://www.amazon.com/Babylon-5-Complete-Television-5-Pack/dp/B0001M3MXY/
I just sent "she who must be obeyed" the link 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
March 12, 2009 at 5:18 pm
GilaMonster (3/12/2009)
Alvin Ramard (3/12/2009)
Did you notice that was the OP's first post?
Yup. It factored into my decision to 'challenge' him. I'm curious how he's going to reply.
Rule 1...
"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
March 12, 2009 at 5:17 pm
GilaMonster (3/12/2009)
Bob Hovious (3/12/2009)
I missed out on Babylon 5 🙁 It fell during a period of years where I never had time for TV.
It's available 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
March 12, 2009 at 5:15 pm
Yep. Just did. Works great. Turn on encryption on one machine, including setting a certificate and enabling it on the database. I ran a backup from there that was encrypted....
"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
March 12, 2009 at 11:03 am
You want to use the datepart function. You can look it up in BOL for all the permutations, but it basically works like this:
SELECT DATENAME(yyyy,'3/12/2009') AS 'Year'
"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
March 12, 2009 at 9:24 am
Viewing 15 posts - 18,016 through 18,030 (of 22,219 total)