Viewing 15 posts - 12,361 through 12,375 (of 22,227 total)
Not having your data, it's hard for me test this, but you can try moving the other WHERE criteria into the JOIN clause. When dealing with OUTER JOINs, filter criteria...
"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 11, 2011 at 9:26 am
muthukkumaran Kaliyamoorthy (6/11/2011)
ting.kris (6/11/2011)
Spam. Please don't respond.
You don't need to do that. Just click on the Report button and ignore the post otherwise.
"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 11, 2011 at 5:52 am
shiv-356842 (6/11/2011)
Hi Team,What is difference between Migration and Upgradation... please guide me.
Tx
I'm not sure what context you're asking the question, but here's my swipe at an answer.
A migration is 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
June 11, 2011 at 5:51 am
In addition to the order, you also have to worry about permissions. Do you have permissions to create the objects? Once created, do the objects have permissions to see other...
"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 11, 2011 at 4:56 am
Depending on how you're defining transactions, you could go the Performance Monitor route, which just counts transactions, or you may need to set up a server side trace. 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 11, 2011 at 4:52 am
One piece of advice. You're writing your queries using the ANSI 89 standard on joins. Don't do that. As soon as you get to outer joins you're going to have...
"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 11, 2011 at 4:50 am
Man, I couldn't have been further off track. I totally missed several key words and tricky phrases in the original question. Sorry for any confusion tossed into the mix.
"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, 2011 at 4:18 pm
I wrote an article outlining several ways to get versioned data. Latest date is not any different than latest version. Take a look at this[/url] and post back here if...
"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, 2011 at 2:40 pm
You're performing either ANSI 89 style joins. Instead, you should use the ANSI 92 style
SELECT ...
FROM TABLEA AS a
JOIN TABLEB AS b
ON a.ID = b.ID
LEFT JOIN TABLEC AS c
ON b.NewID...
"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, 2011 at 1:46 pm
Marios Philippopoulos (6/10/2011)
Grant's suggestion is something I had never considered before.
So, if I...
"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, 2011 at 1:38 pm
You're not using the right protocol or a protocol is not enabled on the server is my first thought? Or, maybe you've got the server name wrong? Maybe the name...
"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, 2011 at 12:50 pm
I know that we had lots of apps with issues, but I have to say, most of our servers were up at least 3-4 months at a time. They'd probably...
"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, 2011 at 12:49 pm
I'm not entirely sure I understand the problem as you defined it, but if I understand correctly, aren't we just talking about a series of queries with parameters? You pull...
"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, 2011 at 12:14 pm
Ah, well, since this is one of the DMOs that is only reset when the instance is restarted, I suspect it's not that vital.
"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, 2011 at 12:09 pm
LutzM (6/10/2011)
GilaMonster (6/10/2011)
LutzM (6/10/2011)
Some folks refer the transaction log backup as an incremental log backup though....
I can call a horse a car, doesn't make it one. Incremental backups != transaction...
"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, 2011 at 11:16 am
Viewing 15 posts - 12,361 through 12,375 (of 22,227 total)