Viewing 15 posts - 6,421 through 6,435 (of 22,219 total)
Sioban Krzywicki (4/8/2015)
... They're not a part of the community ....
And here we part ways.
"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 8, 2015 at 8:37 am
Koen Verbeeck (4/8/2015)
Koen Verbeeck (4/8/2015)
Grant Fritchey (4/8/2015)
"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 8, 2015 at 7:49 am
Koen Verbeeck (4/8/2015)
Grant Fritchey (4/8/2015)
"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 8, 2015 at 7:23 am
xsevensinzx (4/8/2015)
Grant Fritchey (4/8/2015)
Jack Corbett (4/8/2015)
Brandie Tarvin (4/7/2015)
Eirikur Eiriksson (4/7/2015)
Jeff Moden (4/7/2015)
"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 8, 2015 at 7:12 am
Probably get in a little trouble for this, but since I know that many of you are both SF fans and, let's just say, not on the same wavelength as...
"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 8, 2015 at 7:11 am
Jack Corbett (4/8/2015)
Brandie Tarvin (4/7/2015)
Eirikur Eiriksson (4/7/2015)
Jeff Moden (4/7/2015)
"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 8, 2015 at 7:02 am
If you mean that you need to track actions within the database, you should look to Trace or Extended Events to capture the queries that are performing actions that you're...
"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 8, 2015 at 4:43 am
Reverse that order logically and you should have your answer. You need to delete all the child table rows, then delete the parent.
"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 8, 2015 at 4:41 am
If it says ALTER VIEW, guess what's happening. The deadlock error is not going to lie to you.
"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 8, 2015 at 4:40 am
I'm with Luis. I don't like the normalization on DVD. I'll go one further, there is a movie (Luis used title) and there is the physical DVD itself. These are...
"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 8, 2015 at 4:39 am
But even with that filter, it's still going to show an execution count that is cumulative for the time that the query in question has been in cache. If you...
"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 8, 2015 at 4:31 am
The TABLOCK is probably the way to go, but understand, you're likely to be blocked by processes that are reading from the table. You can't take that kind of lock...
"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 8, 2015 at 4:29 am
Exactly.
"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 7, 2015 at 8:41 pm
dwain.c (4/7/2015)
dwain.c (4/7/2015)
-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar
-- gave me this...
"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 7, 2015 at 7:51 pm
It could be litespeed. It substitutes it's backup process for SQL Server, even if you're not calling it directly. Litespeed has a utility for unpacking backups to make them standard....
"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 7, 2015 at 7:49 pm
Viewing 15 posts - 6,421 through 6,435 (of 22,219 total)