Viewing 15 posts - 15,331 through 15,345 (of 22,227 total)
Bhuvnesh (4/28/2010)
Nitin-900948 (4/28/2010)
You can drop the index on this table. Then insert the data and recreate the index. It will reduce the time of index update durig insert.
thats 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 28, 2010 at 5:49 am
sudhakara (4/28/2010)
Grant Fritchey (4/26/2010)
Can you get the information running this query?
SELECT CONVERT(sysname, SERVERPROPERTY('servername'));If not, you may have an issue with the server, it's configuration, your connections... not sure.
Yes. That select...
"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 5:47 am
Roy Ernest (4/27/2010)
Grant Fritchey (4/27/2010)
Roy Ernest (4/27/2010)
Grant Fritchey (4/27/2010)
The Dixie Flatline (4/27/2010)
What do you think I have 15 acres of woods for?
Woods are good. They provide fuel for...
"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 5:15 am
And you need to identify queries that using a lot of I/O to see what they're doing. You can track down the causes and address them.
"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 5:14 am
Roy Ernest (4/27/2010)
Grant Fritchey (4/27/2010)
The Dixie Flatline (4/27/2010)
What do you think I have 15 acres of woods for?
Woods are good. They provide fuel for fire and draw game...
"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 27, 2010 at 1:23 pm
The Dixie Flatline (4/27/2010)
What do you think I have 15 acres of woods for?
Woods are good. They provide fuel for fire and draw game to your vicinity. ...
"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 27, 2010 at 1:17 pm
Adam Machanic (4/27/2010)
Lynn Pettis (4/27/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 27, 2010 at 1:02 pm
itskumar2004 (4/27/2010)
Grant Fritchey (4/26/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 27, 2010 at 9:13 am
Brandie Tarvin (4/27/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 27, 2010 at 8:33 am
Brandie Tarvin (4/27/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 27, 2010 at 8:23 am
Brandie Tarvin (4/27/2010)
Grant Fritchey (4/27/2010)
Brandie Tarvin (4/27/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 27, 2010 at 8:15 am
Brandie Tarvin (4/27/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 27, 2010 at 6:52 am
If you're keeping your database code in source control (which, if you're not, you should), you either need to use the drop/create or you have to maintain two sets 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 27, 2010 at 6:51 am
And when you're unsure of what the optimizer will do with a query, take a look at the execution plan. That'll give you the information you need.
"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 27, 2010 at 6:47 am
Paul White NZ (4/27/2010)
Grant Fritchey (4/27/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 27, 2010 at 6:40 am
Viewing 15 posts - 15,331 through 15,345 (of 22,227 total)