Viewing 15 posts - 14,671 through 14,685 (of 22,232 total)
CirquedeSQLeil (7/13/2010)
Anybody have a good source concerning the "don't index tables with less than 1000 rows" optimization technique?
It's not 1000 rows, it's a 1000 pages and, it's a made up...
"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
July 13, 2010 at 7:33 pm
Novicejatt (7/13/2010)
I can Arhive the files in a datewise format. But Can you explain this a little more how to use this with BULK INSERT.
I also found a solution by...
"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
July 13, 2010 at 6:59 pm
Jeff Moden (7/13/2010)
Stefan Krzywicki (7/13/2010)
Jeff Moden (7/13/2010)
CirquedeSQLeil (7/13/2010)
As a rule of thumb, once a table has more than five indexes, updates to that table...
"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
July 13, 2010 at 6:47 pm
Couldn't connect to a 2005 server real quick, but I got this off of MSDN. It should be there in 2005.
"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
July 13, 2010 at 11:09 am
itsmeman (7/13/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
July 13, 2010 at 10:20 am
brandon_ledbetter (7/13/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
July 13, 2010 at 9:37 am
brandon_ledbetter (7/13/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
July 13, 2010 at 9:11 am
thinknight (7/13/2010)
How could i know just restore succeeded?According to this code:
declare
@qStr varchar(512),
@i int
set @qStr = 'RESTORE DATABASE ...'
EXEC @i = sp_executesql @qStr
PRINT @i
Fails....
You're not using standard syntax for 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
July 13, 2010 at 8:12 am
You need to do three more things. First, you should also monitor the wait states and queues on the system so you know what is causing things to slow down....
"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
July 13, 2010 at 8:10 am
shivanee.chikhalikar (7/13/2010)
I am adding the foreign key using the following query
ALTER TABLE RepairCategoryDetail
ADD CONSTRAINT FK_RepairCategoryDetail FOREIGN KEY (CategoryId)
REFERENCES RepairCategoryMaster(CategoryId);
But it is giving me an following error
There 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
July 13, 2010 at 6:26 am
It completely depends on what events and columns the trace is collecting. Most people are running very benign traces capturing RPC & Batch Completes with only 8-12 columns of data....
"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
July 13, 2010 at 6:23 am
Jason Shadonix (7/13/2010)
Now, helpful bit out of the way, I'm not going to laugh at the network engineer getting stuck with the DBA job, that happens, but I will laugh...
"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
July 13, 2010 at 6:16 am
phil.cooper.2 (7/12/2010)
I am a LAN/WAN/desktop network engineer. The company I presently work for seems to think that database work falls under that scope.
Go ahead- I'll wait for the jeering, laughing,...
"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
July 13, 2010 at 6:02 am
ibzmiller (7/13/2010)
Yes plenty of testing ahead. No I don't think there are any clustered indexes. It has just been a matter of, theres a table. No consideration on how...
"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
July 13, 2010 at 5:50 am
Novicejatt (7/12/2010)
I do not want to use SSIS yet. I'm only working with SQL queries. Say I have a table with fixed no. of columns. I want to schedule 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
July 13, 2010 at 5:26 am
Viewing 15 posts - 14,671 through 14,685 (of 22,232 total)