Viewing 15 posts - 15,286 through 15,300 (of 22,227 total)
TRACEY-320982 (4/28/2010)
Thanks - I thought you could do it in the MOSS 2007 version too..but it appears from the replies it just the 2010 Sharepoint version.
Yep. Just 2010. Kind of...
"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
April 29, 2010 at 5:55 am
I admire your teacher. This homework problem actually sounds like a bit of fun to solve rather than the usual library or shopping cart examples.
But the other guys are right....
"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
April 29, 2010 at 5:27 am
Steve Jones - Editor (4/28/2010)
Hate the UK. It's not the US 😉
We can't hate the UK. They have really good beer.... Let's blame France instead. Their beer sucks.
"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
April 29, 2010 at 5:24 am
Jack Corbett (4/28/2010)
CirquedeSQLeil (4/28/2010)
Tom.Thomson (4/28/2010)
CirquedeSQLeil (4/28/2010)
Thus, don't ever log out and your visit will stay low (so long as the cookie doesn't expire).
That's right.
And you got in fast there Jason,...
"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
April 29, 2010 at 5:23 am
2cams (4/29/2010)
The Tempdb is staying at the 35Gig mark. We are happy to leave it at that size as it is not growing to fill 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
April 29, 2010 at 5:22 am
krypto69 (4/28/2010)
Thanks GrantIs there a way to put all thre into one statement?
Nope. INSERT/DELETE/UPDATE operations are done one table at a time.
You can wrap it all in one 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
April 28, 2010 at 1:31 pm
I am not joking when I say, this looks like the example code I use to demonstrate why RBAR (row-by-agonizing-row pronounced rebar) queries are slow.
Yes, walking through a set of...
"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
April 28, 2010 at 1:27 pm
lmu92 (4/28/2010)
Grant Fritchey (4/28/2010)
"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
April 28, 2010 at 1:22 pm
izdede (4/28/2010)
I set up the perfom from my machine. I select the computer I want to monitor by select remote computer to run perfmon...
"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
April 28, 2010 at 12:53 pm
I'm sorry, I can't understand entirely what you're describing.
Why can't you use referential integrity?
BTW, you mention a view that enforces integrity. Views are simply select statements. They can't enforce integrity...
"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
April 28, 2010 at 11:39 am
Without more details, it's kind of hard, but basically, assuming TableA is the parent and TableB & TableC have foreign key relationships to the table, and that the column that...
"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
April 28, 2010 at 11:37 am
At this juncture, I'd go straight to 2008 R2, skip 2005 and 2008 entirely.
As far as the upgrade process, if you can, the safest way to do it 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
April 28, 2010 at 11:32 am
Maybe it's just me, but it sounds like you just need to delete stuff off the server.
If this location also has your data files, one thing to look for 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
April 28, 2010 at 11:29 am
Ninja's_RGR'us (4/28/2010)
Grant Fritchey (4/28/2010)
Ninja's_RGR'us (4/28/2010)
Assuming this job has already run succesfully in the past :
1 - Either the permissions changed (NTSF or sql login)
2 - You're out...
"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
April 28, 2010 at 11:12 am
only4mithunc (4/28/2010)
So do you mean to say, if the table has an index (on the column on which WHERE condition is applied ) the above order of execution...
"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
April 28, 2010 at 11:11 am
Viewing 15 posts - 15,286 through 15,300 (of 22,227 total)