Viewing 15 posts - 14,656 through 14,670 (of 22,219 total)
Yep, what he said. Just because the column is part of the primary key does not mean you can only use that. I used to have a sign up on...
"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 14, 2010 at 5:32 am
CirquedeSQLeil (7/13/2010)
Grant Fritchey (7/13/2010)
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...
"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:19 pm
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
Viewing 15 posts - 14,656 through 14,670 (of 22,219 total)