Viewing 15 posts - 14,866 through 14,880 (of 22,219 total)
Based on the information provided, it's hard to know for sure what's causing your deadlock. It looks like two different queries, but it's hard to say. The victim is 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
June 10, 2010 at 7:01 am
What does it matter which is faster? They are two completely different operations with entirely different purposes. You can't substitute one for the other. If I tell you backup 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
June 10, 2010 at 6:55 am
Conan The Canadian (6/10/2010)
Right now, I just don't have the time to commit to doing anything large in...
"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
June 10, 2010 at 6:51 am
Allen is pretty much "the guy" when it comes to this stuff. Sorry the book wasn't helpful, but track down anything he writes. Some of it has to help.
"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
June 10, 2010 at 6:13 am
Steve, I'd love to run, really. Not because I have some great ideas for where to take the organization but because I'm willing to get in there & work. However,...
"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
June 10, 2010 at 6:04 am
Jeff Moden (6/9/2010)
...nor do they knock their MVP rings...
Whoa! Hold on a sec... you got a ring? I didn't get a ring. If I had a ring it would be...
"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
June 10, 2010 at 5:50 am
Nice point on the INNER JOIN and the issues it causes.
"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
June 9, 2010 at 3:14 pm
If the BOL isn't helping, try 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
June 9, 2010 at 3:06 pm
Sure sounds like something is broken in the backup file:
SQL error 3241: SQL error 3241: The media family on device 'SQLBACKUP_273C82FD-3412-49B2-9669-42A275B6845802' is incorrectly formed. SQL Server cannot process this media...
"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
June 9, 2010 at 3:05 pm
By stating SELECT *, you're asking for everything. The only way to not get everything is to explicitly state what you want as the others have already said.
But, you can...
"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
June 9, 2010 at 3:02 pm
James O. (6/9/2010)
Thanks for the reply.I've deleted those views and replication was reinitialized just fine.
And FYI, I just bought your book! lol 😉
Glad I could help. I hope the book...
"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
June 9, 2010 at 2:51 pm
This is the cause of the Remote Scan, not the CTE:
INSERT INTO #tagData SELECT * FROM OPENQUERY([scada-02],'SELECT * FROM usascada.dbo.FloatTable');
What I'd suggest is putting some filters into that SELECT statement...
"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
June 9, 2010 at 1:54 pm
Welcome!
Those are very likely to be detritus from the Database Tuning Advisor. Why they are there? Hard to say, but it's likely that someone was running the DTA and had...
"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
June 9, 2010 at 11:25 am
You have to remember that views (except for indexed views) are just the underlying query. There is no special construct or nifty thing going on with them. Sometimes, the optimizer...
"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
June 9, 2010 at 11:23 am
GilaMonster (6/9/2010)
Grant Fritchey (6/9/2010)
"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
June 9, 2010 at 8:50 am
Viewing 15 posts - 14,866 through 14,880 (of 22,219 total)