Viewing 15 posts - 13,216 through 13,230 (of 22,219 total)
Pouliot Philippe (2/16/2011)
Grant Fritchey (2/16/2011)
"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
February 16, 2011 at 8:25 am
Well, no, not really. You're saying that the other tables have no type of relationship to the other data at all, but, you want to somehow put it all together.......
"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
February 16, 2011 at 8:23 am
kvr1985 (2/16/2011)
thank you guys. it's working.i have a one more doubt how to do server wide trace?
Please read the article I posted. That's how you do a trace.
"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
February 16, 2011 at 8:19 am
I ran a series of tests, years ago, where I opened multiple default traces on SQL Server. I had 20 running at the same time and i didn't change performance...
"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
February 16, 2011 at 8:15 am
That is a GIANT topic. You really need to develop your own story. If you don't have the knowledge yet to be able to walk someone through what you would...
"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
February 16, 2011 at 7:34 am
GilaMonster (2/16/2011)
Ian Scarlett (2/16/2011)
Grant Fritchey (2/16/2011)
but I think I'm right on this one if implicit transactions are on.
I also thought that if you executed a procedure on a connection with...
"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
February 16, 2011 at 7:19 am
Marco V (2/16/2011)
Grant Fritchey (2/16/2011)
And now it's a new one. It was time to change.did the post trigger it?
Yep. Wouldn't have bothered probably. I'm not overly driven by it. Just...
"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
February 16, 2011 at 7:07 am
Ian Scarlett (2/16/2011)
Grant Fritchey (2/16/2011)
"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
February 16, 2011 at 7:02 am
And now it's a new one. It was time to change.
"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
February 16, 2011 at 6:59 am
muten79 (2/16/2011)
I have been having a read about best practices when designing a database.
I have developed an application using OIDs (object identifiers) for any class I will store 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
February 16, 2011 at 6:53 am
No one script is going to tell you what you need. There are just too many variables that you haven't defined for me to suggest a single point of focus....
"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
February 16, 2011 at 5:28 am
kvr1985 (2/16/2011)
thank you for informationi will read the article later .how can find the slow running queries.
You can find slow running queries by using a server-side trace to gather metrics...
"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
February 16, 2011 at 5:25 am
Assuming a standard stored procedure, when the procedure reaches it's end. With a query outside of a procedure, when the batch completes (there's a go statement or it's the end...
"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
February 16, 2011 at 4:34 am
There was a chat about Babylon 5 one day and I decided to switch. I'm too lazy to make it something else. That's about it.
"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
February 16, 2011 at 4:32 am
Are you sure the only difference is hardware? How much different is that hardware? Are there multiple CPU's in UAT but not in Dev or vice versa? What are 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
February 16, 2011 at 4:31 am
Viewing 15 posts - 13,216 through 13,230 (of 22,219 total)