Viewing 15 posts - 18,946 through 18,960 (of 22,220 total)
I'd also suggest getting your DBA into the discussion here. They might have a good reason for using NOLOCK, or, more likely, they need a better understanding of what 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
December 23, 2008 at 6:11 am
Draw two intersecting circles. Circle 1 is your first table and Circle 2 is the second.
An inner join is the area within the intersection of the circles.
A left join 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
December 23, 2008 at 6:08 am
Glad I was a bit helfpul.
Yeah, I learn something new from Gail almost daily. On the rare occasions she doesn't teach me something new, she asks a question or makes...
"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
December 23, 2008 at 6:05 am
magarity (12/22/2008)
Grant Fritchey (12/22/2008)
Take the time & trouble to create the databases, keep them small and then copy and use attach scripts to put them onto the server.
Sorry, I don't...
"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
December 23, 2008 at 5:52 am
I agree with the rewrites. The simpler and clearer you can make the query, not only will it be easier for you, and those that come after you, to maintain,...
"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
December 22, 2008 at 6:20 pm
All the basics work fine, no issues. Intellisense doesn't work. There are some other newer bits & pieces that won't work.
For what it's worth, it works well on SQL...
"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
December 22, 2008 at 6:15 pm
Jim Russell (12/22/2008)
Since I can't attach .sql or .sqlplan files here, I have attached a .doc file which attempts to capture my situation. And in the process...
"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
December 22, 2008 at 6:05 pm
I just zip them and attach them.
"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
December 22, 2008 at 5:59 pm
It looks like an audition for "Singing in the Rain"
AAAAAAAaaaaaa!
"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
December 22, 2008 at 5:55 pm
The primary key is the unique identifier in the table. That's it's primary purpose, a constraint on data so that each row is uniquely identified. However, it can also 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
December 22, 2008 at 9:11 am
As you've already discovered, it's possible. I'm not sure I'd recommend it though. Take the time & trouble to create the databases, keep them small and then copy and use...
"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
December 22, 2008 at 7:00 am
Without at least an execution plan, we're just not going to be very specific in helping you.
Yeah, you might be accessing the clustered index, but you might not. It depends...
"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
December 22, 2008 at 6:54 am
Also that it's going to the right database. I've seen the default database used and it isn't immediately obvious.
"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
December 22, 2008 at 5:51 am
Paul (12/20/2008)
"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
December 22, 2008 at 5:45 am
It's either a really poorly written query or you have blocking. You need to look at, at least, sp_who2.
Also, can you get the execution plan? Query sys.dm_exec_query_plans if you can't...
"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
December 22, 2008 at 5:39 am
Viewing 15 posts - 18,946 through 18,960 (of 22,220 total)