Viewing 15 posts - 15,271 through 15,285 (of 22,219 total)
Presumably, with an index on the column and the LIKE operator only have a wild card at the end of the string, you have a sargeable (search argument able) query....
"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 6:43 am
No, waits are not because of inadequate storage. It's because either the network, or the storage system itself, is running slow and causing SQL Server to wait on it. Most...
"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 6:38 am
First thing I noticed is that you have two table scans, not clustered index scans. Unless you have a very good reason, most tables should have a clustered index. I'd...
"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 6:36 am
This is only an issue if SQL Server is sharing that system with other applications. If it is, you're probably going to hit issues because, to put it mildly, 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
April 29, 2010 at 6:21 am
david.wright-948385 (4/29/2010)
Another advantage of "create/alter" over "drop/create" is that the latter leaves the database without the object for a (usually short) amount of time.
True, but since it's usually run within...
"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 6:07 am
Late getting back in, but Paul answered the questions same way I would have, only better.
"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 6:04 am
It was answered over there.
"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 6:02 am
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
Viewing 15 posts - 15,271 through 15,285 (of 22,219 total)