Viewing 15 posts - 19,276 through 19,290 (of 22,226 total)
It's not the each one is a primary key. You're looking at the GUI and seeing a key next to each column. That means they're part of a compound primary...
"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
November 24, 2008 at 12:55 pm
Lynn Pettis (11/24/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
November 24, 2008 at 11:30 am
Absolutely not a cursor.
If you're getting the error that you're violating the primary key, it's simply because you are, in fact, violating the primary key.
The purpose of the primary key...
"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
November 24, 2008 at 11:25 am
Another vote for the Inside series of books. Fantastic stuff in there. Other than that, no other books come to mind as absolute must reads. You start to get into,...
"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
November 24, 2008 at 11:17 am
Sure sounds like a possible case for transactional replication.
"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
November 24, 2008 at 7:25 am
Yes.
If you want records that only meet the criteria defined AND records that don't, it seems a bit odd. What you're saying then is return everything.
The two limiting factors, 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
November 24, 2008 at 7:02 am
Actually, it looks like you've changed the structure of the query unnecessarily.
...from (Premium_Access
inner join Premium
on Premium_Access.rollup =...
"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
November 24, 2008 at 6:30 am
Please don't cross-post. There are now two different discussions going on about the same topic. Please continue discussion at the other location:
http://www.sqlservercentral.com/Forums/Topic607252-1291-1.aspx?Update=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
November 24, 2008 at 6:05 am
This is a cross-post with this http://www.sqlservercentral.com/Forums/Topic607251-149-1.aspx
I'd suggest keeping discussion here.
"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
November 24, 2008 at 6:04 am
Yeah, I was going to recommend SQL Compare from Red Gate too. There's also Apex SQL, they have a nice compare utility. Visual Studio Team System Database Edition comes 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
November 24, 2008 at 6:01 am
Nice article over here:
http://jmkehayias.blogspot.com/2008/09/monitoring-for-blocked-processes-on-sql.html
Interesting, but I'd need to read this on in more detail to see if it's really good:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1162653,00.html
Nice one from MS on technet
http://technet.microsoft.com/en-us/magazine/cc434694.aspx
"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
November 24, 2008 at 5:58 am
Your options are severely limited.
First, check the execution plan. Identify where the scans are occurring, if any, and see if you can affect them with an index or three. Think...
"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
November 23, 2008 at 10:28 am
GilaMonster (11/23/2008)
Grant Fritchey (11/23/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
November 23, 2008 at 10:20 am
Jeff Moden (11/23/2008)
Heh... no... haven't seen one like this before. The tools that generate code like this one and like Hibernate are gettin' kinda spooky and I've always resisted...
"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
November 23, 2008 at 9:29 am
Jeff Moden (11/23/2008)
Grant Fritchey (11/23/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
November 23, 2008 at 8:20 am
Viewing 15 posts - 19,276 through 19,290 (of 22,226 total)