Viewing 15 posts - 18,706 through 18,720 (of 22,226 total)
gyessql (1/16/2009)
Grant Fritchey (1/16/2009)
"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
January 16, 2009 at 12:35 pm
You could make the Course and Unit pk into a compound PK that includes AccountId. Then the UnitCourse table will have an added column used as a constraint against each...
"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
January 16, 2009 at 10:43 am
mike.sortino (1/16/2009)
"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
January 16, 2009 at 7:12 am
Paresh Prajapati (1/16/2009)
But page lock is lock all other rows which is not required to be lock, so other process which has require those rows then it is not geninune..
Yes,...
"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
January 16, 2009 at 7:03 am
For all those people who want employees treated "fairly" you'll need to define "fair." Does it mean identical, in that, all DBA's are paid 30K? Does it work of seniority,...
"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
January 16, 2009 at 6:42 am
If you're getting this sophisticated with dynamic SQL, then you really need to look into sp_executesql instead of simply using the exec statement. sp_executesql will allow you to define parameters...
"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
January 16, 2009 at 6:35 am
I wish it was available online, but if you can track down the final copy of the SQL Standard, I wrote an article comparing TOP, MAX and ROW_NUMBER as a...
"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
January 16, 2009 at 6:23 am
Regarding Performance: It depends, but yes, CROSS APPLY can be used in place of an INNER JOIN in some situations to realize a performance benefit. It's only going to work...
"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
January 16, 2009 at 6:15 am
I'm hoping we can get it to 100 pages. Then it should die. Horribly. Suffering.
"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
January 16, 2009 at 6:05 am
MarkusB (1/16/2009)
The only way to set...
"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
January 16, 2009 at 6:03 am
No. I don't want to be angry at anyone becuase they're making more than I think they're worth and I don't want anyone angry at me for the same reason....
"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
January 16, 2009 at 5:54 am
Paresh Prajapati (1/15/2009)
U have to require row level lock with some range of columns..
Really? What happens if you're updating more than one row? What about if you were updating 1/2...
"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
January 16, 2009 at 5:52 am
GilaMonster (1/15/2009)
There's a school just down the road. I tried it. Didn't enjoy it at all.
There's too much emphasis on the sport side, where to strike to score points and...
"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
January 15, 2009 at 12:52 pm
GilaMonster (1/15/2009)
Grant Fritchey (1/15/2009)
We don't train with a wakizashi at my dojo and I've never tried it.
Neither do we. I have a couple books and I'm seeing if I 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
January 15, 2009 at 12:13 pm
GilaMonster (1/15/2009)
"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
January 15, 2009 at 11:23 am
Viewing 15 posts - 18,706 through 18,720 (of 22,226 total)